Devices Possibly Containing PII That Have Public IPs

Devices containing PII (as set by customer ) or PII is ‘Not Set’ and have public IPs.

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

NOTES

Personally Identifiable Information (PII) is manually set by customer and not discovered.