Video Screencast Help

Report with Software and its application Category

Created: 20 Sep 2012 | 3 comments

I need to create a report with managed software which is associated to an Apllication category. I want a report to know how many software were deployed from which category. I am abled to get the managed software and category sepratelly but i am not able to associate them in a single report.

Can anyone help me?

Comments 3 CommentsJump to latest comment

michael cole's picture

I didn't understand much of what you said about categories, but you can get an installed software report by right clicking on your SWD policy name and selecting reports > Software Compliance Report. Can you tell me more or is that a solution?

Michael Cole

Principal Business Critical Engineer

Business Critical Services

kareddy's picture

I want a report in which i can get the softwares based on there category.

For example:

If in the report i chose Desktop Apllication i should be able to get all the software application which are categorised as desktop application.

i am able to find all the managed applications and all the software categories.But i am not able to link them up and sort based on categories.

Andrew Bosch's picture

SELECT spi.Guid AS [Product Guid]
      ,spi.Name AS [Product Name]
      ,SoftwareType.Name AS Category
FROM vRM_Software_Product_Item spi
LEFT JOIN (SELECT ra.ParentResourceGuid AS ProductGuid, sti.Name
           FROM ResourceAssociation ra
           JOIN vRM_Software_Type_Item sti
              ON sti.Guid = ra.ChildResourceGuid
              AND ra.ResourceAssociationTypeGuid = 'AE4DBDF7-457B-4828-A83E-B64B91AE0E87'
          ) SoftwareType
   ON spi.Guid = SoftwareType.ProductGuid
LEFT JOIN Inv_Software_Product_Version spv
   ON spv._ResourceGuid = spi.Guid

Sr. Principal SQA Engineer