Due to change in the LDAP/AD configuration the user doesn't have a default dashboard anymore. Is there a way to restore the users old dashboard or create default automatically.
Component : CA RELEASE AUTOMATION RELEASE OPERATIONS CENTER
For the dashboard related activities there are two important tables.
We will now try to understand possibility of restore or configuring default dashboard for users.
SELECT d.id,d.name, d.layout_type,d.content, d.order_num, u.username, u.id as 'user-id' FROM dashboard_instances AS d JOIN users AS u ON u.id=d.user_id;
UPDATE dashboard_instances
SET user_id=<NEW_USER_ID>
WHERE user_id=<OLD_USER_ID>
Please find relative table and query (in MS-SQL syntax)
Query
INSERT INTO dashboard_instances
(name, layout_type,content,order_num,user_id)
VALUES(<DASHBOARD_NAME>,<LAYOUT_CONFIGURATION>,<LAYOUT_CONTENT>,0,<USER_ID_VALUE>)
Example:
INSERT INTO dashboard_instances
(name, layout_type,content,order_num,user_id)
VALUES
(
'test_dashboard',
'02.6-6/12',
'[{"columns":[{"styleClass":"col-md-6","widgets":[{"id":"widget-object-xxxx-xxx-xxx-xx-xx","type":"process_report","config":{}}]},{"styleClass":"col-md-6","widgets":[{"id":"widget-object-yyyyy-yyyyy-yyyy-yyyy","type":"deploymentsoverview","config":{},"title":"DASHBOARD.WIDGETS.deploymentsoverview.TITLE"}]}]},{"columns":[{"styleClass":"col-md-12","widgets":[]}]}]',
0,
1
)