SQL example - assets using ciphertext
This example query will return the ciphertexts being used by your assets.
sql
1SELECT ds.name AS site_name, da.ip_address, da.host_name, dos.asset_type, dasc.port, split_part(dasc.name, '.', 1) protocol_version, unnest(string_to_array(dasc.value, ',')) cipher_suite23FROM dim_asset da45JOIN dim_operating_system dos USING (operating_system_id)67JOIN dim_host_type dht USING (host_type_id)89JOIN dim_asset_service_configuration dasc USING (asset_id)1011JOIN dim_site_asset dsa USING (asset_id)1213JOIN dim_site ds USING (site_id)1415WHERE dasc.name ILIKE 'sslv2.ciphers' OR dasc.name ILIKE 'sslv3.ciphers' OR dasc.name ILIKE 'tlsv1_0.ciphers' OR dasc.name ILIKE 'tlsv1_1.ciphers' OR dasc.name ILIKE 'tlsv1_2.ciphers'
Did this page help you?