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 ...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 ...Query to retrieve both the live and archived requests details
Database: Pgsql Query: SELECT wo.WORKORDERID AS "Request ID", pd.PRIORITYNAME AS "Priority", id.NAME AS "Impact", ud.NAME AS "Urgency", rtd.NAME AS "Request Type", LONGTODATE(wo.CREATEDTIME) AS "Created Time", LONGTODATE(wo.RESOLVEDTIME) AS "Resolved ...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 ...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 ...