Not easily that I can think of.
Your problem is that you have two (very) opposite result sets that you want to join up. And usually the query tools operate on a principle of specifically INCLUDING or EXCLUDING certain results - not combining the two.
You COULD go for a column set potentially, but that'd kill you with kindness (/clutter) more likely than not.
In SQL terms, that'd be quite doable via a UNION statement ... SQL UNION Operator .
You COULD probably try to swing it that way and just write 99% of your report query as a SQL statement - but that'd require the following:
1 - you need to be familiar with SQL.
2 - You need to know about the application you're trying to report on (as different applications can be different levels of pain in the neck to do so accurately on).
3 - You need to be OK with the report designer & using the SQL section in there (and you should be able to UNION-ise.
Out of curiousity - why is the fact that you'd have 2 separate reports (one list of devices WITH the software and one WITHOUT it) an issue / headache? Would've thought that it'd provide a more direct "kill list" as it were?
The info that I'm pulling is for an audit. I wanted my data to all machines, and a yes or not about a particular software application.
So, the only way I can think of doing this, outside of SQL, is to use a qualifier for the application name column. This should show you all devices and only fill in the application name column for those that have the said application. For the actual query condition, chose something like Device Name exists so you don't limit the results.
Here is a detailed doc on custom queries Custom Database Queries: How they work, guidelines on creating them, and examples of them in action
Yep - a qualifier would work.
So - create a query for "all devices" (i.e. - something like this) - leaving the default columns seleced:
Now - separately - create a column set with the data that you want / need. In this case, I've used JUST the default 3 columns and added a 4th one being one of the software Package Titles & use the QUALIFIER field/button to specify the bit of software you're after:
I'm using "Software - Package - Title" just as a guiding example.
You may want / need to use a different field to find the software you're after - there's some "it depends on your software" stuff here. Either way, the detail wouldn't be that much different.
After having created your column set, you then DRAG & DROP the column-set on to your query ... and you'll end up with a result like this:
As you see, 2 of my 3 devices do NOT have the software package I was specifying, where as the server VM does have it - and shows it.
That is then something you can just export / save as CSV or "view as report" and that should be that, no?