Issue reported:

While importing device for build image getting error as like below screen shots.

Solutions:

This error reports when user is trying import device to the console. to fix issue follow below steps.

Step 1: Find GUID or MAC ID and delete from console. below is WMI query will help to create query and it will prompt mac id as like below screen shoot enter MAC and validate whether device is already in SCCM Record if yes then delete.

WMI QUERY for prompt MACAddresses.

select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from SMS_R_System where SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses## order by SMS_R_System.MACAddresses

After executing query below screen will appears.

Step 2: Once confirm device status in SCCM record. if device available in console delete. you want to verify with other aspect as Open sql studio and execute below query.

select * from vSMS_R_System where SMS_Unique_Identifier0 like GUID:54A44B40E-BC7C-4D0E-B9F6-B3E3EF44969A.

Note: GUID: Will be change according on reported error.

Step 3: If still you are able to see the reported error GUID You can delete by running below query.

delete from vSMS_R_System where SMS_Unique_Identifier0 like GUID:54A44B40E-BC7C-4D0E-B9F6-B3E3EF44969A you will see 1 row affected.

Step 4: After doing above step try to import device and it will work as normal.

Happy Learning!!!

Thanks & Regards,
Haresh Hirani
Email: [email protected]
Follow me: Twitter @hirravi1
linkedin: https://www.linkedin.com/in/hiraniconfigmgr