Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

License limit reached - find details of when and who caused this?

Mick Davidson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 25, 2016

Is it possible to find out who added the users who took us to or over our license limit?

ATM, all we get is a message saying "This Confluence installation is not licensed for additional users"

Because we have a few admins who can add users, it can be tricky to track down who we need to talk to about what they did and why.

I know we can resolve the problem by disabling users, but that doesn't help us know who the latest ones are, when they were added and who by. We need this info so we can talk to them about it.

We're running 5.9.9 Server.

Cheers.

1 answer

0 votes
Guilherme V.
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 26, 2016

Hi Mick,

You can run the below query in the database:

SELECT user_name,created_date FROM cwd_user ORDER BY created_date DESC;

It will list all usernames that are added in Confluence and it will order them by the creation date. The first ones are the users that were recently added.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events