How to import schedule run details to excel from alteryx server

[Shank]

Hi all,

Is there a way where i can export all the schedule job run details (secheduled in my private folder) from alteryx server to excel?

is there any such tool in alteryx so that i can build a workflow for this?

many thanks for your help

[patrick_mcauliffe]

@Shank

That depends.  Do you have access to query the MongoDB for your server?

[Shank]

@patrick_mcauliffe

I can get that access if required to extract the data.

how can we build an workflow for that?

[patrick_mcauliffe · Accepted solution]

@Shank  Lucky for you, @AndrewL has done all of the hard part for you.

Check out his post here:
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Query-Scheduler-Database-from-Alteryx...

You may need to modify it a bit to fit your specific use case, but that's what I've based my work off of.