turbot/oci

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

Table: oci_identity_group

Group is collection of users who all need the same type of access to a particular set of resources or compartment.

Examples

Basic info

select
name,
id,
description,
lifecycle_state,
time_created
from
oci_identity_group;

List of Identity Groups which are not in Active state

select
name,
id,
lifecycle_state
from
oci_identity_group
where
lifecycle_state <> 'ACTIVE';

List of Identity Groups without application tag key

select
name,
id
from
oci_identity_group
where
not tags :: JSONB ? 'application';

.inspect oci_identity_group

OCI Identity Group

NameTypeDescription
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.
descriptiontextThe OCID of the group.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the group.
inactive_statusbooleanThe detailed status of INACTIVE lifecycleState.
lifecycle_statetextThe group's current state.
nametextThe name assign to the group during creation.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneDate and time the group was created.
titletextTitle of the resource.