CRM 2011 Get Organization ID

Using SQL Server Management Studio.

Create new query as below:

Select * from MSCRM_CONFIG..Organization

CRM 2011 Change The Default Organization

Eg. Server Name : http://111.11.11.11/ Organization : Test1 Organization : Test2 In internet explorer when we key in server name into the URL default organization will be selected. Let say the default organization for this server name is Test1 and when u key in the server name into the url the link will be  http://111.11.11.11/Test1/. Default organization will be selected automatically. How do we actually change the default organization ? Here what i found. Default organization is based on user. That mean each user have their own default organization. Here the way to do it. 1. Go to SQL Server where CRM installed     **Kindly change the GUID's** 2. Use MSCRM_CONFIG     Select * from organization You can find the list of organization in your CRM. 4. Find the User’s ID:     Use MSCRM_CONFIG      Select userid from systemuserorganizations where crmuserid = <6893e7a3-62b8-e011-aa60-000c292cbbe1> User ID 5.      Find the appropriate user in the systemuser table      Select * from systemuser where id = ‘E0437EA7-9B8B-E011-9245-000C292CBBE1’      - Update the systemuser table to reflect the desired defaultorganizationid 2.   6. Use MSCRM_CONFIG  Update SystemUser set DefaultOrganizationId = '6893E7A3-62B8-E011-AA60-000C292CBBE1’ Where id = 'E0437EA7-9B8B-E011-9245-000C292CBBE1'  DO IISRESET and access the CRM

This is where i done everything update and find. Eg Picture attached.