How to search for users with home page set and make them use the Global home space instead

Still need help?

The Atlassian Community is here for you.

Ask the community

Description

There are some companies that require their users to have just one global home space, however in confluence, the personal home page setting will override the global setting as stated here.

The user's personal settings will override the global setting.

Workaround

There is a query that you can use on confluence 5.2 onwards to check all users who have set a personal home page:

SELECT um.username, os.entity_key, os.string_val FROM OS_PROPERTYENTRY os
JOIN user_mapping um on um.user_key = trim('USERPROPS-' FROM os.entity_name)
WHERE os.entity_key = 'confluence.user.site.homepage';

And with this list in hand you can either ask the users to remove their home page settings OR force a home page reset by using the delete query below:

Always backup confluence database before running any update or delete SQL command!!!

DELETE FROM os_propertyentry WHERE entity_key = 'confluence.user.site.homepage';

Resolution

There is a feature request created for confluence which would provide this functionality to gracefully set and force the global home page on all users located here: CONF-33740 - Getting issue details... STATUS

There's no expectation to implement this feature for confluence, so we recommend to use the workaround provided in this KB as resolution.

Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.