Sunday, 28 August 2016

SCCM Prompt Query to find Machine Name Using MAC address

During the OSD deployment you may faced issue with known machine in SCCM database. Even thought you deleted the machine, somehow the MAC address register in SCCM database in different name.

Below is the prompt query which helps to find computer name using MAC address.

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

No comments:

Post a Comment

SCCM Collection Relationships Using SQL Queries

  In System Center Configuration Manager (SCCM), collections are used to group systems or devices based on specific criteria for easier mana...