SQL example - asset details
This example query provides:
- scan site
- hostname
- ip address
- operating system
- software name
- software version last scan date
SQL
1SELECT dss.site_id AS "Site ID", da.host_name, da.ip_address, dos.description AS "Operating System",2fa.scan_started AS "Last Scan Date", ds.name AS "Software Name", ds.version AS "Software Version"3FROM dim_asset da4JOIN dim_operating_system dos ON dos.operating_system_id = da.operating_system_id5JOIN fact_asset fa ON fa.asset_id = da.asset_id6JOIN dim_asset_software das ON das.asset_id = da.asset_id7JOIN dim_software ds ON ds.software_id = das.software_id8JOIN dim_scan ds2 ON ds2.scan_id = fa.last_scan_id9JOIN dim_site_scan dss ON dss.scan_id = ds2.scan_id
Did this page help you?