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.

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?