SQL example - detailed policy report
This example query returns all Pass/Fails across all policies/benchmarks accessed during a scan.
sql
1select da.ip_address, da.host_name, dos.name as OS, dos.version as OS_Version, dp.title as Policy_Title, dpr.title as Rule_Name, dpr.description as Rule_Description, dprs.description as Complaince_Status2from fact_asset_policy_rule as fpr3join dim_asset as da on fpr.asset_id = da.asset_id4join dim_operating_system as dos using (operating_system_id)5join dim_policy as dp on fpr.policy_id = dp.policy_id6join dim_policy_rule as dpr on fpr.rule_id = dpr.rule_id7join dim_policy_result_status as dprs on fpr.status_id = dprs.status_id
Alternative query
sql
1select da.ip_address, da.host_name, dos.name as OS, dos.version as OS_Version, dp.title as Policy_Title, dpr.title as Rule_Name, dpr.description as Rule_Description, dprs.description as Complaince_Status2from fact_asset_policy_rule as fpr3join dim_asset as da on fpr.asset_id = da.asset_id4join dim_operating_system as dos using (operating_system_id)5join dim_policy as dp on fpr.policy_id = dp.policy_id6join dim_policy_rule as dpr on fpr.rule_id = dpr.rule_id7join dim_policy_result_status as dprs on fpr.status_id = dprs.status_id8WHERE dprs.description != 'Not applicable'9ORDER BY da.ip_address, dp.title
Did this page help you?