Hi there,

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
                          (SELECT     spi.Name
                            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

Anthea