Devices with Mismatch Between Prod and Non-Prod Environments

Returns devices where production and non-production service levels are communicating with each other. Note that service levels are defined manually and are not directly discovered.

Click to expand the code block

select distinct
     ds.device_fk
     ,ds.device_name
     ,ds.device_service_level
     ,ds.mismatched_listener_devices
     ,ds.mismatched_client_devices
from view_dbb_security_v2 ds
where ds.mismatched_listener_devices is not null
or ds.mismatched_client_devices is not null
order by 1