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
Requests duplicated - Not deleted from inbox after fetching
Issue When emails are fetched as requests, the application places a delete flag which is delete the email from the inbox. In this case, the emails are not deleted allowing the application to fetch the same email again and again Cause Issue occurs ...The requests are stricken, when associated with expired contract
When , in Request Module, the requests are stricken out, the below mentioned is the reason and solution to remove it. -> The stricken out of the tickets indicates that the contract associated with that ticket has expired. -> You can follow the below ...Unable to merge or delete requests/ Unable to take a backup in new instance
Issue: Cannot merge or delete requests. Also, cannot take backup in a new instance with data. Cause: Any of these issues may occur due to orphan entries present in DB. i.e. when we delete a service category in CMDB, it actually gets removed from UI ...Automatically create multiple child requests when a parent request is created (Deluge)
PURPOSE: When a request is created, multiple child requests can be generated under the same account as the parent request. TESTED BUILDS: 14306, 14500, 14503, 14504 and 14507 STEPS: 1) Download and extract the zip file from the attachment. 2) Under ...Query to retrieve the requests that are created and completed within the given time frame
Tested in: 14610 & 14301 The following queries will return the IDs and counts of requests created within a given time frame and completed (Resolved, Closed, Cancelled) within the same time frame. QUERY FOR INCIDENT REQUESTS: SELECT ...