insightVM query goal for sofware product AND version

InsightVM
1

Hi, I’m trying to create a query for use in a goal to show a specific software product with a specific name where the software.version is NOT the latest version.

However, because the version part of the query is querying all software and not being confined to the specific software in question it doesn’t work. I’ve got a horrible feeling the answer to this is obvious and i’m just not seeing it.

For example, a computer has Software A with the latest version being 5.1. It also has Software B on version 3.2. The query to show all assets with ‘Software A’ and software version NOT 5.1, still includes this asset because it has Software B that isn’t on version 5.1. I can do this using a SQL query report, but i’d like to do it to use in a Goal to ensure specific software is up to date - can this be done?

Thanks

1 Like
2

Hi, it’s a famous one. Use expert mode and select all assets with software A version 5.1, then put () around your query and negate it by putting ! in front . so
!(your query finding what you want to exclude).
This will find everything else.

1 Like
3

Thanks Jack - that’s solved it for me