Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Inventory Report for Computers with Specific Applications

Roger Pray

March 10, 2020 18:44

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.

Comments

2 comments

lnichols
March 10, 2020 19:42

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.

1
Colby Bouma
March 11, 2020 21:42

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

1