nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how can get a report of active editors

Ian Seaman_thdsi7

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

Accepted answers

Fabio Racobaldo _Catworkx_

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

All comments

Fabio Racobaldo _Catworkx_

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:

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

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

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

I hope the above info helps. Have a good weekend

Thanks,

Srinath T

Ian Seaman_thdsi7

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server