list of tickets assigned by Individual to a particular group

[ramprasad_purru]

Hi All,

Please help me to identify, List of tickets assigned by user1, user2, user3 to a group1.

i tried metric_instance report with below filters. But is not giving actuals. 

Even I tried sys_history_line table with below filters. It is also not accurate.

[Hanna_G]

Hi @ramprasad_purru 

Have you tried using the task table instead of metric_instance and sys_history_line?

Task will give incidents, sc_tasks, problems, changes etc. 

[Ankur Bawiskar]

@ramprasad_purru 

did you check sys_audit table?

Query sys_audit with field name = assignment_group, new value = group 1 sysId and updated by = user1/user2/user3

If my response helped please mark it correct and close the thread so that it benefits future readers.

[ramprasad_purru]

Hi Ankur,

Thank you for the response. I did few minutes ago. I am using "created by is one of"  and rest all as you said. 

It is taking too much time to fetch the data. but I guess this shows expected results accurately.

[Ankur Bawiskar]

@ramprasad_purru 

Glad to know that my response worked for you.

Thank you for marking my response as helpful.

Yes it will take time as that table is huge and system table.

If my response helped please mark it correct and close the thread so that it benefits future readers.