Inventory Report for Computers with Specific Applications
I need a report for a list of PCs that have two specific applications installed, we will refer to them as App1 and App2.
App1 is installed on a mixture of devices across our infrastructure, App2 is installed on almost all of our devices.
I've written the basic query as:
ALL
- Application Name Contains APP1
- Application Name Contains APP2
The report returns no results.
If I change ALL to ANY, I get every computer
I've tried every variation I can think of including group filters, etc.
My management team wants a report of all the devices with APP1 and the version, to include the version of APP2.
Collections always seem to take forever to build and a report should be quick and easy.
-
Roger,
You seem to be having the same issue as in this post: https://help.pdq.com/hc/en-us/community/posts/360054713432-Report-filter-not-working-properly
Your workaround solution is to do it in a collection instead of a report. Other than that you'd have to contact PDQ support and put in a ticket.
I think the issue is that your report logic is asking for you to return computers where a single application contains both APP1 and APP2. I don't know how to fix the logic to have it look for two apps on the same computer that match APP1 and APP2. You might be able to do it with a SQL report if you're proficient in SQL.
-
It's because the behavior of the Filters in Reports changes when you have multiple tables in the Columns tab. See this reply for more details: https://help.pdq.com/hc/en-us/community/posts/360056822192/comments/360009190492
Please sign in to leave a comment.
Comments
2 comments