Adding Dashboard as home page

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Would like to add dashboard as home page for all users.

Would like to add dashboard as home page for user.

Would like to add dashboard as landing page for all users.

Would like to add dashboard as landing page for user.

Would like to add dashboard as start page for all users.

Would like to add dashboard as start page for user.

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Cause

To set a user's dashboard as a home page, each user has to be set one at a time.

Resolution

There is no way to do this in the console, but we can set it using mysql.

1. Backup mysql netqosportal database.
2. Log in as a user and go to the page you desire to set as home page. In the URL for the page note the value after pg= this is the <PageId>
3. Open a shell to the CAPC host and log into mysql

mysql netqosportal -unetqos -ppassword (replace password)

4. Check the homepagepageid for the user:

select userid,name,homepagepageid from user_definitions where name='username';

5. Set users home page to use that <PageId>

update user_definitions set homepagepageid=<PageId> where name='username';

Note: to modify for all users just omit the where clause. 
update user_definitions set homepagepageid=<PageId>;

6. Verify the changes:

select userid,,name,homepagepageid from user_definitions;

7. Exit mysql: quit

Now proxy in as a few users and verify it worked.