How to find workflows running on the user context in MS CRM

How to find workflows running on the user context in MS CRM using sql

Sql query to get all workflows which are running on user's context, workflowbase table in ms crm

Recently i needed to find out all the workflows which are running in the context of  the user who made changes to the record. To quickly find out the same we need to query workflowbase

 table in crm db.

Below is the query.

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Select 

distinct(W.name)

 from workflowbase as W

join SystemUser  as S

on W.OwnerId=S.SystemUserId

where S.FullName = 'CRM Admin'

and W.IsCrmUIWorkflow=1 --

and W.RunAs=1 --1 the user who made changes to the record 0-owner of the workflow

and W.ParentWorkflowId is   null --For workflow header rows only

and mode=0 --for real time workflow only 0- real time 1-background

and w.Category=0 --Category 2- Business rule and 0 is workflow

order by W.name

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Happy CRMing