I have a semi-large user base (approx 600 clients), all of them with standardized and individual applications. We manage most of the software with PDQ, but users are allowed to install their own software as well.
From time to time, some of the applications that are installed won't get upgraded, and we end up having many different versions of the same software in our environment. This can be because the application doesn't support any form of auto-upgrade, the auto-upgrade fails, some software can only be upgraded when the users connect to our VPN (which some of them can't be bothered to do), Windows Update doesn't always do it's job and many other reasons.
Examples:
Chrome (at one point we had 15 different versions), Adobe Reader (7 different versions) and Microsoft Edge (36 (!) different versions). Example picture:
(The value is "Computer Count", not "Computer Name", despite what the picture says.)
My task:
To know which software that's got many different versions and has to be manually handled, I want to make a report and a filter.
The report is a standard PDQ one, that lists client count, application name and application version. However, I only want to see applications that has more than 4 different versions.
I can't find any filter or report variable that lets me filter out applications that have less than a certain number of occurrences.
I know that you can script an SQL report, but I wouldn't know where to begin with that.
As presumed from my description, up to 4 occurrences is fine, such as this:
Does anyone know if such a filter exist, or a way to achieve the desired result?
