tbello-esristaff

Using excel to generate reports on Workflow Manager jobs

Blog Post created by tbello-esristaff Employee on Aug 24, 2015

If the reporting capability inside of workflow manager is not sufficient for your business needs, you can take advantage of other applications like Excel to view and generate metrics based on jobs in the system.

Using the query tools inside of Workflow Manager desktop, you can define your queries by adding the fields that are of interest to you. 

queryname.png

fieldnames.png

Look here for more information on queries

 

In the workflow manager desktop application, you run the query and get an option to export to CSV on the context menu. Specify the desired destination location for the file to be stored.

exporttocsv.png

 

Open your saved CSV file in Microsoft Excel, and begin to analyze your data or generate charts and based on the Workflow Manager job data

reportinexcel.png

Outcomes