steampipe plugin install ellisvalentiner/confluence

Table: confluence_search_content

Search content in a Confluence instance.

Examples

Get content with type "blogpost"

select
id,
title,
status,
type,
last_modified
from
confluence_search_content
where
cql = 'type=blogpost';

Get content with the "soc2" label

select
id,
title,
status,
type,
last_modified
from
confluence_search_content
where
cql = 'label=soc2';

Schema for confluence_search_content

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
cqltext=The Confluence query langauge.
idtextAutomatically assigned when the content is created.
last_modifiedtextWhen the content was last modified
statustextThe content status
titletextThe content title
typetextThe content type (page, blogpost, attachment or content)