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]

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