How to re-assign the owner of an on-demand report

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

We had an operator leave recently that had created many custom 'on-demand-reports'.

How can I re-assign the 'owner' to another individual?

How do I change the owner of an on-demand report? 

Change owner of on-demand report templates

Environment

Release : 3.7

Realese : 20.2

Component : IM Reporting / Admin / Configuration

Resolution

1. Run the following and get the userid of the user that left<OLD_USERID> and the userid <NEW_USERID> of the new owner .

$ mysql -unetqos -p <PASSWORD> netqosportal
mysql> select UserID,Name from user_definitions;

2. Then update the report_definitions tables userid with the new one.

mysql> update report_definitions set Userid=<NEW_USERID> where userid=<OLD_USERID>;

After changing the owner if you run the report and it gives you a "Page <PAGEID> is missing". This means the report was saved for "My User Account" and not "For All Tenant Users" and this requires a couple more steps for full access.

4. Update model_properties with new userid.

mysql> update model_properties set userid=<NEW_ID> where userid=<OLD_ID> and pageid =<PAGEID>;

5. Update page_info2 with the new userid 

mysql> update page_info2 set userid=<NEW_ID> where userid=<OLD_ID> and pageid=<PAGEID>;

*

If the user has already been deleted from CAPC, you may not have the old userid.

In this case, you can update all orphaned reports at once:

First, verify how many orphaned reports exist:

select * from report_definitions where userid not in (select userid from user_definitions)\G

Once you understand the scope, if you wish to assign them all to one user:

update report_definitions set Userid=<USERID> where UserID not in (select UserID from user_definitions);

 

 

 

 

 

 

 

Additional Information

For scheduled reports: 

https://knowledge.broadcom.com/external/article?articleId=189855