Get MAC address query SCCM 2012

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 “MACaddress query.

Probably you are asking whyOne of the  common SCCM issues is during task sequence deployment you get the following error:

sccm error
The best way to fix it is to remove the computer (DDR) record from the SCCM database, How can we know what is the computer name?, once you have the computer MAC address you can create a query that will provide you the computer name and MAC address and then you try to locate the computer name under your collection and delete it.
Please take this query and save it in your queries repository:
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