Changing the ownership of Report

Changing the ownership of Report

In order to change the ownership of the existing Reports, please follow the below steps,

1. connect to your database.  Incase, if your connecting database is postgresql, please refer the below link to connect to it. viz.

2. Execute the below query to find the list of Reports,

 select * from customreport_details

The above query will display the list of all Reports available in the application.

3. Choose the Reportid from the result of the executed query and the ownerid.

4. Now execute another query to find the list of users(viz. their names and other details),

select * from aaauser

5. From the result of the above query, choose the user_id of the user to whom you want to give privilege for that Report. 

6. Now in the query window, type the following query to apply the changes,

update customreport_details set ownerid=** where reportid=**;

In the above query, replace the ** with the respective values. For ownerid=**, replace with the user_id of the user to change the ownership. And in the reportid=**, replace with the values selected from the customreport_detail.

        New to ADManager Plus?

          New to ADSelfService Plus?

            • Related Articles

            • Steps for deleting/modifying the reports created by other techs:

              Steps for deleting/modifying the reports created by other techs: Connect to your database  To connect to your database please refer Execute the below query which will give you the ...
            • Login Frequency Query Report

              The below report would help us find the last logged in time of the users in SCP 11.0 SELECT AaaUser.FIRST_NAME "Technician",        MAX(AaaLogin.NAME) "LoginName",        MAX(AaaContactInfo.EMAILID) "Email",        MAX(AaaAccSession.USER_HOST) "IP ...
            • Issue running reports

              Cause : Report API running the background causes the issue. If the user mentions issue with running reports with the below error and trace as mentioned below. Error trace: ...
            • Followers report

              You can use the below query to get the Followers and the request details. Go to Reports --> New Query Report select wo.workorderid "Request Id",wo.title "Subject",aaau.first_name "Followers",aaauc.emailid "Followers email" from workorder_cclist woc ...
            • Assessment reports

              Datebase: MSSQL Status wise: select wo.workorderid, sd.statusname,convert(varchar(5),(sum(wsi.timespent))/60)+':'+convert(varchar(5),((sum(wsi.timespent))%60))'timespent' from workorder wo join wo_assessment wa on wo.workorderid=wa.workorderid join ...