Devices Possibly Containing PII That Have Public IPs
Devices containing PII (as set by customer ) or PII is ‘Not Set’ and have public IPs.
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
NOTES
Personally Identifiable Information (PII) is manually set by customer and not discovered.