Devices Possibly Containing PII That Have Public IPs

Returns devices where PII is marked as yes or not set and that communicate with public IP addresses. Note that PII status is set manually and is not directly discovered.

Click to expand the code block

select
     ds.contains_pii
     ,ds.device_name
     ,ds.device_type
     ,ds.serial_number
     ,ds.tags
     ,ds.device_service_level
     ,ds.device_last_edited
     ,ds.is_client_w_public_ips
     ,ds.client_external_ips
     ,ds.is_listener_w_public_ips
     ,ds.listener_external_ips
     ,ds.all_software
from view_dbb_security_v2 ds
where lower(ds.contains_pii) in ('not set', 'yes')
     and (lower(ds.is_client_w_public_ips) = 'yes'
     or lower(ds.is_listener_w_public_ips) = 'yes')
order by 1 desc,2