Delete Tasks
Requirement: Delete all tasks.
UseCase: Deleting tasks with task id less than a particular count.
Please follow the below steps.
- Goto Reports > New Query Report > execute the query and save it with a name.
- select taskid, helpdeskid "portaild" from taskdetails where taskid < 300
- All tasks with task id less than 300 will be deleted. This can be modified as per your requirement.
- Execute the query and save the report with a name. [Report name: deletetask]
- Goto Admin > Custom Schedule Function > Global Function > New > Paste the global function contents and save it with a name.
- Update the URL and integration key in the script.
- You can get the integration key under Admin > Integrations > Integration Key > New
- Please use an integration key with admin privilege, as there wont be any role related permission issues.
- Update the integration key in the global function.
- Goto Admin > Custom Schedule Functions > New > Paste the content from Delete_task.txt and save it with a name
- Configure a custom schedule to invoke the created custom function with the query report as parameter.
- Note: We can configure this on repeat mode if the task count is huge.
New to ADSelfService Plus?
Related Articles
Project,Milestone and Tasks.
DB Compatability: PgSQL and MSSQL SELECT projectdet .PROJECTID "Project Id", projectdet.TITLE "Project Title", projectstatus.STATUSNAME "Project Status", projectowner.FIRST_NAME "Project Owner", ...Workaround for #8808907: Skip schedule on Delete flag exception
Fix: This fix should be given only for 8808907 customer and for 14204 build. The fix is to skip the current mail fetching schedule on occurrence of any delete flag exception. This fix is compatible with only 14204 build. Steps to apply the fix: 1. ...Trigger a set of tasks
Requirement: Auto Trigger a set of task associated to a request depending on the date configured in the request additional field. Steps to follow: Goto Reports > New Query Report > execute the query and save it with a name. PGSQL: SELECT ...Opmanager Integration - Create downtime schedule in Opmanager from a change request in ServiceDesk Plus.
This script will invoke the OPManger API to set downtime of assets using the schedule time and the assets / business views chosen in a change request on ServiceDesk Plus. Execution steps: 1. Download and copy the script and xml file into the ...Close requests with pending approval for more than 10 days
Requirement: Close older requests with pending approvals. UseCase: Close all requests for which approvals have been sent but no action has been taken in more than 10 days. Please follow the below steps. Goto Reports > New Query Report > execute ...