Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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