Altiris Report to find out Computers with software not installed.
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
discussion Filed Under:
Comments
A quick
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.
Hi, when i run this query i
Hi, when i run this query i get this error
Invalidid column name 'Guid'.
Thanks
Add to the select statement
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.
Hello, Try changing arp.guid
Hello,
Try changing arp.guid to arp._Resourceguid
Regards
Santi
Doh!
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.
Hi Santi, thanks it works
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
Would you like to reply?
Login or Register to post your comment.