Client Management Suite

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

Check this fourms may be help

https://www-secure.symantec.com/connect/forums/create-report-list-managed-software-computer-altiris-71

 Software Component Management Best Practices

https://www-secure.symantec.com/connect/articles/software-component-management-best-practices-swm-70

Hi Ashish,

The Forums dont help unfortunately, I am a new user of Altiris and they are too complicated for me.

Is it possible for someone to change the below script/report from showing only managed software to showing all Software Installed?

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

Quick guess just remove the "AND sps.IsManaged=1" part, as thats the place wher it only joins managed software products to the query.

Thank you so much Sascha!!!!! That works perfectly.