Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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.