PDQ.com mobilePDQ.com desktop
Support

Creating custom Inventory reports in AA Console using SQL

Shane CorellianShane Corellian
·

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.

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.

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.

Don't miss the next post!

How PowerShell can calculate your retirement

How PowerShell can track 401K growth

In this blog, I use PowerShell to focus and build a 401k calculator because its tax advantages make it ideal to build your retirement nest egg.

PowerShell