search cancel

Need to change the owner of Scheduled Reports in NetOps

book

Article ID: 189855

calendar_today

Updated On:

Products

CA Infrastructure Management DX NetOps CA 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:

  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>;