Video Screencast Help

Altiris Report to find out Computers with software not installed.

Created: 12 Aug 2009 • Updated: 21 May 2010 | 6 comments

Hi is there any way to create a report which will tell me the computers wich doesn't have a certain software installed?
Thanks

Comments 6 CommentsJump to latest comment

KSchroeder's picture

A quick report:

SELECT vc.Name, vc.Domain, vc.[User]
FROM vComputer vc
LEFT JOIN Inv_AeX_OS_Add_remove_Programs arp
ON vc.Guid = arp._ResourceGuid
AND arp.Name = 'Your Software Here'
WHERE arp._ResourceGuid IS NULL
AND vc.IsManaged = 1  -- Only machines with Altiris installed
AND vc.[OS Name] LIKE '%Windows%'  -- In case you have Unix/Mac/etc

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

escribano1976's picture

Hi, when i run this query i get this error
Invalidid column name 'Guid'.

Thanks

jharings's picture

add vc.guid to end. This will display in the report, but you can hide it later.

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.

spastor's picture

Hello,

Try changing arp.guid to arp._Resourceguid

Regards
Santi

KSchroeder's picture

Yeah, stupid me I do that all the time!  Thanks for finding that Santi.

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

escribano1976's picture

Hi Santi, thanks it works now...
One more question.. we have some software that doesn't show up on Add Remove programs...
Is it possible to create a report that will look onto C:\Program Files\My Software and report which computers doesn't have this directory?
Thanks