How to create a report to show User ID, User Name, Email, Department etc for specific assignment group

noorhaizad
Kilo Explorer

Hi

I need to create a report to show User ID, User Name, Email, Department etc for specific assignment group. But couldn't find the best way to create it. Appreciate your kind advice and assist

BR 

1 REPLY 1

Mike Patel
Tera Sage

You can dot walk Assigned To but the fields you are looking for are not available for group.

If you want members info of specific group than you can run report on Group Members Table (sys_user_grmember) and dot walk user field.