turbot/aws_insights

Query: vpc_dhcp_options

Usage

powerpipe query aws_insights.query.vpc_dhcp_options

SQL

select
d.dhcp_options_id as "DHCP Options ID",
d.tags ->> 'Name' as "Name",
d.domain_name as "Domain Name",
d.domain_name_servers as "Domain Name Servers",
d.netbios_name_servers as "NetBIOS Name Servers",
d.netbios_node_type "NetBIOS Node Type",
d.ntp_servers as "NTP Servers"
from
aws_vpc as v,
aws_vpc_dhcp_options as d
where
v.vpc_id = $1
and v.dhcp_options_id = d.dhcp_options_id
order by
d.dhcp_options_id;

Dashboards

The query is used in the dashboards: