Friday, 15 June 2012

Collection for MAC Address

If you are having issues with machines being renamed and need to locate it in SCCM why not try searching by MAC address?

Use this query and just adjust the MAC accordingly:

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System where SMS_R_System.MACAddresses = "XX:XX:XX:XX:XX:XX"

No comments:

Post a Comment

Let me know if this helped.

I'd really appreciate any comments (well, only nice ones) so please feel free to let me know what you think of the blog and also ask for further help...