Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Log File Automation

sqldba504
6 - Meteoroid

Hi All,

I am trying to move the log files for various executions to different directories automatically.  It seems like the best I can do is do it after the workflow runs.  To do that, I was going to write the RunID out to a file, and have powershell take the RunIDs, find them in the log directory and either copy or move them with the other run artifacts based on other identifiers in the log file.  

 

I have a few misc. questions in all of this.

1) How do I determine the RunID before the workflow ends?  

2) Is there a way to pass formula output formatted as "string" to the "Command Arguments" field in the Run Command tool?  It seems you can do that by using [parameter], but I haven't been able to make that work. I have a powershell script that takes 2 parameters, and I have tried to just pass each parameter as well as the entire string for the arguments to "CommandArguments".  If I put put the resolved text in "CommandArguments" it works fine, so I know it isn't the script, or how I'm using each field in the run command.  

3) Is there an easier way to capture logs?  Perhaps by pointing Alteryx at a SQL database and just letting it log there?  I have seen people talk about emailing them, but that's not the best solution for me.  

 

If there is anyone doing any archival of the logs, I would be interested to see your workflows.  

 

Thanks

 

 

 

12 REPLIES 12
NeoInfiniTech
11 - Bolide

Hello @sqldba504,

 

While a solution was already provided, I just wanted to inform you that if you are using Alteryx Designer 2024.1, it is now possible to read the log files as they are being generated. You can read the related release note here: Read Engine Logs While a Process Runs.

ChrisTX
16 - Nebula
16 - Nebula

@sqldba504 

 

The %OutputLog% is built in to Alteryx.  To see an example, under Workflow Configuration choose Events > Add > Send Email

 

Screenshot 2024-09-09 100029.png

 

Chris

sqldba504
6 - Meteoroid

Thanks, Unfortunately, we are on an older version (2023.1) at the moment.  Its good to know though!!

Labels
Top Solution Authors