Major Incident Workbench - PIRs

[JayJack]

Hi, 

I'd like to run a report to show whether a PIR is complete for all Major Incidents.

I'm struggling to find the table which would allow that to happen???

Many Thanks

[Abbas_5]

Hello @JayJack,
Please refer to the below link's:
https://docs.servicenow.com/bundle/vancouver-it-service-management/page/product/incident-management/...

https://www.servicenow.com/community/developer-forum/how-to-add-or-edit-pir-tab-under-major-incident...

If it is helpful, please mark it as helpful and accept the correct solution.

Thanks & Regards,
Abbas Shaik

[Dr Atul G- LNG]

Hi @JayJack 

Very valid question and I tried at my end but no success. I did not get any field which capture this info,as MIM workbench is a UI page. 

May be log a Now Support case to get more from SN.

[JayJack]

Thanks Atul, appreciate the response.

[Nirupama Reddy]

Hi JayJack, 

All the surveys or assessments will be stored in asmt_assessment_instance table. You can add condition like metric type is Major incident PIR survey. You can refer "state" column for PIR completion status. 

Please mark helpful if this is something you are looking for.