Jump to content

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...