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 dynamic collection for multiple version app installation

Hi!

Advise please how I can perform filtering to create dynamic collection with any two (or more) version of named Application?

For example: how to create dynamic collection with PCs where more than one 7-zip versions at installed app list is present. Any two or more versions while app name starts "7-Zip".

Thx!

1

Comments

5 comments
Date Votes
  • Danylo,

    You can probably do this with a SQL report. This will help you start: https://chartio.com/learn/databases/how-to-find-duplicate-values-in-a-sql-table/

    1
  • Thx, Luke,

    I may try do it with SQL. But I need dynamic collection as result, to be able to resolve such situations automatically. Not a report to just know about occasion.

    0
  • Danylo,

    Because 7-Zip includes the version number in the name, the easiest way would be to create a collection as shown below. In my example, I am including any computers that have either 7-Zip version 16.02 or version 19.00 installed. You can add sections as necessary for additional specific versions. 

    If you are looking for a program that doesn't have the version in the name you can do it more like this.

    0
  • Hi Gray,

    Thx!

    7-zip or Java its just a sample. It's obvious solution if I have limited known versions of software. But if I have 5-8 different legid versions of the same program on multiple systems. And what I need is dynamic collection with PCs with more than one equal %software_name% with different %version% so to speak.

    0
  • I may be misunderstanding your need, but dropping the 'application version contains' and just using the 'application name contains' would get you all installations of that software name, regardless of version. You can also identify which computers have a combination of different software names and versions, but to help with the logic for that I would need to know more specifics.

    0