Skip to content

SCCM MAC address report

Featured Replies

I have created a query in SCCM to report on MAC Address, IP and and machine name as per query below:. My issue is that when i select the colelction I want to view, it displays everything in my organisation adn not just on the collection i selected. Please advise how I can get the report to only display as per collection required.
SELECT v_RA_System_ResourceNames.Resource_Names0 AS [Resource name], v_RA_System_MACAddresses.MAC_Addresses0 AS [MAC Address],

v_RA_System_IPAddresses.IP_Addresses0 AS [iP Address]
FROM v_RA_System_MACAddresses INNER JOIN
v_RA_System_ResourceNames ON v_RA_System_MACAddresses.ResourceID = v_RA_System_ResourceNames.ResourceID INNER JOIN
v_RA_System_IPAddresses ON v_RA_System_MACAddresses.ResourceID = v_RA_System_IPAddresses.ResourceID

Your query is not written to limit the results to a collection. This sample query will get you started. http://sccmug.ca/2014/01/13/limiting-a-report-to-a-collection/

 

BTW, you will get interesting results with that query. aka you will get more than 1 IP address for a computer. Why not look at the built-in reports for this?

  • Author

yes, i know....it duplicates alot of stuff :(

 

Which built in reports can I use? I could not find anything that would give me machine name, mac and IP address

  • Author

But what I actually nede is a query were I specify why collection I want from from the drop down box.

yes, i know....it duplicates alot of stuff :(

 

Which built in reports can I use? I could not find anything that would give me machine name, mac and IP address

 

No only will it duplication the data, it will give you old data.

 

There are two network folders.. try them.

But what I actually nede is a query were I specify why collection I want from from the drop down box.

 

Because you didn't tell the query to limit to a collection. Look at my blog post link as your starting point.

  • 1 year later...
  • Author

I get this error when using the query from your blog:

 

Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.v_Collection'.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.