Need to change the owner of Scheduled Reports in NetOps
search cancel

Need to change the owner of Scheduled Reports in NetOps


Article ID: 189855


Updated On:


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


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.


All supported DX NetOps Performance Management releases


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:

  1. 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>.
    1. Go to /opt/CA/MySql/bin (default path)
    2. Run the following to enter the MySql prompt. Enter the password when prompted:
      • ./mysql -uroot -p
    3. Run the following to list out UserID values.
      • select UserID,Name from user_definitions
  2. 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>;