# Identify all the cloudflows on a particular entity along with its messages

The easiest way to identify the flows that trigger on a particular entity with its messages is to run a SQL query using the sql4cds tool in the xrmtoolbox.

The table that has the information is callback registration, querying the call back registration table provides information about the modern flow/ cloud flow guid.  
We can then join it with workflow table to retrieve all the valid information.

```sql
SELECT 
    CR.entityname,
    CR.messagename,
    WF.name AS workflow_name
FROM 
    workflow AS WF
INNER JOIN 
    callbackregistration AS CR ON WF.workflowid = CR.name
GROUP BY 
     CR.entityname,CR.messagename,WF.name
ORDER BY 
    CR.entityname,CR.messagename;
```

  
`CR.entityname`: Represents the name of the entity from the `callbackregistration` table.

* `CR.messagename`: Represents the name of the message from the `callbackregistration` table.
    
* [`WF.name`](http://WF.name) `AS workflow_name`: Represents the name of the workflow from the `workflow`  
      
    It joins the `workflow` table (aliased as `WF`) with the `callbackregistration` table (aliased as `CR`) using the condition `WF.workflowid =` [`CR.name`](http://CR.name). This condition ensures that records are matched based on the equality of the `workflowid` column in the `workflow` table and the `name` column in the `callbackregistration` table.  
      
    Then Groups the results based on the columns we need/specify and orders the results.  
    
* ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1711080520579/4646ce7d-d550-4107-b55d-d9c6560e015d.png align="center")