steampipe plugin install ellisvalentiner/confluence

Table: confluence_content

Content in a Confluence instance.

Examples

Get basic info about the content

select
id,
title,
space_key,
status,
type
from
confluence_content;

Get the count of content type

select
"type",
count(*)
from
confluence_content
group by
"type";

Get content with draft in the title

select
*
from
confluence_content
where
title ilike '%draft%';

Schema for confluence_content

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
idtext=Automatically assigned when the content is created
space_keytextThe space containing the content
statustextThe content status
titletextThe content title
typetextThe content type (page, blogpost, attachment or content)
version_numberbigintThe content version