SQL Query To Find Machine Resources With No SMS Unique Identifiers Or GUIDS

 

This SQL Query will list all of the machine resources that do not have an SMS Unique Identifier or GUID.

 

SQL Query:

 

Select

SD.Name0 'Machine Name'

 

From System_Disc SD

 

Join MachineIdGroupXRef ID

On SD.ItemKey = ID.MachineID

And IsNull (SD.Sms_Unique_Identifier0, '')

<> ISNULL(ID.Guid, '')

 

 

Published Monday, December 22, 2008 9:38 AM by dhite
Filed under:

Comments

No Comments