turbot/oci

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

Table: oci_ons_subscription

Subscriptions allow you to be notified of new messages or changes via a Message Queue of your choice.

Examples

Basic info

select
id,
topic_id,
lifecycle_state,
protocol,
endpoint,
etag
from
oci_ons_subscription;

List subscriptions in a pending state

select
id,
lifecycle_state,
protocol,
endpoint
from
oci_ons_subscription
where
lifecycle_state = 'PENDING';

Get subscription count by topic ID

select
topic_id,
count(id) as subscription_count
from
oci_ons_subscription
group by
topic_id;

Get subscription count by protocol

select
protocol,
count(protocol) as protocol_count
from
oci_ons_subscription
group by
protocol;

.inspect oci_ons_subscription

OCI Ons Subscription

NameTypeDescription
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
created_timetimestamp without time zoneThe time when this subscription was created.
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.
delivery_policyjsonbDelivery Policy of the subscription.
endpointtextA locator that corresponds to the subscription protocol.
etagtextUsed for optimistic concurrency control.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the subscription.
lifecycle_statetextThe lifecycle state of the subscription.
protocoltextThe protocol used for the subscription.
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.
topic_idtextThe OCID of the associated topic.