steampipe plugin install ellisvalentiner/confluence

Table: confluence_content_version

Content versions in a Confluence instance.

Examples

Get basic info about the version

select
*
from
confluence_content_version;

Get the count of content by label

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

Get the 50 oldest pages

select
title,
space_key,
"when"
from
confluence_content_version
join confluence_content using (id)
order by
"when" asc
limit
50;

Schema for confluence_content_version

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
accountIdtextThe account ID for the content version's author.
displayNametextThe display name for the content version's author.
emailtextThe email for the content version's author.
idtext=The ID of the content.
messagetextThe content version message.
minor_editbooleanWhether the version corresponds to a minor edit.
numberbigintThe content version number.
userKeytextThe user key for the content version's author.
usernametextThe username for the content version's author.
whentextWhen the content version was published.