Query for a particular assignment groups a ticket went through

[VL10]

Is it possible to write a query to check for all tickets that went through a certain assignment group during its reassignment journey, like get a list of all tickets where it passed through was a certain group?  

So, if a query was initially in assignment group A then went through B, C, D before going to E where it was resolved, like this:

A -> B -> C -> D -> E

We want to query for B or C or D within this list.  A or E can already be queried for as First Assignment Group or Assignment Group).

Many thanks in advance.

[Dr Atul G- LNG]

Hi @VL10 

Greetings!!

did you try OOTB Metrics ? May be that will helpful.#

Please accept my answer as solution or mark it helpful.

Regards

Atul G

[Marco0o1]

Hi @VL10 :

You can just make a encoded query, if you group is a list use "groupDYNAMICd6435e965f510100a9ad2572f2b47744", that will find any group are you are member of that group, a example using the user_criteria list in which ones i have acces:

var accesGR = new GlideRecord("user_criteria");
accesGR.addEncodedQuery("groupDYNAMICd6435e965f510100a9ad2572f2b47744");
accesGR.query();


while(accesGR.next()){
    gs.print("I have acces to: " + accesGR.getValue('name'));
}

In my example i run this in a Background script and will return the name of the user criterias i have a group woul im a member, if you need for one specific table or something just ask. Hope that help you.