Report showing computers without specific software

Question

There seems to be a lot of questions, but no answers in this community.  Not overly optimistic anyone will respond, let alone answer, but here goes.

Is it possible to run a report to show computers that don't have AV installed?

I can run a report that shows the computers that do have it.  Is it possible to edit the SQL directly?

dang · Answer

dbetlow:  When I run the standard report, I get a list of the following:  domain, computer name, name (directory) which is blank, drive (directory) which is also blank, path (directory) blank, etc...etc...

I would edit the directory report, and then add what directory you are looking for, to see if it exists.  When you run the report, you'll get everything that patch manager knows about, you'll just filter after it's run, to show the computers that don't have the directory.

Or you could edit the files basic report so you look for a specific file.

Hope that helps

dbetlow · Answer

Thanks.  According to Spiceworks, I don't have any devices without AV, but it considers Windows Defender AV.  Fooling around with the Spiceworks reports to see if I can get it to work, but I'm thinking the Solarwinds Patch Manager might be more accurate if I can get it work.

dbetlow · Answer

What should that report look like without any customization?  I see 1 row per device, but the name, drive, path, 8.3 filename, and directory columns are all blank.  I tried a couple different filters but nothing is returned.