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)

Anthea

 

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.

Thanks

Anthea

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
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
SOLUTION
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)