list of spaces created by inactive owners

Kalyan Majji

Hi, Need some help to find out the spaces created by present inactive owners and not being used from an long time.

Need to get the list and delete them.

Thanks,

Kalyan.

AAMIR ANSARI_lij8a1

Hi @Kalyan Majji 

You can try the below query to get the list of spaces created by inactive users.

SELECT DISTINCT s.spaceid,
                c.user_name,
                s.spacename,
                s.spacekey,
                c.active
FROM SPACES AS s
JOIN user_mapping AS u ON s.creator = u.user_key
JOIN cwd_user AS c ON c.lower_user_name = u.lower_username
WHERE spacekey LIKE '~%'
  AND c.active = 'F';

Once the spaces are identified, through admin rights, you can delete those spaces.

Regards,

Aamir