Report and Dashboard creation for Business continuity (Disaster Recovery)

Vivian Lowrance
Tera Contributor

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.

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

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

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

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

View solution in original post

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

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

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

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

Vivian Lowrance
Tera Contributor

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.

Perfect mate.. Glad you did it.

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

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