Active IQ Unified Manager Discussions

Listing WFA Executions in Excel

MATTHEWKOOSWN
2,111 Views

Hi there,

 

I'm running WFA 4.0.  I was wondering if there is a way to export the list of workflow executions into an Excel spreadsheet or at least list them via command line so I could copy and paste them into Excel?  I need to provide a report to management on how many times WFA has been used in production this year.

 

Thanks,

Matt.

1 ACCEPTED SOLUTION

sinhaa
2,060 Views

@MATTHEWKOOSWN

 

Matt,

 

Last year I had posted an atricle doc to get WFA workflow execution status reports for a certain duration (eg. weekly). This article is here.

 

This workflow prepares execution status and send them by email. The logic is available to get you the workflow execution data, you can modify it to fit as you need it.

 

The above code is preparing email body into an HTML file to send via email. Alternately you can write the workflow execution data into CSV files, or EXCEL ( would need some MS EXCEL PS modules to do this ) .

 

Copy pasting into xl rows is too stone-age. WFA should be able to handle such automation requirements.

 

sinhaa

 

 

 

 

 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

View solution in original post

1 REPLY 1

sinhaa
2,061 Views

@MATTHEWKOOSWN

 

Matt,

 

Last year I had posted an atricle doc to get WFA workflow execution status reports for a certain duration (eg. weekly). This article is here.

 

This workflow prepares execution status and send them by email. The logic is available to get you the workflow execution data, you can modify it to fit as you need it.

 

The above code is preparing email body into an HTML file to send via email. Alternately you can write the workflow execution data into CSV files, or EXCEL ( would need some MS EXCEL PS modules to do this ) .

 

Copy pasting into xl rows is too stone-age. WFA should be able to handle such automation requirements.

 

sinhaa

 

 

 

 

 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.
Public