You could try to make the program name equal to: "like" = "Microsoft Office".
I have that for the query but I am talking about the column set for the output of the query. I'd like to make a qualifier that has the "Like" but I can't seem to modify the "=".
Only problem with how you have yours is that the results columns will return all programs and versions. The query is only looking for devices with that software on them, not necessarily going to tell you what is on the returned devices. That's what the column is doing in the bottom right. The column is going to be filtered based on the results of the "qualifier". The only thing they would need is a "like" in the qualifier.
To correct this assumption - the presumed requirements around qualifiers is not entirely true (anymore).
It certainly *WAS* true (I *think* as far back as 9.0 if I'm not mistaken) - but we've been essentially pre-qualifying based on the query parameters for years (pretty sure since 9.5 if not earlier - memory's foggy). If you're an old LANDesk user, then yes - it certainly was the case in the past - but hasn't been like that for a while now .
Here's an example of what I'm talking about as a "case in point":
I've set up a simple query searching for 1 piece of software - 7zip - in the "Add and Remove" category that you are looking through. I've then also "just" added the "Add and Remove - NAME" column to my intended columns to be viewed.
NOTE -- I have *NOT* filled out any of the QUALIFIER field.
Now - running the query, I get "just" hits back where the intended string matches (so "7zip" in my case) - the rest of the software stack doesn't get mentioned/listed:
You can then just change the sort order to be by product name. Does that cover what you're trying to do?
Hope this helps.
Can confirm you are correct. I've been using LD since 8.8 at my old job. I setup 9.6 here at the new and didn't even consider trying that!
Happy to help.