Underutilized Software report parameter "Application" doesn't work if you select No on parameter Show metered software only

Products

• Inventory Solution
• Client Management Suite
• IT Management Suite

Issue/Introduction

With the Underutilized Software report, if you set the Show metered software only parameter to "No", the Application parameter no longer filters the results.

Environment

ITMS 8.5

Cause

This is a defect.

Resolution

This issue will be addressed in 8.5 RU3.

To work around the issue in 8.5 RU2, use the attached modified report that is fixed.

1. Download the attached XML to the SMP Server.
2. In the console browse under Reports > Software > Application Metering.
3. Right-click on Application Metering and choose Import.
4. Select the report and choose to import it.
5. When imported, the name is "Modified Underutilized Software".

If you are using 8.5 - 8.5 RU1, use the following method:

Go into Edit mode and look for the following:

AND ('%Domain%' = '%' OR i.[Domain] = '%Domain%')
    AND ('%Application%' = '%' OR LOWER (f.[Name]) LIKE LOWER 
('%Application%'))
    AND spu.IsUsageTracked = 1 OR '%Show metered software only%' = 'No'
    GROUP BY

--Should have ( ) around the third AND line, as shown: 

AND ('%Domain%' = '%' OR i.[Domain] = '%Domain%')
    AND ('%Application%' = '%' OR LOWER (f.[Name]) LIKE LOWER 
('%Application%'))
    AND (spu.IsUsageTracked = 1 OR '%Show metered software only%' = 'No')
    GROUP BY

Make the change and that should fix the report.