Hello , I am trying get a list of users who have created spaces but looking at the Spaces Table how can i ascertain the Creator's name as its held as a ref rather than a name.
Thanks
John
Look at user_mapping (has user_key and username) table and then cwd_user table (has other user details, by username)
When you go to the space directory, can you click on the i to get the space details including the creator? You may have to create a macro, this one will list all the space admins and the query could be adjusted to show the space creator instead: https://confluence.atlassian.com/confkb/how-do-i-view-a-list-of-all-space-administrators-for-all-spaces-346325879.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry , what i mean is I am using the sql query below to query against the table but the creator shows up as
8ab0814e4c9d2ba9014c9d300af8003d rather than the name. How can i get the name?
select s.SPACENAME, c.TITLE, c.LASTMODDATE, s.CREATOR from CONTENT c
join SPACES s on s.SPACEID = c.SPACEID
where CONTENTTYPE = 'PAGE'
and PREVVER is NULL
and c.LASTMODDATE < '20160101'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.