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.

Creating Software Installed Report

Created: 26 Aug 2012 • Updated: 30 Aug 2012 | 5 comments
This issue has been solved. See solution.

Hi there,

I am a new user of Altiris and would like to create a report with the below fields:

Search Feild as: Software name%

Results in report as: Installed Software Name, User of Asset, Asset Number, Division of User

Would someone please be able to advise the easiest way to create this report? Or a script I can paste in to a new report that would work?

Thank you :o)


Comments 5 CommentsJump to latest comment

Anthea's picture

Hi Ashish,

Thank you for your comment.

I have used the below report stated in one of the forums:

SELECT vc.Guid,vc.Name, arp.DisplayName,arp.DisplayVersion

FROM vComputer vc

JOIN Inv_AddRemoveProgram arp ON arp._ResourceGuid=vc.Guid

WHERE DisplayName LIKE 'Adobe Flash Player 10%' AND arp.InstallFlag=1

I need to add in extra fields however, how do I do this? I need user name and department/division.



Zac H's picture

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
Mohammad Bamya's picture

When ever i use vcomputer i always make usre to use Ismanaged =1

Mohammad Bamya

Anthea's picture

That is awesome, thank you so much for your help :o)