Report for list of servers that do not have antivirus installed

[sriihs]

Hi Experts,

Looking for this report since a couple of days and not getting any ideas. I am able to pull up a report   that gives me a list of servers where antivirus is installed, but i need something like give me the list of servers that do not have the antivirus and the system should search in the installed software list and return the server name if it does not find the antivirus there. I am using the software installation table.

[Chuck Tomasi · Accepted solution]

If you're using the software installation table, then it's not possible to report against the absence of something.

The approach I would take is create a new boolean field (perhaps av_installed). Default it to false, then run a script on your software installed table to turn it on for each server it finds. You can then run a report against the server records where av_installed is false.

If you run the report regularly, you'll want to keep that field up to date as the installed software records changed. Perhaps a scheduled job or business rule.

[sriihs]

Thanks, will try as suggested

[moresr]

Hi Chuck,

I have similar requirement but are looking for such reports for 4 different software like antivirus , cisco agent etc.

What should be approach in such scenario, Could you share any sample script ?

Thx

SM