SQL Query Insight VM


I want to export from database the list of unscored rules for a specific scan compliance.
How can I do that by sql query?

This could be a good starting point for you:

select dp.policy_id, dp.title as "Policy title",
       dp.description, dpr.title as "Rule title",
from dim_policy dp
join dim_policy_rule dpr
using (policy_id)
where dpr.role = 'unscored'
and dp.policy_id = <insert ID here>

If there’s additional data you want to pull, you could look at the dim_policy and dim_policy_rule tables and see what fields are available.