Change default site for multiple users

webadmin's Avatar


02 Jun, 2015 06:33 PM

Is there a way for me to change the default site of all users to another one? We've recently done a rebranding, and I'd like to change from one to the other.

  1. 1 Posted by Ryan Griffith on 02 Jun, 2015 06:58 PM

    Ryan Griffith's Avatar


    The easiest way to accomplish this would be to update the users by querying the database directly; otherwise, you could use Web Services to loop over all of your users and change their default site.

    Here is a query you can run to adjust the default Site for users that have a specific site assigned:

    update cxml_user set defaultSiteId = 'NEW_SITE_ID' where defaultSiteId = 'OLD_SITE_ID';

    Where NEW_SITE_ID would be the ID of your new Site and OLD_SITE_ID would be the ID of the previous Site. You can obtain these IDs by viewing both Sites within the Site Management area and copying the ID from the browser's URL bar (ie after the id= parameter).

    Please let me know if you have any questions.


  2. Tim closed this discussion on 17 Jun, 2015 02:36 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac