How can I change the user for running ControlPoint Scheduled Reports? (4306983)

If you ever need to change the user in which a scheduled report runs, you have 2 alternatives.

The first option would be to login with the user that has the report and export the report itself to an XML instruction file, and then re-import it with the user you want to run the account with. For more information on this you can follow our Documentation in the User guide::

Metalogix ControlPoint 8.5 - User Guide

If logging into the account is not possible, you can also change the UserID on the Database Level.

IMPORTANT: Performing a change of this magnitude requires SQL Knowledge and Quest Support is not responsible for improper query executions. Please proceed with caution.

Steps to change the User ID:

Look for the scheduled job at Manage | Schedule Monitor.

Notice that since this report was created only for this user, other users in the farm will not be able to see it in the UI, however it is accessible by looking up on the xcScheduledJob table on the xcAdmin database in SQL

To change this, go to the xcUser table and look for the UserID for the user you want to replace the value with and then run the following query on the xcAdmin Database:

update xcScheduledJob Set UserID = # Where UserID = #;

NOTE: Replace the first UserID with the new User you want to run the report with, and the last one with the old user.

Executing this will change the ownership of the report, and you will be able to run reports again: