Accessing the Alteryx scheduler AS_Schedules tabel

[MartWClimber]

I'm trying to create some insight in when workflows are running and I need some information from the  AS_Schedules tabel from the Alteryx scheduler DB (MongoDB).

I'm trying to find the database but I can not find it.

I found some topic's on how to access the MongoDB but those are not applicable to my situation.

https://help.alteryx.com/20213/server/primary-controller-configuration 

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Query-Scheduler-Database-from-Alteryx... 

Most examples got the button(see screenshot below) selected. (User-managed MongoDB).

We got the middle option selected (MongoDB) 

is there a way to access the MongoDB database and or the AS_Schedules tabel?

[jrgo]

Hi @MartWClimber 

I'd suggest downloading the Server Usage Report that's available from the download/licensing portal. You can learn how to interact with MongoDB by digging into the macros contained. Always use caution when interacting with this database as any changes, accidental or otherwise, could cause critical issues with your servers stability.

https://help.alteryx.com/20213/server/controller this is probably the documentation you should review to understand the settings your server is likely configured with. The first link you shared is describing how to use your own MongoDB instance vs. the self-managed/embedded instance (what you have now).

[ArtApa]

Hi @MartWClimber - If you use embedded MongoDB you can connect to your db directly using a MongoDB Input tool:

1) You need a MongoDB Input tool and a driver: https://help.alteryx.com/20214/designer/mongodb

2) You need to configure the tool as per below:

3) Enter "AlteryxService" as database and select AS_Schedules from the drop down list.

Hope that helps.

[MartWClimber]

With regards to the interacting part. I only need to read in some date from a specific table.

because it is a read action this should not cause any issues right?

[ArtApa]

Hi @MartWClimber - Yes, you will be fine. However, in the future you may want to consider Backups: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-amp-Recovery-Pa...