Quick Delivery Status and Detail reports are not returning any results
search cancel

Quick Delivery Status and Detail reports are not returning any results

book

Article ID: 261392

calendar_today

Updated On:

Products

Client Management Suite IT Management Suite IT Management Suite

Issue/Introduction

Evt_Task_Instances has a lot of data in it as your company makes use of the Quick Delivery tasks, but running the following reports results in 0 rows:

  • Quick Delivery Status by Task 
  • Quick Delivery Status by Computer
  • Quick Delivery Details by Task 
  • Quick Delivery Details by Computer

Environment

ITMS 8.6

Resolution

Make a backup of each of the QuickDeliveryStatus... and QuickDeliveryDetails... stored procedures and then commented out this from each Stored Procedure:

AND i.ClassGuid = '98ED4AEB-6C8E-472F-8AEE-E213016CA4FF'  

Complete list of the Stored Procedures modified:

  • sp_GetQuickDeliveryStatusByTask
  • sp_GetQuickDeliveryStatusByComputer
  • sp_GetQuickDeliveryDetailsByTask
  • sp_GetQuickDeliveryDetailsByComputer

The report then displayed the data expected.

 

Powered by Wolken Software