There are certain Managed Software Delivery policies that are returning no results when the console user right-clicks on the policy and selects "Reports > Software Compliance Report"
There had been many computers that had the software installed via the MSD policy.
Management Platform 8.5 RU1
The affected MSD policies have a space at the beginning or the end of the name.
At runtime, the policy name, along with other parameters, is passed to the stored procedure "sp_SWM_SoftwareComplianceStatus", but as they are passed in by the report handler-- the spaces at either, or both ends of the policy's name is removed.
The SQL logic within the stored procedure uses a LIKE statement but since the report stripped the spaces from the policy's name, but they still exist in the database with the spaces in the name-- the report does not match any policy name to any software.
This issue is resolved in 8.5 RU2. Previous to that release, see the below for working around the issue:
The easiest solution is to remove spaces if they exist at either end of the policy's name; or replace them with an underscore or a valid, visible character.
Attached to this article is a modified version of which includes a wildcard sequence at each end of the input parameter ('%'+@in_PolicyName+'%' ) on line #63
Subscribing will provide email updates when this Article is updated. Login is required.