Report managed software with category

I do not need a solution (just sharing information)

Previsouly posted was

with no anwser. A request to include the the Category for a Managed Software.

I just figured this out via a SQL query, and wanted to post just in case anybody else had this request.

    vsp.Name  [Software Product]
    , Company
    , Category
from vsoftwareproduct vsp 
join ResourceAssociation ra1 on ra1.ParentResourceGuid = vsp.Guid  and ra1.ResourceAssociationTypeGuid = ‘D5C66D5A-7686-4CA2-B7C1-AC980576CE1D’  –>> resource associaton for Company
join vitem co on co.Guid = ra1.ChildResourceGuid                  –>> Software Product Company
join ResourceAssociation ra2 on ra2.ParentResourceGuid = vsp.Guid and ra2.ResourceAssociationTypeGuid = ‘AE4DBDF7-457B-4828-A83E-B64B91AE0E87’   –>> resource association for category
left join vsoftwaretype cgt on cgt.Guid = ra2.ChildResourceGuid   –>> Software Product Category
left join Inv_Software_Product_Version ver on ver._ResourceGuid = vsp.Guid   –>> Software Product Version

Regard 🙂



  • No Related Posts

Leave a Reply