title | description |
---|---|
Steampipe Table: openshift_project - Query OpenShift Projects using SQL |
Allows users to query OpenShift Projects, specifically retrieving details about project metadata, status, and specifications. |
OpenShift Projects are a top-level scope for managing and organizing resources in an OpenShift cluster. They provide a logical, hierarchical organization for a set of resources and users. Projects are essentially Kubernetes namespaces with additional annotations, providing a unique scope for objects such as pods, services, and replication controllers.
The openshift_project
table provides insights into Projects within OpenShift. As a DevOps engineer or system administrator, explore project-specific details through this table, including metadata, status, and specifications. Utilize it to uncover information about projects, such as those with specific resource quotas, role bindings, and service accounts, aiding in the management and organization of your OpenShift cluster.
select
uid,
name,
resource_version,
phase,
creation_timestamp,
deletion_grace_period_seconds,
generate_name
from
openshift_project;
select
uid,
name,
resource_version,
phase,
creation_timestamp,
deletion_grace_period_seconds,
generate_name
from
openshift_project;
select
uid,
name,
resource_version,
phase,
creation_timestamp,
deletion_grace_period_seconds,
generate_name
from
openshift_project
where
phase <> 'Active';
select
uid,
name,
resource_version,
phase,
creation_timestamp,
deletion_grace_period_seconds,
generate_name
from
openshift_project
where
phase <> 'Active';
select
uid,
name,
resource_version,
phase,
creation_timestamp,
deletion_grace_period_seconds,
generate_name
from
openshift_project
where
creation_timestamp >= now() - interval '30' day;
select
uid,
name,
resource_version,
phase,
creation_timestamp,
deletion_grace_period_seconds,
generate_name
from
openshift_project
where
creation_timestamp >= datetime('now', '-30 day');
select
uid,
name,
resource_version,
phase,
creation_timestamp,
deletion_grace_period_seconds,
generate_name
from
openshift_project
where
deletion_timestamp is not null;
select
uid,
name,
resource_version,
phase,
creation_timestamp,
deletion_grace_period_seconds,
generate_name
from
openshift_project
where
deletion_timestamp is not null;
select
uid,
name,
phase,
creation_timestamp,
jsonb_pretty(annotations) as annotations
from
openshift_project;
select
uid,
name,
phase,
creation_timestamp,
annotations
from
openshift_project;
select
uid,
name,
phase,
creation_timestamp,
jsonb_pretty(labels) as labels
from
openshift_project;
select
uid,
name,
phase,
creation_timestamp,
labels
from
openshift_project;