itkroplis Posted November 9, 2012 Report post Posted November 9, 2012 Hi! How create sccm 2012 reports for all MAC address after collection? Quote Share this post Link to post Share on other sites More sharing options...
0 GarthMJ Posted November 9, 2012 Report post Posted November 9, 2012 Here you go. http://smsug.ca/blogs/garth_jones/archive/2012/11/09/list-all-mac-address-with-service-names.aspx Quote Share this post Link to post Share on other sites More sharing options...
0 itkroplis Posted November 10, 2012 Report post Posted November 10, 2012 It is possible that the query is a good one: select CS.Name0, NAC.ServiceName0, NAC.MACAddress0 from dbo.v_GS_COMPUTER_SYSTEM CS Join dbo.v_GS_NETWORK_ADAPTER_CONFIGURATION NAC on CS.ResourceID = NAC.ResourceID But it is not clear how to make this query to add the web reporting. Quote Share this post Link to post Share on other sites More sharing options...
0 GarthMJ Posted November 11, 2012 Report post Posted November 11, 2012 Yes that query can be used to create CM12 report. Create the report just as you would for any other report. Quote Share this post Link to post Share on other sites More sharing options...
Hi!
How create sccm 2012 reports for all MAC address after collection?
Share this post
Link to post
Share on other sites