Skip to main content desktop
Try Now

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.

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:

    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!

8 ways to protect your business from ransomware

Ransomware attacks are on the rise, and it's only a matter of time before your business becomes a target. Learn how to protect yourself before it's too late.

© 2021 Corporation
  • PDQ Deploy ®
  • PDQ Inventory ®
  • SimpleMDM
  • Pricing
  • Downloads
  • Licensing
  • Buy