Report to fetch last 2 month data of incident where incident state changed to pending

[Rangasamy Sugan]

Hi,

Report to fetch last 2 month data of incident data where incident state was changed to pending with their pending reasons.

[Saurabh Gupta]

Hi @Rangasamy Sugan 
This can be achieved using metric.
https://your_instance.service-now.com/incident_metric_list.do?sysparm_query=mi_definition%3D35f2b283...

 

[Rangasamy Sugan]

Hi @Saurabh Gupta  , Could you please elaborate like please specify the conditions to fetch the data.. 

Please confirm if you were saying about incident metric table.

[Saurabh Gupta]

Hi @Rangasamy Sugan 

Yes, incident metric table.

[AshishKM]

Hi @Rangasamy Sugan,

As you are looking for history data in state change to pending from 2 month, simple report will not give the desired result on current state of incident and it's not recommended to run query over system audit table. 

You can check the OOTB metric_definition and get the metric_instance records

If this metric not helpful, create new definition for future report.

-Thanks,

AshishKMishra

-Thanks,

AshishKMishra