Acquire 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 the Business Processes having been executed, which is required for SPA License, please 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