Specify number of unique Business Processes

The number of unique Business Processes (Definitions) launched in a period of time can be acquired using an SQL query.

To collect information about executed Business Processes that are required for the SPA License, perform the following steps:

Collect information from each environment using the instruction below:
1. Log in to DB instance and connect to MySQL DB.
2. Execute the next SQL query:
```
select count(*) from (
 select c.componentUuid, MAX(r.startDate) as lastStartDate
   from Campaign c join Run r on c.id=r.campaign_id and c.type="COMPOSITE"
   where r.status NOT IN ("DELETED", "DELETING") AND r.rootRunUUID = r.uuid and r.startDate between now() - INTERVAL 3 MONTH and now()
   group by c.componentUuid
   ) as bp; 
```
  The now() function in this query can be replaced with a certain date, for example, 2017-09-01 00:00:00. This query does not include Business Processes with the Draft status, which have not been launched in this period, and the deleted Business Processes.
Add a record to the Excel report specifying the environment type (production, dev) and the number of Business Processes.
Send the result Excel report to WorkFusion.

WorkFusion Documentation