Jump to content


kesh

SCCM MAC address report

Recommended Posts

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

Share this post


Link to post
Share on other sites


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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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'.

Share this post


Link to post
Share on other sites

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...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...