SQL example - view open ports
This example query outputs a port per row with additional information for each port.
sql
1SELECT da.ip_address, da.host_name, dos.name AS OS, dos.version AS os_version, das.port, dp.name AS protocol, ds.name AS service, dsf.name AS service_name, dsf.version AS service_version2FROM dim_asset_service das3JOIN dim_service ds USING (service_id)4JOIN dim_protocol dp USING (protocol_id)5JOIN dim_asset da USING (asset_id)6JOIN dim_operating_system dos USING (operating_system_id)7JOIN dim_service_fingerprint dsf USING (service_fingerprint_id)8ORDER BY da.ip_address, das.port
Did this page help you?