Retrieving execution logs from MongoDb

[olivierMPW]

Hello,

Following the migration to version 2024.1, the Server Usage Report workflow from version 2022.1 no longer works (ErrorMessage is missing in a collection).

From what I read, this workflow is no longer available for versions higher than 2022.3.

Is there an “easy” way to retrieve workflow execution information from MongoDB or another source?

Thank you

[KGT · Accepted solution]

You probably want the schema if you are directly connecting to the MongoDB: https://help.alteryx.com/current/en/server/configure/database-management/mongodb-management/mongodb-...

Not sure if there is an updated version of the Server Usage Report though.

The Server API tools would be a better way though: https://marketplace.alteryx.com/en-US/apps/418052/server-api-tool

[Yoshiro_Fujimori · Accepted solution]

Hi @olivierMPW ,

If you have access to MongoDB, you can retrieve the workflow execution information with MongoDB Input Tool faierly 'easily'.

From Database: AlteryxService, Collection: AS_Queue

you can retrieve AppName, CreationDateTime, CompletionDateTime, Status, AS_Application__ID, SubsciptionID

From Database: AlteryxGallery, Collection: users

you can retrieve user name (FirstName, LastName etc.), SubscriptioinId

From Database: AlteryxService, Collection: AS_Schedules

you can retrieve AS_Application__ID, user name(LC_Owner)

By joining them, you can get the table of "What workflow ran from what time to what time triggered by whom".

Here is an image of sample workflow for your reference. I hope this helps.

[olivierMPW]

thanks for the server

the fact is that I have modified the server usage workflow for my need et didn't want to do it again

[olivierMPW]

 the workflow

I will try it