Delete Support Group

Please follow the instructions below to check what could still be hindering the deletion of the Groups:

 

1.) Execute the below query to find the exact Group Id of the Group that you want to delete:

 

select qd.queuename “Group Name”,qd.queueid “Group ID”,sd.name “Site Name” from queuedefinition qd left join sdorganization sd on sd.org_id=qd.siteid order by 3

 

2.) Replace the Group ID(where it is highlighted) in the below query to find the associations for the Group to the Tasks:

 

select td.taskid “Task ID”, td.title “Task Title”, td.module “Module”,wtt.workorderid “Request ID”,ctt.changeid “Change ID”,ptt.problemid “Problem ID”, prtt.projectid “Project ID” from taskdetails td left join queuedefinition qd on qd.queueid=td.groupid left join workordertotaskdetails wtt on wtt.taskid=td.taskid left join changetotaskdetails ctt on ctt.taskid=td.taskid left join Problemtotaskdetails ptt on ptt.taskid=td.taskid left join tasktoprojects prtt on prtt.taskid=td.taskid where qd.queueid= 301 ;

 

3.) Replace the Group ID(where it is highlighted) in the below query to find the associations for the Group to the Requests:

 

select wo.workorderid “Request ID”,wo.title “Subject” from workorder_queue wq left join workorder wo on wo.workorderid=wq.workorderid left join queuedefinition qd on qd.queueid=wq.queueid where qd.queueid= 301 ;

 

Note:
1.) You may run the below queries under Reports\New Query Report.
2.) You may need to reassign or make the Group unassigned on the Tasks / Requests that you find associated with the Group that you want to delete.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500