Database name change after 24B update. Need a SQL to find the alert that are using Database Name.

Hi Team,

We noticed database name change in Production after 24B patch applied and all our BIP Bursting logics are configured in a way that if the database name (ora_database_name) is (Prodcution) then bursting identifies it as a Production environment otherwise then the bursting considers it as Non-production environment.

Here to identify the impacted reports we required a SQL query for fetching reports that are using Database name in their bursting logic.

Thank you