Altiris Report to find out Computers with software not installed.

escribano1976's picture
escribano1976
August 12th, 2009

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

Filed under: ,
0 votes
KSchroeder's picture
KSchroeder
14 weeks 4 days ago

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
If your question has been resolved, please be sure to click "Mark as Solution"! Thank you.

0 votes
escribano1976's picture
escribano1976
14 weeks 4 days ago

Hi, when i run this query i

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

Thanks

0 votes
jharings's picture
jharings
14 weeks 3 days ago

Add to the select statement

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

Jim Harings
Technical Solutions Consultant
Xcend Group
http://xcendgroup.com

0 votes
spastor's picture
spastor
14 weeks 3 days ago

Hello, Try changing arp.guid

Hello,

Try changing arp.guid to arp._Resourceguid

Regards
Santi

0 votes
KSchroeder's picture
KSchroeder
14 weeks 3 days ago

Doh!

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

Thanks,
Kyle
Symantec Trusted Advisor
If your question has been resolved, please be sure to click "Mark as Solution"! Thank you.

0 votes
escribano1976's picture
escribano1976
14 weeks 2 days ago

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

0 votes