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

Community Alums
Not applicable

Hi,

 

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

9 REPLIES 9

Saurabh Gupta
Kilo Patron

Hi @Community Alums 
This can be achieved using metric.
https://your_instance.service-now.com/incident_metric_list.do?sysparm_query=mi_definition%3D35f2b283c0a808ae000b7132cd0a4f55&sysparm_view=

 


Thanks and Regards,

Saurabh Gupta

Community Alums
Not applicable

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.

Hi @Community Alums 

Yes, incident metric table.



Thanks and Regards,

Saurabh Gupta

AshishKM
Kilo Patron
Kilo Patron

Hi @Community Alums,

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

 

AshishKMishra_0-1703178083653.png

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

 

-Thanks,

AshishKMishra

 

 

 

 

 

 

-Thanks,

AshishKMishra


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution