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
RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1
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
 
Or
 
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

https://www-secure.symantec.com/connect/forums/how-get-report-altiris-71#comment-8284511

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?