Inventoried Software Titles All Inventoried Software Titles SQL Query

 

Provided here is a SQL version of the Asset Intelligence inventoried software titles all inventoried software titles report.

 

SQL Query:

 

Select

CommonName 'Product Name',

IsNull(CommonPublisher, '') Vendor,

IsNull(CommonVersion, '') Version,

CategoryName Category,

FamilyName 'Family Name',

IsNull(Tag1Name, '') 'Label 1',

IsNull(Tag2Name, '') 'Label 2',

IsNull(Tag3Name, '') 'Label 3',

'State' = Case

When State = 4 Then 'Uncategorized'

Else 'Validated'

End

 

From v_LU_SoftwareList_Editable 

Order by CommonName

 

 

Published Sunday, November 23, 2008 2:58 PM by dhite
Filed under:

Comments

No Comments