how can get a report of active editors

[Ian Seaman]

I want to determine the number of active editors to inform my licensing decision

[Fabio Racobaldo _Catworkx_ · Accepted solution]

Hi @Ian Seaman ,

welcome to the Atlassian community!

You can retrieve that information using contributors macro (https://confluence.atlassian.com/doc/contributors-macro-183468956.html)

Hope this helps,

Fabio

[Srinatha Tondihal]

Hi @Ian Seaman ,

Welcome to Atlassian community. 

You can also run some SQL's and get data like the users who are not active for particular date range and decide to remove them so that you will save on your license count. Some useful sql's are as below. 

List users who are inactive

SELECT *
FROM cwd_user
WHERE active = 'F';

List users by last login date:

SELECT cu.user_name,
       cd.directory_name,
       li.successdate
FROM logininfo li
JOIN user_mapping um ON um.user_key = li.username
JOIN cwd_user cu ON um.username = cu.user_name
JOIN cwd_directory cd ON cu.directory_id = cd.id
ORDER BY successdate;

List active users who have not logged in since a specific date

SELECT cu.user_name,
       cd.directory_name,
       li.successdate
FROM logininfo li
JOIN user_mapping um ON um.user_key = li.username
JOIN cwd_user cu ON um.username = cu.user_name
JOIN cwd_directory cd ON cu.directory_id = cd.id
WHERE successdate < '2016-01-01'
ORDER BY successdate;

I hope the above info helps. Have a good weekend

Thanks,

Srinath T

[Ian Seaman]

Thanks Srinath, I'll keep those sql queries for later, too. v. useful