opened incidents by service desk

[Guptha123]

Hi team,

Iam trying to pull the report which are opened by service desk via metric table. how to fetch the report based on Assignment group, as opened by is referencing to user table.

Thanks in advance

Thanks and Regards,

Sai Prakash

[AndersBGS]

Hi @Guptha123 ,

You can create a database view to join the sys_user table with the sys_user_grmember table and then make the report based on that database view. You can't dot-walk from sys_user to sys_user_group table or sys_user_grmember table.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders