Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

How to import schedule run details to excel from alteryx server

Shank
8 - Asteroid

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

 

3 REPLIES 3
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@Shank

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

Shank
8 - Asteroid

@patrick_mcauliffe

 

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

 

how can we build an workflow for that?

patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@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.