Managed Software Report
I am a new user of Altiris and need help amending a report. The current report I have shows all managed software installed on machines from the software catalogue sorted by company division.
I would like to search by company division and get results of all managed software.
Currently when I search the division only managed software that has the exact name of what's installed on the asset is showing up. How can I change this to all software within the software product (i.e any name changes - Adobe Acrobat Professional 9 is the name of the Managed Software product, however the software is installed on the asset as Adobe Acrobat 9 Pro and therefore not showing up in the report).
The below is the script used for the report I currently have. Is it possible for someone to please amend so I can paste back in with the results I require?
SELECT DISTINCT vc.Guid, vc.Name, vc.[User], ar.DisplayName, vu.[Display Name], vu.[Job Title], vu.[Office Location], vu.Department
FROM vComputer AS vc INNER JOIN
Inv_AddRemoveProgram AS ar ON ar._ResourceGuid = vc.Guid AND ar.InstallFlag = '1' INNER JOIN
vUser AS vu ON vu.Name = vc.[User] AND ar.DisplayName IN
FROM vRM_Software_Product_Item AS spi INNER JOIN
Inv_Software_Product_State AS sps ON sps._ResourceGuid = spi.Guid AND sps.IsManaged = 1) AND vu.Department ='%Department%'
ORDER BY ar.DisplayName, vc.Name
Thank you so much for your help