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.

[Matt Doar]

Sounds like you're looking for a way to have a space-level variable named Owner.

Perhaps some plugin such as https://marketplace.atlassian.com/apps/1212629/projectdoc-toolbox-for-confluence?hosting=server&tab=overview might help

[Olle Friman]

This is a very expensive plugin if we do not find any other use cases for it.

Anyhow, thanks for the suggestion.

[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. 

[Olle Friman]

Hi Thomas.

We have version 6.13.4.

I am not sure if I am missing something, but for our large usage of Confluence the owner of Spaces are not the creator nor the admins of the Spaces. When a Space owner leaves the company a new owner must be assigned. I still think a Owner field is required, which should be set at "Edit Space Details".

Thanks

Olle