Jump to content

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.


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