Hi there,
I would like to share with you a very useful query we can get in SCCM, the query I am talking about is “MAC” address query.
Probably you are asking why? One of the common SCCM issues is during task sequence deployment you get the following error:
select SMS_R_System.MACAddresses, SMS_R_System.Name, SMS_G_System_OPERATING_SYSTEM.Name, SMS_R_System.LastLogonUserName from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId