SQL Query To Filter Out Clients With Invalid System Enclosure Asset Tag Information

 

This SQL Query will filter out all of the invalid system enclosure asset tags using NOT NULL, Not Like (<>) and NOT IN SQL commands.

 

SQL Query:

 

Select

SD.Name0 'Machine Name',

SD.User_Name0 'User Name',

SE.SmBiosAssetTag0 'Asset Tag'

 

From v_R_System SD

Join v_GS_System_Enclosure SE On SD.ResourceID = SE.ResourceID

 

Where SD.Client0 = '1'

And SE.SmBiosAssetTag0 Is Not Null

And SE.SmBiosAssetTag0 <> '%ΓΏ%'

And SE.SmBiosAssetTag0 not in ('Not Available', 'No Asset Information','')

 

 

 

Published Sunday, September 07, 2008 12:24 PM by dhite
Filed under:

Comments

No Comments