Delete requests
If you would like to delete the older requests, you could use the below query.
Connect to the Database
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))
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.
Drop Files to Attach
New to ADSelfService Plus?
Related Articles
How to analyze when inline images crashes in Requests
If any image on the Request description is crashed like the below image, you can follow the below steps to analyze the issue. Steps to analyze: Right click on the image in the request description and click on Inspect, and there will be an IMG html ...Script to Notify Support Reps when a new reply is received for Unassigned Requests
Please do follow the below steps to notify support reps when an unassigned request is updated or when a reply is received. 1. Download the configuration.json file, sendMail.py file, requestobj.json file from the below link: ...Scripts to update request status when a new reply is received.
Please do refer to the below steps to change the status when a Contact sends a new reply to the ticket. 1. Download the script files from the below link and extract them and place it under..\ManageEngine\SupportCenter\integration\custom_scripts - ...Apply Contract to All Requests raised by this account option is greyed out while creating a new contract
1. Whenever I put in Expiry date the checkbox for Apply Contract to All Requests raised by this account becomes greyed out. --> This will happen if there is another active contract for the same period. Two rules are applied while creating a contract ...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 ...