Video Screencast Help

SQL Report software

Created: 21 Feb 2013 • Updated: 22 Feb 2013 | 7 comments
This issue has been solved. See solution.

Hi

I need a report that shows all the Microsoft software that are installed on the computer.

[SQL Report]

Operating Systems:

Comments 7 CommentsJump to latest comment

Sumit G's picture

Check the below

Report to Display List of Software Installed on Machines When a List of Usernames is Given

https://www-secure.symantec.com/connect/blogs/report-display-list-software-installed-machines-when-list-usernames-given

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
 
 
 
Note : You can Change Software name Like :'Adobe Flash Player
 

Check thread

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

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

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

Regards

Sumit G.

rs_cert's picture

Check the attach Thread

https://www-secure.symantec.com/connect/forums/report-software-and-its-application-category

 

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

SOLUTION
jre357's picture

thanks..!

SELECT
      spi.Name AS microsoft
      ,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
 where  spi.Name like 'Microsoft%'

 

 

 

as I close the question?

Sumit G's picture

Yes, if the comment helpfull then mark as a solution that comment.

Regards

Sumit G.

rs_cert's picture

Same syntax i have provided on above comment which you have mark as a solution with different comment.