JDBC Driver for Confluence

Build 22.0.8462

AuditRecords

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

Table Specific Information

Select

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

  • 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462