Is there a way to seach for spaces created by Unknown User?

mybucket2018 May 25, 2017

Is there a way to seach for spaces created by Unknown User? By this I mean users who no longer have their account.

1 answer

0 votes
AnnWorley
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 31, 2017

I couldn't do it in the UI but I was able to using this SQL query (on PostgreSQL):

select spacename from spaces where creator in (select user_key from user_mapping where lower_username not in (select lower_user_name from cwd_user));

The creator column in the spaces table is a user_key that still exists in the user_mapping table when the user is deleted from LDAP (then becomes Unknown User in Confluence). The user is deleted from the cwd_user table so any space with a key that appears as a creator in the spaces table but the user is not in cwd_user, was created by Unknown User.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events