Client Management Suite

Any idea to find the report of the partcular installed xyz software?

example - office

find the attach forum for the sql query

https://www-secure.symantec.com/connect/forums/sql-report-software

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

Hi

You can find the report of all installed software from Altiris at mention path

Reports > Discovery and Inventory > Inventory > Cross-platform  Software/Applications > Software > Installed Software

You can find the particular software using % sign

eg -DisplayName LIKE 'Adobe Flash Player 10%

https://www-secure.symantec.com/connect/forums/how-get-report-altiris-71

SQL Query

SELECT vc.Guid, vc.Name AS ComputerName, arp.DisplayName, arp.DisplayVersion, vu.Name AS UserName, vu.Department