steampipe plugin install ellisvalentiner/confluence

Table: confluence_content_label

Content labels in a Confluence instance.

Examples

Get basic info about the labels

select
id,
content_id,
title,
space_key,
prefix,
name,
label
from
confluence_content_label;

Get the count of content by label

select
label,
count(*)
from
confluence_content_label
group by
label;

Get labels with documentation in the name

select
*
from
confluence_content_label
where
name ilike '%documentation%';

Schema for confluence_content_label

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
content_idtextAutomatically assigned when the content is created
idtextAutomatically assigned when the label is created
labeltextThe label
nametextThe label name
prefixtextThe label prefix
space_keytextThe space containing the content
titletextThe content title