Output Audit Trail for Workflow?

Our Internal Audit team is asking me for an audit trail or any kind of execution steps taken by Alteryx to generate the Excel file I recently provided to them.

Is there a stage that I can add to the end of the workflow that will generate a 2nd sheet on the Excel file that shows this in a user-friendly format?

If a stage like this does not exist, are there any other alternatives that can show this documentation?

I've thought about maybe just taking a screenshot of the workflow, but this wouldn't necessarily show all of the steps taken in order to arrive at the finished product.

Workflow

Reporting

Settings

Output

Tips and Tricks

Help

Documentation

Accepted answers

tbezold

I was able to find my solution within the latter details of the README.md file (shown below). I wasn't initially aware that the packages file Installer_2020_09_28_Container_NONADMIN needed to be ran first.

Notes for September 28, 2020 Version

Container NONADMIN versions may not be used without elevating to admin privileges to install. In addition, an Installer for the required packages is now included. When running the installer, you will be prompted for the folder containing the package files- you must select the packages folder zipped together with the installer.
The installer will work for nonadmin installs only for the September 28, 2020 and later versions.

JTMorris

Hi @tbezold,

I would recommend checking out the Workflow Admin Manager (WAM). It allows users to simplify Alteryx administration by providing comprehensive Alteryx audit reporting, the ability to mass change anything related to your workflows, and the ability to track and lock your workflows. The audit reports provide a detailed breakdown of the workflow with information such as what tools were used and how they were configured, which can be shared with anyone. More info can be accessed at the link below.

https://gallery.alteryx.com/#!app/Workflow-Admin-Manager-for-Alteryx-by-Capitalize-Analytics/5fb3ff2...

All comments

philipmannering

Perhaps not what you're after, but you can output the message logs by entering a folder location here (see screenshot) in the User Settings,

Thought I'd add this just in case it's of interest.

Per

Hi @tbezold

There is an unofficial tool that can generate a pdf containing a description of a workflow (https://community.alteryx.com/t5/Engine-Works/Auto-Documentation/ba-p/545827). However, if you specifically need to embed it in an Excel file, you might have to modify it for that specific purpose. Hope it helps!

tbezold

This looks like it will do exactly what I need! However I can't get it to successfully run, even after I changed the timeout integer in my execute.py file to -1 (located in C:\Program Files\Alteryx\bin\Miniconda3\envs\JupyterTool_vEnv\Lib\site-packages\nbconvert\preprocessors).

This is the error I am receiving:

JupyterCode (8): Traceback (most recent call last):
File "C:\Users\tbezold\AppData\Local\Temp\Engine_12752_2dd932a40e754a98834d464c26351bc3_\209df4f9-41cd-4c1c-bebb-73ed3ad4d07f\workbook.py", line 20, in <module>
import xmltodict
ModuleNotFoundError: No module named 'xmltodict'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Users\tbezold\AppData\Local\Temp\Engine_12752_2dd932a40e754a98834d464c26351bc3_\209df4f9-41cd-4c1c-bebb-73ed3ad4d07f\workbook.py", line 24, in <module>
Package.installPackages(['xmltodict','pillow'])
File "C:\Program Files\Alteryx\bin\Miniconda3\envs\JupyterTool_vEnv\lib\site-packages\ayx\Package.py", line 202, in installPackages
raise pip_install_result["err"]
File "C:\Program Files\Alteryx\bin\Miniconda3\envs\JupyterTool_vEnv\lib\site-packages\ayx\Utils.py", line 120, in runSubprocess
result = subprocess.check_output(args_list, stderr=subprocess.STDOUT)
File "C:\Program Files\Alteryx\bin\Miniconda3\envs\JupyterTool_vEnv\lib\subprocess.py", line 411, in check_output
return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
File "C:\Program Files\Alteryx\bin\Miniconda3\envs\JupyterTool_vEnv\lib\subprocess.py", line 512, in run
raise CalledProcessError(retcode, process.args,
subprocess.CalledProcessError: Command '['C:\\Program Files\\Alteryx\\bin\\Miniconda3\\envs\\JupyterTool_vEnv\\python.exe', '-I', '-m', 'pip', 'install', 'xmltodict', 'pillow']' returned non-zero exit status 1.

JTMorris

Hi @tbezold,

https://gallery.alteryx.com/#!app/Workflow-Admin-Manager-for-Alteryx-by-Capitalize-Analytics/5fb3ff2...

esoden

The latest version of Workflow Admin Manager was demoed on this webinar. It now has support for local/shared drives, Alteryx Server, and Alteryx Hub. https://capitalizeconsulting.com/webinar/administering-and-managing-alteryx-workflows-with-wam-workflow-admin-manager/

There is a trial program if you want to see how it works with your workflows. You can also submit a workflow and get an audit document back here: https://capitalizeconsulting.com/workflow-admin-manager-wam-audit-report-tool/

tbezold

Is the Workflow Admin Manager tool available as a download from the Alteryx Gallery? I only see an option for "Run". Is this a tool that must be paid for, or is it included with the Designer license?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703