Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Altiris Solution

Created: 03 May 2013 • Updated: 04 May 2013 | 2 comments
This issue has been solved. See solution.

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

example - office

Comments 2 CommentsJump to latest comment

technical_specialist's picture

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

akgs's picture

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

FROM vComputer vc
RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
ON vc1.Name = vc.Name
INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid
INNER JOIN vUser vu ON vc.[User] = vu.Name
WHERE arp.DisplayName LIKE 'Adobe Flash Player 10%' AND arp.InstallFlag=1
SOLUTION