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.