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 http://www.manageengine.com/products/support-center/faq-general.html
Execute the below query which will give you the details of custom reports which are created and saved by other support reps
SELECT * FROM customreport_details WHERE ownerid!='-1';
From the above query take a copy of the reports that you want to modify/delete and make note of the "userID"
To find the userID of the support reps run the below query
Select * from aaauser;
After you get the USERID now execute the below query to change the ownerid
Update customreport_details set ownerid= newownerid where ownerid= oldownerid;
Then the new owner can login and modify/delete the report.
Connect to your database
To connect to your database please refer http://www.manageengine.com/products/support-center/faq-general.html
Execute the below query which will give you the details of custom reports which are created and saved by other support reps
SELECT * FROM customreport_details WHERE ownerid!='-1';
From the above query take a copy of the reports that you want to modify/delete and make note of the "userID"
To find the userID of the support reps run the below query
Select * from aaauser;
After you get the USERID now execute the below query to change the ownerid
Update customreport_details set ownerid= newownerid where ownerid= oldownerid;
Then the new owner can login and modify/delete the report.
New to ADSelfService Plus?
Related Articles
Query to list the custom and query reports and the technician created (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) 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 ...How to disable the Created Date field for technicians
1. Roles Under Admin >> Roles >> Disable the below access The above option will disable the user from modifying Created Date, Resolved Date, Dueby Time. 2. Field and Form Rules If the requirement is to disable only Created Date field. Under Admin >> ...Task related reports (MSSQL)
Tested in MSSQL build (14306) Sample Output and headers present in this report Goto reports -> New query report and executes the following SELECT taskdet.TASKID AS "Task ID", taskdet.MODULE AS "Module", taskprior.PRIORITYNAME AS "Priority", ...Known issue in Reports throwing error in UI
Issue - Reports thrown error in UI Trace in Logs. [12:23:37:156]|[02-13-2023]|[SYSERR]|[INFO]|[27512]: Thread Thread[Thread-129,5,main] exited unexpectedly.java.lang.NoClassDefFoundError: Could not initialize class ...Query to find out who created Accounts (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) Execute the below queries under Reports->New Query Report. select org_id, org_name from accountdefinition ad where ad.org_name in('Requester Name', 'Palanivel Palras','Muhammad Nadeem Khan') Note down ...