turbot/oci_insights

Query: mysql_db_system_endpoint

Usage

powerpipe query oci_insights.query.mysql_db_system_endpoint

Steampipe Tables

SQL

select
e ->> 'hostname' as "Hostname",
e ->> 'ipAddress' as "IP Address",
e ->> 'modes' as "Modes",
e ->> 'port' as "Port",
e ->> 'portX' as "PortX",
e ->> 'status' as "Status"
from
oci_mysql_db_system,
jsonb_array_elements(endpoints) as e
where
id = $1;

Dashboards

The query is used in the dashboards: