topic Re: Alteryx MongoDB - Audit Events in Alteryx Server Discussions

Alteryx MongoDB - Audit Events

Ariharan — Fri, 04 Nov 2022 21:15:45 GMT

Hi All,

Does anyone know how to find audit events for schedules in Alteryx MongoDB?

The Alteryx API documentation was only available for certain entities(workflow, collection, etc.,) and not available for Schedule entities.

https://help.alteryx.com/developer-help/auditlog-endpoint

Regards,

Ariharan R

Re: Alteryx MongoDB - Audit Events

gabrielvilella — Fri, 04 Nov 2022 23:16:36 GMT

You can find information on Schedules within the AlteryxService > AS_Schedules

https://help.alteryx.com/20212/server/alteryxservice-mongodb-schema

Re: Alteryx MongoDB - Audit Events

Ariharan — Sat, 05 Nov 2022 13:02:34 GMT

HI @gabrielvilella ,

We have already checked it in the As_Schedule MongoDB collection and it contains actual information, not audit information.

Regards,

Ariharan R

Re: Alteryx MongoDB - Audit Events

gabrielvilella — Sat, 05 Nov 2022 13:10:05 GMT

I’m not sure what you mean by audit information. I’d you could provide an example.

Re: Alteryx MongoDB - Audit Events

Ariharan — Sat, 05 Nov 2022 13:29:31 GMT

Hi @gabrielvilella ,

An audit log, also called an audit trail, is essentially a record of events and changes.

E.g., If you create a schedule in Gallery, information about the schedule like creation date time, frequency, owner, type, last run, next run, etc. will be updated in MongoDB.
If a user edits or modifies a schedule in the gallery, the edit/updated information is only available in MongoDB. I want to see audit information like old value(before change), new value, operation (update, delete, insert).

Regards,

Ariharan R

Re: Alteryx MongoDB - Audit Events

TimN — Sat, 05 Nov 2022 13:53:29 GMT

Hi,

We dump each MongoDB Schema to a YXDB Weekly. One Schema is Schedules. There is a field in the extract that is Binary JSON Format. I found a tool in the community that extracts the BSON field - can't find that post - but thanks to who put it out there. Here's a sample of the field:

So I can query the extracted yxdb like this:

Attached is the WF so you can copy the Debug Print tool.

Re: Alteryx MongoDB - Audit Events

Ariharan — Mon, 07 Nov 2022 12:36:20 GMT

Hi @TimN ,

I think the same MongoDB information is only available in the BSON/JSON file.

If a user edits or modifies a existing schedule in the gallery UI page, the edit/updated information is not updated in the Alteryx Gallery & Service logs. I want to see updated audit information like old value (before change), new value, Type of operation (update, delete, insert).

Regards,
Ariharan R

Re: Alteryx MongoDB - Audit Events

marcusblackhill — Mon, 07 Nov 2022 18:34:29 GMT

Hi @Ariharan !

I don't believe Alteryx stores that log in the way you would like. There in the Gallery logs you can find the change requests, but not exactly which change was made.

There in the AS_Schedules collection you can find some relevant information about the schedules like discussed here before, but also not exactly what you want. Since that looks like a product gap for me, you could develop a workflow to fill that gap.

You could build a table in a database that you have, storing daily statements of that schedule. Using the LastModifiedId, LastModifiedDate, Frequency and Enabled fields from this collection, you be able to track by yourself any changes. I know that's not the solution you desired, but at least can be a path to you don't miss any changes in your environment

Re: Alteryx MongoDB - Audit Events

TimN — Mon, 07 Nov 2022 18:46:25 GMT

Here is a link to a similar discussion with the WF that can capture the data.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/history-of-workflow-schedule-changes-on-Alteryx-Gallery/td-p/559072