1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

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.

Report filter not working properly

Avatar
Wayne Osteen

I know this should work, but it's not. Any ideas?

I want to know machines where *both* applications are installed. Either filters properly, both does not.

 

 

Thanks!

Wayne

1

Comments

2 comments
Date Votes
  • Avatar
    lnichols

    Wayne,

    Interesting find, I don't know why this isn't working. I tried every permutation I could think of with the group filters and I couldn't get it to work. I also tried several different types of SQL reports and couldn't get it.

    The weird thing is that these exact same filters work for a collection, but not for a report. As I see it, you have a few options:

    • Create a collection with those same filters and then run a report with no filters against that collection
    • Try to figure out a SQL report to do this. I tried (and failed) to construct a SQL report with an outer query for application #1 and then a subquery for application #2 since I couldn't figure out how to do it all in one query, but if you're better at SQL than me then you can probably make this work.

    I would open a support case with PDQ as well-- this is probably a bug, given that it works for a collection but not for a report. For reference, my PDQ Inventory version is 17.1.0.0 Enterprise Mode and I was able to reproduce your issue.

    2
  • Avatar
    Wayne Osteen

    Thanks for the second set of eyes Luke! I created a collection and it did indeed work.

    I'm opening a ticket right now with support. Cheers!

    1