Reports "Quick Delivery Details and Status" are not returning any results
search cancel

Reports "Quick Delivery Details and Status" 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

The Evt_Task_Instances table has a lot of data in it and your company makes use of the Quick Delivery tasks, but running the following reports results in 0 rows.  These tables are found in the SMP Console under:

Reports > Software > Delivery > Status

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

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

Each report then displayed the data expected.

 

Powered by Wolken Software