Querying steps inside workflows

(0) Share

Report

Posted on by epark06

1,328

I have hundreds of workflows and I want to be able to search through all of them at once to find which workflows have a step that assigns a record. Is this possible? Is it possible to export the XML of all workflows and do a query that way? More specifically, identify the workflows that assigns the record to a specific user, so if exporting the XML is possible, I can search on that user's GUID.

2016 On-Premise

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: Querying steps inside workflows

Hi,

Please have a look below reference-

www.ecanarys.com/.../How-Microsoft-Dynamics-CRM-workflow-definitions-are-stored-in-the-SQL-Database

Was this reply helpful? Yes No
Verified answer

Kokulan 18,054 on at

Like (0)

Report

RE: Querying steps inside workflows

Hi

I normally use XrmToolbox Fetch XML Builder to query and find the workflow

Please see the following

You can search in the xaml column, lets say you are looking for the word Assign you can do as shown above.

https://www.xrmtoolbox.com/

The metadata browser plugin helps me to find the entity and attribute i want to query.

Hope this helps

Was this reply helpful? Yes No
epark06 1,328 on at

Like (1)

Report

RE: Querying steps inside workflows

Thanks! I've found both methods to work. SQL query and FetchXML

Was this reply helpful? Yes No