Client Management Suite

Hi

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

[SQL Report]

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

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

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

Check this thread also

https://www-secure.symantec.com/connect/forums/altiris-report-ms-products

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?

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

Thanks, I'm new

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