Start Date: and End Date: parameters in the Compliance and Delivery reports for Software Management do not appear to work as expected

Products

• Software Management Solution

Issue/Introduction

"Start Date" and "End Date" parameters in the Compliance and Delivery reports for Software Management do not appear to work as expected

For example, if a Software Release was created on February 1st, then delivered between May 1st and May 30th, running the Execution Summary, Execution Status and or Software Compliance reports and selecting, May 1st for the "Start Date", May 30th for the "End Date" will return no results.

N/A

Cause

The reports rely on following part of the SQL stored procedure:

“where (ic.ClassGuid = '2D3A170E-5028-4570-BA0C-3DB775CB8BDE' OR ic.ClassGuid ='b10b4142-bcbf-4071-a7df-a069311f2840') AND vi.CreatedDate BETWEEN @in_StartTime AND @in_EndTime“

Therefore are looking at the Created Date for the Policy or task being reported on, not the execution data during the specified range.

Resolution

This is working as designed but has been brought up as a concern to be looked at for future versions.