Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

query for non software data

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

hi

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

https://www-secure.symantec.com/connect/forums/alt...

 

Query

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

Thanks.

SOLUTION
W007's picture

hello,

Look this discussion

https://www-secure.symantec.com/connect/forums/rep...

 

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