How to remove a Scheduled Report Created By Another Technician

How to remove a Scheduled Report Created By Another Technician

Please note that you would not be able to edit the scheduled reports (private) created by other technicians.

However, you can delete the unwanted scheduled reports you don't have access to, by connecting to the database.

1. In order to find the list of scheduled reports created by all technicians, execute the below query in Reports->New query report.

select rst.reportid,crd.report_name,crd.is_public,rst.schedulename,rst.mailid,rst.subject,rst.message,rst.ownerid,aaau.first_name "Report owner",rst.report_type from customreport_details crd LEFT JOIN reportscheduletask rst ON crd.reportid=rst.reportid LEFT JOIN sduser sdu ON rst.ownerid=sdu.userid LEFT JOIN aaauser aaau ON sdu.userid=aaau.user_id where rst.reportid!=0 AND crd.report_name like '%test%'

Replace the Exact name of the report in the Highlighted text. Now note down the report ID from the above query.

2. Connect to the database and execute the below query, if you are using MSSQL, please connect to the SQL studio,

delete from reportscheduletask where reportid=1234;

Replace the ID obtained in the first query, in the highlighted text.

Restart of the application not required.
NOTE: Please ensure to take a trimmed backup before implementing this.


      • Related Articles

      • Query to show technician created time

        PGSQL & MSSQL: SELECT AaaUser.FIRST_NAME "Technician Name", aci.emailid "Email ID", LONGTODATE(AaaUser.createdtime)  "Technician Created Time", SDUSER.STATUS "Status(Active/Inactive)" FROM AaaUser left JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID ...
      • 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 ...
      • Fix for 9416 scheduled report issue

        Issue: ( Issue id: 13086) It is applicable only for build number 9416 and 9417 Custom report (not default report) when scheduled has the attachment sent but no data in it or corrupted. Fix: The 1.fjar has been attached herewith. Please place this jar ...
      • Query to show all scheduled reports created by all the technicians

        PGSQL  & MSSQL: select cd.Report_name "Report Name", cf.folder_name "Report folder", aaauser.first_name "Scheduled By", ti.schedule_time "Schedule time" from reportscheduletask rs LEFT JOIN customreport_details cd ON cd.reportid=rs.reportid LEFT JOIN ...
      • How to provide EDIT access to other technicians for the reports created by others or Admins ?

        Applicable for both 9.4 and 10.5 users. Please Make use of the below update query to provide the Edit option under Report for Users other than SD-Admin Role : Kindly connect to the database and execute the query below UPDATE GLOBALCONFIG set ...