Creating custom Inventory reports in AA Console using SQL

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.

Another Example

If you want to see a list of all Oracle software and versions on all servers you can use this SQL:

select 
    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.