000034506 - Set all users to the same default Workspace and Dashboard in RSA Archer GRC 6.1

Document created by RSA Customer Support Employee on Jun 21, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000034506
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.1, 6.2
 
IssueWe would like all of our users to default to our custom Welcome workspace and dashboard. Is there anyway that we can update the home page for all users?
ResolutionUser home pages cannot be changed en masse through the Archer user interface. You can set a default home page for a group or role--but this will only be applied to new users.  Once the new user logs on, the group or role default home page becomes that user's personal home page. Subsequent changes to group or role default home pages will not affect that user.
To change all users to the same home workspace and dashboard, or to the task-driven landing page, you can use a SQL script as follows:
Change all users to the same home workspace and dashboard
To find the workspace and dashboard IDs, go to the Manage Workspaces and Manage Dashboards pages, respectively, and hover your cursor over the name of the workspace or dashboard.  The ID will be displayed in the lower-right corner of the page. Input the workspace and dashboard IDs into the script below.
UPDATE tblUser 
SET
  default_home_workspace_id = '<input the workspace id>'
, default_home_dashboard_id= '<input the dashboard id>'
WHERE user_type_id='1'

Change all users to the task-driven landing page:
UPDATE tblUser 
SET
  default_home_workspace_id = '-1'
, default_home_dashboard_id= '-1'
WHERE user_type_id='1'

 

Attachments

    Outcomes