turbot/oci

steampipe plugin install ocisteampipe plugin install oci
On This Page
Get Involved

Table: oci_core_dhcp_options

The Networking service provides DHCP options to let you control certain types of configuration on the instances in VCN. Each subnet in a VCN can have a single set of DHCP options associated with it.

Examples

Basic info

select
display_name,
id,
time_created,
lifecycle_state as state,
region
from
oci_core_dhcp_options;

Get configuration info for each DHCP option

select
id,
display_name,
jsonb_array_elements_text(o -> 'searchDomainNames') as search_domain_names,
jsonb_array_elements_text(o -> 'customDnsServers') as custom_dns_servers,
o ->> 'serverType' as server_type,
o ->> 'type' as type
from
oci_core_dhcp_options,
jsonb_array_elements(options) as o;

Count the number of DHCP options by VCN

select
vcn_id,
count(*) dhcp_option_count
from
oci_core_dhcp_options
group by
vcn_id;

.inspect oci_core_dhcp_options

OCI Core DHCP Options

NameTypeDescription
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
defined_tagsjsonbDefined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
display_nametextA user-friendly name of the DHCP options.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the DHCP options.
lifecycle_statetextThe DHCP options's current state.
optionsjsonbThe collection of individual DHCP options.
regiontextThe OCI region in which the resource is located.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneThe date and time the DHCP options was created.
titletextTitle of the resource.
vcn_idtextThe OCID of the VCN the DHCP options belongs to.