Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Managed Software Report

Created: 26 Aug 2012 • Updated: 02 Sep 2012 | 4 comments
This issue has been solved. See solution.

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

Comments 4 CommentsJump to latest comment

Anthea's picture

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

SaschaH's picture

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

Bechtle – your strong IT partner. Today and tomorrow

If that seems to help, please "Mark as Solution"

SOLUTION
Anthea's picture

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