List of Major Incidents with Post Incident Reports not published

[juanvillalt]

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.

[Dr Atul G- LNG]

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.

[Bhuvan · Accepted solution]

@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]

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

[Laveena-Agarwal]

Hi @juanvillalt 

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