Need to change the owner of Scheduled Reports in NetOps
searchcancel
Need to change the owner of Scheduled Reports in NetOps
book
Article ID: 189855
calendar_today
Updated On: 02-10-2022
Products
CA Infrastructure ManagementDX NetOpsCA Performance Management - Usage and Administration
Issue/Introduction
We need your assistance in changing the owner of the scheduled report and the on demand reports.
Currently some reports are being scheduled by Person A
We need the owner of the reports to be changed from Person A to Person B.
Environment
All supported DX NetOps Performance Management releases
Resolution
The following process is specific to changing the owner for a Scheduled Report. If the owner of an On-Demand report needs to be changed please see KB article How to re-assign the owner of an on-demand report.
To change the owner of an existing Scheduled Report take the following steps:
Open a MySql prompt and run the following to obtain the UserID for the user that left, the <OLD_USERID>, and the UserID of the new target owner, the <NEW_USERID>.
Go to /opt/CA/MySql/bin (default path)
Run the following to enter the MySql prompt. Enter the password when prompted:
./mysql -uroot -p
Run the following to list out UserID values.
select UserID,Name from user_definitions
Run the following update to change the email_schedules table's userid with the new one.
update email_schedules set Userid=<NEW_USERID> where userid=<OLD_USERID>;