The Software Compliance Status report is returning no results for certain MSD policies frequently used
Last Updated April 12, 2019
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 to Subscribe