Creator in Confluence DB

[john davison]

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

[Alex Medved _ConfiForms_ · Accepted solution]

Look at user_mapping (has user_key and username) table and then cwd_user table (has other user details, by username)

[joanna ransome-wallis]

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

[john davison]

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'