[ETL]: Extract Audit Logs

This entry guides you through the steps on how to extract the Audit logs from your Ambience 202x server.

The following ETL Chainset could be scheduled as a job to run when required.


1/ From the Service Chooser, navigate to the “ETL” module.

2/ Click on the “Upload” button and upload the following chainset.

3/ In the ETL Chainset, you would need to take note of the following ETL Step(s): “JSON Record”, “Read Audit Log”.

A/ JSON Record

→ This step defines the necessary date values as parameters which will be needed in the following ETL steps. Do revise or add on as needed.
→ For example,

B/ Read Audit Log

→ This step will determine the period for which the chainset will lookup from the Audit Logs.
→ For example, based on the below parameters, this chainset will only output the audit log records from 1st August 2024 till today.

The parameter for “today” has been defined in the following step, “Date Today”.

4/ Do remember to click “Save” if any changes were made.

5/ Once done, click on the “play” button to execute the ETL chainset. A .csv file with today’s date and timestamp file will be output in the ./data/out directory of your Ambience server installation path.
Screenshot 2024-08-08 at 1.10.52 PM