Report "Execution Attempts" report shows no data in "Name" column for Managed Delivery policies
search cancel

Report "Execution Attempts" report shows no data in "Name" column for Managed Delivery policies

book

Article ID: 258279

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

While checking the Report for "Execution Attempt" we can notice that Names for the tasks might be missing for Managed Delivery policies, while it shows correct data for Patch and Quick delivery tasks.

Environment

ITMS 8.6.x

Cause

During the localization process, while verifying task names for different languages, due to the missing value (no language) - the report would return an empty value.

Resolution

The issue has been fixed in the ITMS 8.7 Release.

Meanwhile, the attached Stored procedure can be applied on the 8.6 RU3 release to resolve the issue.

To apply the provided Stored Procedure. Please backup your CMDB database or backup existing sp_SWM_SoftwareDeliveryExecutions. And then execute the attached SP in SQL Management Studio.

Attachments

1674469109549__fixed sp_SWM_SoftwareDeliveryExecutions 8.7.sql get_app