AnsweredAssumed Answered

Incident Reports

Question asked by rkalidh87 on Aug 1, 2015
Latest reply on Aug 3, 2015 by William Teixeira

Hi,

 

I have recently migrated BOXI from one server to another server. Post migration, Reports are providing wrong data.

 

I am generating a report for number of incidents between 1st july and 31st july but it provides data for august 1st also.

 

I have checked the same in old BOXI server where it provides me correct data. please help me to fix this. Below is the query and report attached.

 

SELECT

  in.ref_num,

  in.open_date,

  in.resolve_date,

  in.status_symbol,

  in.incident_area_symbol,

  in.incident_priority,

  in.close_date,

  in.configuration_item_name,

  in.configuration_item_description,

  in.summary,

  in.resolution_code_symbol,

  in.parent_ref_num,

  in.urgency,

  (in.resolve_date - in.open_date),

  in.zsolution_desc,

  in.description,

  in.zapplicable_sla,

  in.priority_symbol,

  in.sla_violation,

  in.zresponse_sla_violation,

  PdmString(in.symptom_description)

FROM

  in

WHERE

  ( (( in.open_date ) between @Prompt('Earliest Open Date', 'D', ,mono,free) AND @Prompt('Latest Open Date', 'D', ,mono,free) )  )

Outcomes