Workflow to Push to SQL DB everytime Vco is run

[midacts]

Does anyone have any suggestions on how to set something like this up:

I would like to have VMWare Orchestrator write to a DB every time someone runs a VCO workflow so that I can get some eyes on how much we are using VCO. I see there is a workflow that is specifically for SQL and I have the SQL plugin.

Does anyone know if this is something that is possible? If so, what kind of database would you set up for VCO to write this data to (MS SQL, MySQL/PostgreSQL). Do you guys think this would be something that would be difficult to setup?

Thanks for your help guys.

[tschoergez]

moved to the orchestrator communities.

Hi,

there is no built-in way to do that, however, you can use workflow inspection to create the needed logic.

See here for more information / examples (even some "dirty database trigger example" that might be a quick & (very) dirty way to achieve what you want):

The Philosopher’s Stone of vCO: Workflow Reflection

How to Retrieve Workflow Execution Details

Cheers,

Joerg