Delete requests

Delete requests

If you would like to delete the older requests, you could use the below query.

For MSSQL:

delete from workorder where dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (CREATEDTIME/1000),'1970-01-01 00:00:00') <= convert(varchar,'2010-04-01 00:00',21)

Postgres/Mysql :

delete from workorder where (CREATEDTIME >= (UNIX_TIMESTAMP(DATE('2013-07-24 00:00:00')) * 1000) and CREATEDTIME <= (UNIX_TIMESTAMP(DATE('2013-10-24 00:00:00')) * 1000))

Archived requests: 

delete from arc_workorder where (CREATEDTIME >= (UNIX_TIMESTAMP(DATE('2013-07-24 00:00:00')) * 1000) and CREATEDTIME <= (UNIX_TIMESTAMP(DATE('2013-10-24 00:00:00')) * 1000))

Note: Its always recommended to take a backup before performing the delete operation.
          • Related Articles

          • Steps for Custom Scripts to show only view of Account's Requests for primary contact.

            1.Create a folder under this location : ManageEngine\SupportCenter\custom with the name scripts and then add the custom scripts to be executed.  Example of a custom scripts : primary contact only needs view of account's requests and not the default ...
          • Exporting and importing requests in SCP using xls format

            Step 1 : Generate a report as xls file * Go to Reports module and choose New Custom report, select Requests module and proceed to the report wizard. * Select the required fields (columns) and run the report. You might choose the Request ID as well, ...
          • Workaround for Contacts tab not visible for support reps (post 11.0 version)

            Post 11.0, the contacts tab will not be shown at the top for support reps. As a workaround follow these steps 1. Goto Admin -> ZOHO Creator apps 2. Click on Add Links -> Provide Link Name as Contacts -> URL ...
          • How to setup Python on the Server

            This article explains how to set up the ServiceDesk plus server to run python scripts. 1. The first step is to install python on the application server and you can download it from here. Any version above 3.4.1 should work fine. Start the setup and ...
          • How to Export SSL certificate using MMC?

            When an SSL certificate is already installed on a Windows server, you may want to reinstall it on SupportCenter Plus server. This may be required when you have a Wildcard or a Multi-domain certificate, and the subdomains or different domains are ...