I want to pull a report of the names of active users in each tool for license tracking

[Ken Brennan]

 I can go into crowd and search each tools groups and copy and paste the user list of of it but that requires a admin to do the work.  

Such as: 

jira-users

Jim Bob

Jerry Lee

There has to be a query or something that can be ran on the database to get me the information I'm looking for. 

[Caterina Curti]

Hi Ken,

Let me answer this question from a Bitbucket Server point of view.

You can use the steps on the How do I find which users count against my Bitbucket Server license? article to retrieve the licensed accounts in Bitbucket Server.

Cheers,

Caterina - Atlassian Support 

[Fabian Salazar]

hi Caterina,

Can you please provide the query for Oracle database as I don't want to install the plugin. Is it possible?

[Caterina Curti]

Hi Ken,

The best way to get that information in a consistent way across versions is to use the plugin.

The database structure could change at any time without any notice.

Is there any specific reason preventing you from installing the plugin?

Caterina