How to get the number of active users counting into the licence

[Cédric]

Dear,

My goal is to monitor in Zabbix the number of active users counting into the licence of Crowd, JIRA, Confluence and Bitbucket. And have an alert depending of these numbers.
I found a lot of SQL queries but the result is always different of the value of the admin console (nested groups, users with duplicated usernames across multiple directories, etc...).
The best way will be to have a REST API to have these values reliably.
But in the meantime, I'm looking for a solution to monitor these values (SQL queries or other solution).

Do you have any reliable SQL queries for these values (Crowd, JIRA, Confluence and Bitbucket) ?

Thank you in advance,
Cédric