Here you will find a SQL query to list SMS client resources that have generated new SMS ID’s along with their Resource ID and the timestamp that the change was generated.
In SMS a new SMSID (SMS Unique ID) or GUID (Globally Unique Identifier) is created when any of the following are changed on your client resources:
SmBIOS Serial Number
The Machine’s System Identifier (SID)
Any one of 10 different Hardware ID Properties
Additional Microsoft Information:
"The Hardware ID mechanism examines 10 computer properties and generates an ID of the Properties by combining hashes of the properties into a single ID. If a certain number of these properties change, the computer is considered, and a new SMSID is created. The number of properties is 3 out of 10 for a desktop computer and 2 of 7 for a laptop computer."
SQL Query:
Select Distinct
SYS.Netbios_Name0 'Machine Name',
Convert(VarChar(10),
SYS.SMS_UUID_Change_Date0, 101) 'Change Generated',
SYS.ResourceID ID
From v_R_System SYS
JOIN v_R_System NEW on SYS.SMS_Unique_Identifier0 = NEW.Previous_SMS_UUID0
Order By 'Machine Name'
No Comments