Business App Device Impacts
/* * Business App Device Impacts * Use this query if you are looking to discover all business apps that are impacted by a specific set of infrastructure devices and the relationships between them. * You can use object_name to look at the source of the impact or impacted_object to look at the device directly supporting the business application. */ SELECT businessapplication_fk ,business_app_name ,device_fk ,impacted_object ,device_host ,device_subtype ,impact_reason ,relationship_type ,relationship_url ,object_name AS related_object_name ,port AS related_object_port ,related_object_url ,component_type ,business_app_url ,business_app_diagram ,business_app_tech_owner ,business_app_owner ,business_app_service_level ,business_app_migration_group ,business_app_criticality ,business_app_type ,business_app_description ,business_app_contains_pii ,business_app_internet_accessible ,business_app_notes FROM view_dbb_adm_businessapp_composition_v2 WHERE object_name IN('<your-device-name-here>') OR impacted_object IN('<your-device-name-here>') ORDER BY business_app_name ;
Use this query if you are looking to discover all business apps that are impacted by a specific set of infrastructure devices and the relationships between them.