Video Screencast Help

Altiris Report

Created: 23 Oct 2013 | 4 comments
KalpeshParmar's picture

How do i customise report for a perticular software?

Thanks in Advance. 

Comments 4 CommentsJump to latest comment

James007's picture

Check this SQL query

Zac H

How about this?

SELECT vc.Guid, vc.Name AS ComputerName, arp.DisplayName, arp.DisplayVersion, vu.Name AS UserName, vu.Department
FROM vComputer vc
ON vc1.Name = vc.Name
INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid
INNER JOIN vUser vu ON vc.[User] = vu.Name
WHERE arp.DisplayName LIKE 'Adobe Flash Player 10%' AND arp.InstallFlag=1
Trusted Advisor mclemson Comments

There are default reports available for you if you go to Reports > All Reports, then expand Reports > Discovery and Inventory > Inventory > Cross-platform > Software/Applications > Installed Software or Installed Software by Computer. For example, using the Installed Software report, type '%Adobe%' for the Company OR '%Lync%' for the Name

KalpeshParmar's picture

Hi  Zac H,

I used querty provided by you but there is error msg like "

Msg 208, Level 16, State 1, Line 1

Invalid object name 'vComputer'.


and for other solution(Or)
it shows only counts version wise so i use to go in details and collect details for each version that is time consuming..
Please suggest..
James007's picture
Do you need more help here?