We have property “_PG_AppsCenter_Inventory” that we use to collect all managed applications that are installed on specific workstation using our standard naming convention
For each application we have the following info
7Zip|7-Zip – v19.00 SCV6|v19.00 SCV6|7-Zip 19.00 (x64)|02/05/2021 20:31:03 +0100
AdobeReader17|Adobe Reader DC – v20.013.20064 SCV5|v20.013.20064 SCV5|Adobe Acrobat Reader DC|02/05/2021 20:31:20 +0100
Now I would like to create report that would show for each application the install count but based on the Title
Using below session relevance
(it, multiplicities of it) of unique values whose (it is contained by set of (“7Zip”;“AdobeReader17”;“BFHealth”;“AzureViewer”)) of (preceding texts of firsts “|” of it) of values of results of bes properties whose( name of it contains “_PG_AppsCenter_Inventory”)
I get following output (Dev environment)
I would like use the title instead of the name and to add we can have multiple versions of specific application
any suggestions are welcome.
thx for all the help.