Use audit log with Business Intelligence Connector

Audit log offers a record of important events in your Greenhouse Recruiting environment from the previous 30 days. You can access audit log with Business Intelligence Connector. When enabled, an audit log table will be included in your nightly ETL.

Enable audit log

Once your organization has enabled Business Intelligence Connector, you can include audit log in your ETL.

To include audit log in your next ETL, click the Configure icon on your navigation bar, then select Dev Center on the left.

Click Business Intelligence Connector.

Scroll to Settings and click Edit.

Under Additional information to include, check Audit log.

When finished, click Save.

Use audit log

Once enabled, audit log will appear in your organization's next ETL. Here's an example audit_log table in plaintext:

CREATE TABLE audit_log (
     organization_id,
     event_time,
     request_id,
     request_type,
     performer_id,
     performer_type,
     performer_meta,
     performer_ip_address,
     event_type,
     event_target_id,
     event_target_type,
     event_meta,
);

Here's an example of how data will populate in the table:

You can use SQL queries and statements to further filter and analyze your data. Check out Understand audit log data to learn more, or check out Audit log use cases for inspiration.