How to search for users with home page set and make them use the Global home space instead
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Description
Some companies 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 the 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.