This query will return to you the NetBIOS name for each MachineID in your SMS site. This can be helpful when using the resource explorer to quickly and easily find the machines host name.
SQL Query:
Select
MachineID, Name as 'Machine Name'
From _Res_Coll_SMS00001
Where _Res_Coll_Sms00001.ArchitectureKey = 5
Order by Name ASC
No Comments