Report and Dashboard creation for Business continuity (Disaster Recovery)

[Vivian Lowrance]

I am looking to create reports and dashboard in Core UI for Business continuity (Disaster Recovery) to track approvals. 

 - Who owns each plan
- What state the plan is in
 - Who approved it
 - Who hasn’t approved it yet

e.g. We have X number of plans, who Owns the plan, state and who are the approvals waiting on.

Thanks for your help in advance.

[Dr Atul G- LNG · Accepted solution]

Hi @Vivian Lowrance 

To create the report, you can use the BCP tables—there’s a field called ‘Owner’ that you can include in the report.
For approvals, you’ll need to create a report on the sys_approval table.
In short, this is doable. Please get started and share your feedback with us once done

[Vivian Lowrance]

Thanks Atul. I was able to create the reports as you provided a solid solution. For Business continuity Plan report, I used sn_bcp_plan table and grouped by Plan name. And for approvals report, I used sysapproval_approver table, grouped by Approving and filter condition Source table is sn_bcp_plan.

[Dr Atul G- LNG]

Perfect mate.. Glad you did it.