2014-07-23 12:25 AM
in my WFA 2.2 database I have "collected" about 2000 workflow job execution logs. As those logs describe the lifecycle of storage entities I need to export those data in order to archive them in an external system.
Is there a possiblity to export the data of the workflow job execution status logs from the WFA database into ASCII files? I do not want to export each workflow individually, rather I'd like to do it with a batch job for several logs at once. Best would be to select the jobs to be exported by a execution time span. When exporting the logs I want to keep all the information which is shown in the execution status window for the workflow job (flow, details, user input, return parameter and command output).
I would appreciate if there is a ready to use solution for this. But I might be able to code such a batch job by myself if someone can tell me where this data is located and how to access it.
Thanks for your help.
2014-07-25 12:23 AM
What kind of external system do you archive them to ? Is it some change management system or source control system ?
WFA exposes it cache db schema via a read only user which is documented in the product guide/workflow developer guide. But unfortunatley, that doesnt give access to schema other than the cache.
The workflow execution status are store in schema named WFA which is not exposed via the read only user.
2014-07-25 01:23 AM
I want to archive this data to a Snaplock device.
Do I understand right: There is no possibility for me to write a tool to export the workflow execution status logs. And there is no tool available from NetApp or the WFA community.
So what can I do?
2014-07-25 02:48 AM
Let me summaries what I understood. You want to bulk archive the following to your snaplock device.
You would like to do both of these programatically or in simpler way instead of gui clicks.
If my above summary is correct you basically are expecting one of the folloiwng.
I know for sure option b and c aren't available. But let me check on the option a with our Engg team and get back to you on the same.
2014-07-25 03:54 AM
your summary is right, with the following addition:
I do not want to click in the GUI for every workflow execution log because I already have about 2.000 execution logs. This would need too much time.
But I can use the GUI for a bulk archive if there is a possibilty to export the data I need and for the selection criteria you list in your summary. If this is not available or could not be made available in the GUI then a powershell function would be possible, too.
If using the GUI for a bulk archive I'd like to have the execution log of one workflow in a single ASCII file. All ASCII files of the bulk export may be put in a zip-archive and downloaded with http from WFA server to a client.
Thanks for your help!
2014-07-25 04:32 AM
Unfortunately, there is no way to export from GUI as well in a bulk fashion.
I have opened a Request For Enahancement. Can you pls open a case with netapp and add the same to RFE # 841941 ?
2014-07-30 03:56 AM
If you don't need to do very often, there is a probable workaround.
You can restore the wfa backup in another mysql DB for which you know the root password.
I installed XAMPP and restored the backup.
You can see the attached .png to know the tables from which you will be able to get the data.
2014-07-30 04:01 AM
Thats a very nice workaround Abhi.
But on a long term basis, I think we should expose some of these tables, for compliance, data analytics or reporting purpose to end users.
If not tables at least some views.
2014-07-30 04:32 AM
thanks for your help!
I still would prefer an official function for exporting several workflow job execution status logs in one step from the GUI to ascii files like described above. But until this is provided I'll use the method you suggest.