Detect Orphaned Assignment Groups

[JinkaH]

How to detect and identify orphaned assignment groups  in Incident if the group is inactive and no groupmembers present in the group table 

[Mohammed8 · Accepted solution]

@JinkaH 

Can you close this thread as its different requirement. You can open new thread with proper requirement use case .  I will see and check and try to help.

Thanks and Regards,

Mohammed Zakir

[Mohammed8 · Accepted solution]

@JinkaH 

service desk mean incident ticket? can u state requirements.

You can post a new question, detail it out properly

Regards,

Zakir 

[Mohammed8 · Accepted solution]

@JinkaH 

If iam understanding is correct:

1) Get group with Zero members.

2)Reassign all the tickets of these group to other active group with user, so which is this group?

3) why flow designer? is it specific requirement. 

4) what's the trigger daily, weekly?

This will take time to build in PDI, i suggest you to post as new question in developer forum so other can have their inputs too,

Regards,

Mohammed Zakir

[Mohammed8 · Accepted solution]

@JinkaH 

You are right to go to flow designer as approach.

I was just  asking if it was specific business requirement to use as flow designer.

Other approach i can think is Schedule jobs.

Regards,

Mohammed Zakir

[Dr Atul G- LNG · Accepted solution]

Hi @JinkaH 

If you want to use less code or a no-code solution, the Flow Designer is the best option.

[JinkaH]

If not flow designer so which type of method can we use and group is service desk
Trigger daily.

[Mohammed8 · Accepted solution]

@JinkaH 

You are right to go to flow designer as approach.

I was just  asking if it was specific business requirement to use as flow designer.

Other approach i can think is Schedule jobs.

Regards,

Mohammed Zakir

[JinkaH]

Can you please help me with flow designers

[Mohammed8]

@JinkaH 

Here is how I would approach, here are rough steps you can consider and trying building logic using flow designer:

1) Scheduled Trigger Daily

2) Lookup Records (sys_user_group)

3) For Each Group (iteration step)
    3a) Lookup sys_user_grmember (members of this group)
     3b) IF Group Members count = 0 (if condition)
           3c) assign Group sys_id to flow variable orphanGroups  (create orphanGroups                                variable)
4) Lookup records for task table
use condition : assignment_group IN orphanGroups
5a) Update Record 

assignment_group = <sys_id for service desk>
description = "Auto reassigned to service desk group"

For step 4 I considered task table as it contains all incident/ problem/change

Regards,

Mohammed Zakir

[Dr Atul G- LNG · Accepted solution]

Hi @JinkaH 

If you want to use less code or a no-code solution, the Flow Designer is the best option.