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.

Dynamic filter for application with specific version

Hi all,

I have an application that is installed with 2 different names, e.g. Application 1 and Application1 which might differ per client.

I would like to have a dynamic filter that shows me only those clients that have either one of this application installed. Also I would like to be able to filter for version number because in some cases there are multiple versions of Application1 installed and I am only interrested in version 1.

 

I tried something like in the attached file but when I change the version name of the application the returned number of clients is still the same which is not correct.

 

How should I deal with this?

 

Thanks,

 

Ruud




ScreenShot127.jpg
0

Comments

1 comment
Date Votes
  • You're probably going to need two Dynamic collections, one that shows computers with Application1 and another with Application 1 (and probably a third that shows that neither is installed and maybe a fourth that shows both installed). Filtering logic doesn't contain statements for either/or*, just AND (all/not all) and OR (any/not any).
    In your screenshot, you are saying the following

    • All Computers with AD path that contains Workstations AND
    • Any of those computers with an application name that equals Application 1 OR
    • Any of those computers with an application name that equals Application1 OR
    • Application version equals 1

    This means a computer could have version 2 and would still show up since it has Application1
    This means a computer could have no version and would still show up since it has Application1

    What will likely work in this instance:
    Application 1 Collection
    All Computers with AD path that contains Workstations AND
    Any of those computers with an application name that equals Application 1

    Application1 Collection
    All Computers with AD path that contains Workstations AND
    Any of those computers with an application name that equals Application1

    Now, you could then create another Dynamic Collection that says something along the lines of
    All computers in Application 1 Collection AND
    All computers in Application1 Collection

    As for versions, you can add that to any collection, though depending on how many versions, separate collections are usually a better options (you can see how versioning is done is the collections included in Inventory). In your screenshot, because you use the filter, "Any", you're saying If X OR Y, not X AND Y. You want to filter by version, you would want ALL: Application Name Equals Application1 & Application Version Equals 1

    Here are some excellent videos on creating dynamic collections:
    PDQ Inventory Advanced Collections - Group by Filters 
    Advanced Collection and Report Filtering in PDQ Inventory
    Advanced Collections and Report Filters - Part II

    *NOTE: You can use regular expressions to filter particular rules. For instance, you could create a rule that matches a regular expression and use "Application1 | Application 1" to indicate a return value of either Application1 OR Application 1. Or ?! for not, etc.

    0