Jump to content
itg_techmike

Using AV monitor software missing to only identify computers not using our installed AV

Recommended Posts

I have created a copy of the AV-SoftwareMissing monitor and I'm trying to tweak it so it only triggers if the Virusscanner field doesn't match what our Antivirus solution ID is.  I have build the query correctly in SQLyog but this carry over to the monitor I'm not sure what I've missed.  I'm in no way a MySQL/SQL novice or expert so I request a second set of eyes.  Thank you.

My SQL query that returns the correct information I need to run the monitor against.

SELECT NAME,Domain,Virusscanner FROM Computers
WHERE Virusscanner NOT IN (217,263,264,265) 

I have attached the image from the monitor config.

AVMissingMonitor.jpg

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

×