You are viewing limited content. For full access, please sign in.

Question

Question

How to find all workflow database connections

Workflow Version 10 Administration How To
Updated October 31, 2019
asked on October 30, 2019

Hello,

Our company has many Workflows with connections to our Line of Business database all over the place. What I'm looking for is a way to query the WF database to monitor which WF's have connections to what tables. That way if a developer changes a table in our database, we will know what WF to check to see if there are updates needed. Ideally, it will also work in reverse meaning if a new WF is created with a connection to our DB we would have a report showing the new WF and connection to a table. We have multiple developers so that's why we need to monitor on a schedule and not just rely on developers "letting us know". Thanks. 

0 0

Replies

replied on October 30, 2019

I'm not sure how to get this from the database, but you can view linked workflows for each data source from the administration console.

From the Workflow Administration Console, select External Objects > Data Sources, highlight the data source, then click "View Linked Workflows" in the right pane.

2 0
replied on October 30, 2019

Thanks, Jason, I took a look at that and its not what I need. First off, it has duplicates because it's looking at all versions of a WF. Some of my WF have 70 versions by themselves. This also doesn't tell me what tables are being accessed.  

0 0
replied on October 30, 2019

That is the only thing you can get from the database or through the UI at this time. The tables used are only saved in the Workflow XML.

0 0
replied on October 31, 2019

Hello Miruna, what would you recommend as a method to monitor changes to our workflow server? We have multiple people ready to start building WF's and I want a way to monitor the existing workflow connections to our DB as well any new connection without relying on a developer "telling" me what they did. It won't happen 100 percent so I need a way to monitor these changes daily. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...