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 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