List of Major Incidents with Post Incident Reports not published

juanvillalt · 3 weeks ago

For major incidents (MI), you can publish a post incident report (PIR). I'm looking at a way to get a list of all MI that that have the PIR yet to be published. I haven't found any flag or anything that tells me that the MI is still to publish the PIR.

Bhuvan · 3 weeks ago

@juanvillalt

Check 'sn_sow_inc_post_incident_review' table and see if you can build the logic to get the list of Major Incidents that do not have status as published. When Major Incident is Resolved, it will create entry in this table and can be used to create the reports.

Thanks,

Bhuvan

View solution in original post

Dr Atul G- LNG · 3 weeks ago

Hi @juanvillalt

Correct, there is no way to get this information. There is no flag or any state that indicates whether the PIDR has been downloaded.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Bhuvan · 3 weeks ago

@juanvillalt

Check 'sn_sow_inc_post_incident_review' table and see if you can build the logic to get the list of Major Incidents that do not have status as published. When Major Incident is Resolved, it will create entry in this table and can be used to create the reports.

Thanks,

Bhuvan

juanvillalt · 3 weeks ago

This is exactly what I was looking for. Thanks Bhuvan. This will help.

Laveena-Agarwal · 3 weeks ago

Hi @juanvillalt

can you share the screenshot , how you are publishing it?