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