JDBC Driver for Outreach

Build 23.0.8839

Audits

Get details of events that happen during the day.

Select

The 本製品 will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Id supports the '=' operator.
  • EventName supports the '=,IN' operators.
  • Timestamp supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Audits WHERE Id = 'cfae7d27-8600-4d8e-880b-3095fd9dbf5'

SELECT * FROM Audits WHERE Timestamp = '2022-01-25 00:23:41.442'

SELECT * FROM Audits WHERE Eventname = 'user_updated'

Columns

Name Type Description
Id [KEY] String Id of the audit.
ActorType String Actor type.
UpdaterId Integer UpdaterId.
EventName String Name of the event.
Impersonator String Impersonator.
OrgId String Org Id.
RequestIp String RequestIp.
ResourceId Integer ResourceId.
Timestamp Datetime When the event happened.
UserEmail String Email of the user who perfomed the action.
UserId Integer UserId.
Type String Type.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839