Video Screencast Help

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)