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.
Click to expand the code block
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 ;