Reporting on BIA analysis

[geogeorge]

Hello,

I’m working on Business Continuity Management (BCM) in ServiceNow, and I need help building a report that identifies dependency risks in BIA assessments.

In the Business Continuity Workspace → Dependency Assessment, I can see cases where:

• The parent BIA has a faster recovery tier (example: Tier 0 – Mission Critical)
• But one of the dependent applications has a slower recovery tier (example: Tier 2 – Essential)

This creates a misalignment in RTO expectations, and we want to capture these cases in a report for risk analysis.

Here is an example from the Dependency Assessment UI (screenshot provided):

• Parent BIA → Tier 0
• Dependent Application → Tier 2 (or higher RTO hours)

---

What I want to achieve

I need a report or dashboard widget that automatically highlights:

All BIAs where the Parent BIA’s RTO/Recovery Tier is lower (faster) than a dependent application’s RTO/Recovery Tier.

Essentially:

Dependent RTO Tier > Parent RTO Tier

or

Dependent RTO Hours > Parent RTO Hours

---

Questions

1. Which table(s) should be used for reporting these dependency items?
   I believe dependencies come from sn_bcm_dependency_item, but want to confirm.

2. Is there a recommended way to join Parent BIA and Dependent Application BIA RTO values to compare them?

3. Has anyone already created a similar report, database view, or scripted solution for BIA dependency mismatches?

4. Is this something best done via Reporting, PA Indicator, or a scheduled script?

Any guidance or best practices would be greatly appreciated!

Thank you.