Is there a way to find out what users are using their own space for their home page as opposed to the sites homepage?

[Jason Kirby]

Hi all,

I'm somewhat new to Confluence and work for a company that uses Confluence as their main site. Right now the dashboard is set as their home page and we're going to be upgrading Confluence. We need to know which users are using their own space as their homepage as opposed to the dashboard. Is there a way to determine this?

Thanks

[Septa Cahyadiputra · Accepted solution]

Hi Jason,

You could get this information from your database using the following SQL query

SELECT entity_name, string_val as HomePage FROM os_propertyentry WHERE entity_key='confluence.user.site.homepage' AND string_val != 'dashboard' AND string_val != 'siteHomepage';

The above query would list the user_name and its configured homepage. If you want the list of user that uses their personal space, here is the SQL query necessary

SELECT entity_name, string_val as HomePage FROM os_propertyentry WHERE entity_key='confluence.user.site.homepage' AND string_val != 'dashboard' AND string_val != 'siteHomepage' AND string_val like '~%';

Hope it helps.

Cheers,
Septa Cahyadiputra