AuditRecords

Fetch a paginated list of AuditRecord instances dating back to a certain time.

Table Specific Information

Select

The component 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 component.

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			Name of the object that was affected by changes.
AffectedObjectType	String			Type of the object that was affected by changes.
AuthorDisplayName	String			Display name of the person who made the changes.
AuthorType	String			Type of the author who made the changes.
UserKey	String			Unique identifier of the author.
UserName	String			User name of the author.
Category	String			Category of the object.
CreationDate	Datetime			Date when the object was created.
Description	String			Description of the object.
RemoteAddress	String			Remote address of the object.
Summary	String			Summary of the object.
IsSysAdmin	Boolean			Identifier whether object is system administered or not.
SearchString	String		=	Text that is inserted by the user to search for a specific object.
StartDate	Datetime		=	Start date of the audit.
EndDate	Datetime		=	End date of the audit.

SSIS Components for Confluence

AuditRecords

Table Specific Information

Select

Columns