Update Default Dashboard of users: Dynamics CRM 2011 and 2013 on-premise

We can use following query:

Step 1: Fire the below query:

Update UserSettingsBase set
DefaultDashboardId = ‘DashboardId’

Note: DashboardId can be picked from systemform table.

Step 2: CRM App pool recycle.

Hope it helps!

This is unsupported query and can fail in future.