(imported topic written by jfschafer)
I ran a query for Adobe Acrobat with a filter on Total Runs = Null (to find system that never ran the software). I got 23 systems returned (all showing no runs).
I then ran a query but instead of Total Runs = Null I choose Total Runs = Less Than 5. Got a result of 17. Looking at the results, none of them show systems with 0 runs. So it looks like 0 is not less than 5 within the DSS query system.
Thanks!
(imported comment written by SystemAdmin)
The issue here is that DSS SAM filters do not treat “null” as zero on the View All report tab. This is tracked as bug 41073.
There are a couple ways to get the data you’re looking for:
Option A) Run two different reports (one for Total Runs = Null; one for Total Runs less than 5), export each as CSV and combine in a spreadsheet.
Option B) Build the query using the “Find records matching ‘any filter’”, sort by application name, export to CSV, crop the data down to just Acrobat.
Here are the steps…in all cases where Total Runs = Null, you will see the Averages calculations also = Null. So you can build your query this way:
a) At the top of the Filters dialog, select “Find records matching ‘any filter’”
b) Set “Total runs less than 5” and set “Avg runs per day is null”. Do not set a filter for software properties (because the “any filter” will be applied and match all cases)
c) Click Apply to apply the filter. You will now have all apps that have been run less than 5 times, including the null case.
d) Click the Application column for the primary sort. Hover over the right edge of the Total runs column and you will see a “2” appear to represent the secondary sort. Click when you see the “2”.
You now have all apps sorted first by application name and then by usage data – zero (null) through 5.
e) Export to CSV. Use a spreadsheet or text editor to cut out the applications that you’re interested in.