Video Screencast Help

query for non software data

Created: 24 Apr 2013 • Updated: 02 May 2013 | 3 comments
This issue has been solved. See solution.


is there any query/report which can show me the systems where the particular software not installed?

Comments 3 CommentsJump to latest comment

consoleadmin's picture

Read it


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


W007's picture


Look this discussion

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.