AuditRecords

Provides a paginated list of audit records detailing user and system activities performed since a specified time period.

Table Specific Information

Select

The connector will use the Confluence API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

SearchString supports the '=' comparisons.
StartDate supports the '=' comparisons.
EndDate supports the '=' comparisons.

For example, the following queries are processed server side:

SELECT * FROM AuditRecords WHERE SearchString = 'your search string'

SELECT * FROM AuditRecords WHERE StartDate = '2019-08-12'

SELECT * FROM AuditRecords WHERE EndDate = '2019-08-15'

Columns


Name	Type	References	SupportedOperators	Description
AffectedObjectName	String			The name of the Confluence object that was modified during the audited action, such as a page, space, or attachment.
AffectedObjectType	String			Specifies the type of object affected by the change, such as page, comment, or configuration item.
AuthorDisplayName	String			The display name of the user who performed the action recorded in the audit log.
AuthorType	String			Indicates the type of account that executed the action, such as internal user, external user, or automated system.
UserKey	String			The unique key that identifies the user who initiated the audited action within Confluence.
UserName	String			The username of the user responsible for the audited event.
Category	String			Defines the functional category of the audited event, such as content management, permissions, or configuration.
CreationDate	Datetime			The date and time when the audited event occurred and was recorded in the system.
Description	String			A detailed description of the change or event, providing context for what was modified or triggered.
RemoteAddress	String			The IP address or network origin from which the action was performed.
Summary	String			A concise summary of the audit event, highlighting the main change or activity.
IsSysAdmin	Boolean			If the value is 'true', the action was performed by a system administrator. If the value is 'false', it was performed by a standard user.
SearchString	String		=	The search term or keyword entered by the user when querying audit records or related data.
StartDate	Datetime		=	The beginning timestamp that defines the start of the audit period for retrieved records.
EndDate	Datetime		=	The ending timestamp that defines the end of the audit period for retrieved records.

Power BI Connector for Confluence

AuditRecords

Table Specific Information

Select

Columns