Reports missing owner

Products

• CA Performance Management
• Network Observability

Issue/Introduction

Several of the on-demand reports for one of my customers now show an owner of --None--. How can I reassign them to the correct customer?

Environment

Dx NetOps Performance Management any version

Resolution

Connect too mysql on the portal: mysql -unetqos -p<password> netqosportal

1. mysql> select UserID,Name from user_definitions;
   - get the name of your user - and make note
2. update report_definitions set Userid=<CUSTOMER_USERID> where ReportName='REPORT NAME';
3. Check in NetOps Portal
4. Repeat step 2 for any other reports

This should assign the report back to the user

Additional Information

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