In this article we will create a Custom Inventory Report inside of Admin Arsenal. This report will show all computers that do NOT have Symantec Antivirus service installed / configured.
From the main window in Admin Arsenal select "New Report..." item in the Reports menu.
Now we write our query. I used the Fields dropdown menu to select the appropriate Table / Field.
This query simply requests that the Computer Name, AD Description, OS Name and Last Inventory Scan Date be returned for every computer that does NOT have a Windows Service called Symantec Antivirus.
Click here to download the video if you cannot access the YouTube version above
If you want to see a list of all Oracle software and versions on all servers you can use this SQL:
Computer.Name as "Computer",
Software.DisplayName as "Software",
Software.DisplayVersion as "Version"
from Computer inner join
Software on Software.ComputerId = Computer.ComputerId
where Software.Publisher like '%oracle%' and
computer.osname like '%server%'
This is an updated post from 2010.