Steps to Change Report Owner

Steps to Change Report Owner

Kindly follow the below instruction to change the report owner. ( From Tech A  to Tech B)

Query to get Technician User ID:

    SELECT * FROM AAAUSER WHERE FIRST_NAME LIKE '%TECH NAME%';

You may replace the Tech A name and Tech B name to get the user id for each technician. 

Query to get list of Customer reports created by Technician. You may replace the User ID under below query.

 SELECT * FROM CUSTOMREPORT_DETAILS WHERE OWNERID=<USERID>;

1. Stop the application.
2. Please take a backup of the application <OR> take a Snapshot of both the Servers (Application & Database).
4. Execute the below Update Query to change the report owner. Kindly replace the User ID and Report ID to change the Report Owner.

UPDATE CUSTOMREPORT_DETAILS SET OWNERID = <Tech B USER_ID> WHERE REPORTID = <REPORT_ID>;

5. Start the application service.

      • Related Articles

      • Instruction to Change Worklog owner under All Request, worklog owner From Tech A to Tech B

        Scenario      Worklogs assigned to Duplicate user / Incorrect user need to change all worklogs under request  to actual Technician.  Step 1 : Navigate to Report - > New Query Report and execute the below query.  Select workorder.workorderid ...
      • Query to list the custom and query reports and the technician created

        Use case The query displays the custom reports and query reports saved by technicians. Query SELECT custrepdet.report_name "Report Name",               au.first_name"Created By" from customreportquery custrep LEFT JOIN customreport_details custrepdet ...
      • Change Auto closure

        This will be helpful in auto closing change request after X days it is in review stage. This use case is more suitable in environments where ONLY Requesters (customers) are the Change Reviewers and they want the Change to be closed if no review is ...
      • Script to add worklog using custom schedule

        What is a Custom Schedule? Custom Schedules are actions scheduled on a specific date and time with or without repeat frequency. The actions are specified in a customized script file. Any data from ServiceDesk Plus can be sent to the script through ...
      • Notification script using Custom function in custom trigger

        This is applicable from 10600 builds. From 10600 , Business rules dont have Email notification feature. The same use case be achieved through Custom triggers feature as mentioned below. Script to enable notification of request creation using custom ...