turbot/ibm_compliance

GitHub

Query: vpc_security_group_restrict_ingress_rdp_all

Usage

steampipe query ibm_compliance.query.vpc_security_group_restrict_ingress_rdp_all

Plugins & Tables

SQL

with ingress_rdp_rules as (
select
crn,
count(id) as num_rdp_rules
from
ibm_is_security_group,
jsonb_array_elements(rules) as rule
where
rule ->> 'direction' = 'inbound'
and rule -> 'remote' ->> 'cidr_block' = '0.0.0.0/0'
and (
rule ->> 'protocol' = 'all'
or (
(rule ->> 'port_min') :: integer <= 3389
and (rule ->> 'port_max') :: integer >= 3389
)
)
group by
crn
)
select
-- Required Columns
sg.crn as resource,
case
when r.crn is null then 'ok'
else 'alarm'
end as status,
case
when r.crn is null then sg.title || ' ingress restricted for RDP from 0.0.0.0/0.'
else sg.title || ' contains ' || r.num_rdp_rules || ' ingress rule(s) allowing RDP from 0.0.0.0/0.'
end as reason,
-- Additional Dimensions
sg.region,
sg.account_id
from
ibm_is_security_group as sg
left join ingress_rdp_rules as r on r.crn = sg.crn;

Controls

The query is being used by the following controls: