Be able to set and track Space owner

Olle Friman

A field to track the Space owner is required.

We have hundred of Spaces and as the the admin we need to know who to ask questions about the content. For us the Space owner is also the content/data owner.

We are currently using the Space Description field for manually maintaining the Space owners, but as this is a text field it is very complicated to add processes around this information.

Ideally we would like a field for the Space owner which then can be imported to Insight (Riada plugin) where the data can be mapped with HR data.

Thomas B

Hi @Olle Friman - there was a similar question asked a while back (Previous Question about Space Owners) but the resolution is performing a SQL query or building a macro. It appears that Confluence doesn't have 'owners'.

Here is a SQL script that works on my version: 

SELECT spaces.SPACENAME, spaces.SPACEKEY, mapping.username
FROM [confluencedb].[dbo].[SPACES] spaces

INNER JOIN [confluencedb].[dbo].[user_mapping] mapping
ON mapping.user_key = spaces.CREATOR

You may want to replace CREATOR with LASTMODIFER since your 'owners' are also your 'creators' and modifying your content. What version of confluence are you running?

Thanks.