Hey all,
I have a couple of questions related to MongoDB for the Alteryx Server.
Where can I find what the state of a scheduled Workflow is from within the server’s MongoDB instance? I.e. How can I find out whether a schedule is enabled or disabled just by querying the MongoDB?
How can I map the scheduled/queued workflow databases with the user's table? I have checked on the Alteryx Service As_Queue and AS_Schedule tables and they don't contain any user information like (Username, Role, Email, etc.).I tried to join the AlteryxGallery users table but I couldn't find the common field for that.
Is there any way to identify the details of the job which is running for more than 2 hours.?
Your last question (and possibly the others too) can be answered by the Alteryx Server Usage Report I think https://help.alteryx.com/20212/server/install-server-usage-report
Hi @Ariharan - In addition to the Server Usage report I recommend you to try APIs. I believe the one below will provide you with all answers on your schedules questions:
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |