Jump to content
mangoman264

Basic AV Status Report

Recommended Posts

Hey all,

We're running into some limitations with the health history queries for the stock AV health report (too many agents, query takes too long to run), and I'm looking to modify the stock report to: show all computers for the client, whether they're at risk or not, and their current definition date. I got this from support on pulling definition data straight from the SQL backend using a query

virus definition date is stored in the computers table, in the field named virusdefs, so a query like this will get you a list of computers, their clients, and the AV definition date:

  SELECT cl.name, c.computerid, c.name, c.virusdefs FROM computers c LEFT JOIN clients cl ON c.clientid = cl.clientid;

 

Can anyone help me modify the stock report to pull and show the current status and definition date for a client, instead of referencing any historical data? 

Please and thank you!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×