Client Management Suite

 View Only
  • 1.  Report with Software and its application Category

    Posted Sep 20, 2012 06:30 PM

     

    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?

     



  • 2.  RE: Report with Software and its application Category

    Posted Sep 21, 2012 06:24 AM

    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?



  • 3.  RE: Report with Software and its application Category

    Posted Sep 21, 2012 09:29 AM

    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.



  • 4.  RE: Report with Software and its application Category

    Posted Sep 21, 2012 03:01 PM

    SELECT spi.Guid AS [Product Guid]
         
    ,spi.Name AS [Product Name]
         
    ,SoftwareType.Name AS Category
         
    ,spv.[Version]
    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