Report Request: Groups Without Managers and Assigned Users

[bharathvall]

Requesting the creation of reports for the following requirements:

- Groups without managers (including group name)
- Groups without assigned users (including group name, manager name, and manager email)

Kindly provide support for implementing these reports.

[Dr Atul G- LNG]

Hi @bharathvall 

Create a report on Group table

• Manager is empty

for 2nd:

https://youtu.be/UNnSPE2eP4s

[Tanushree Maiti]

Hi @bharathvall 

Groups without managers (including group name):  Apply this condition in report

In Sys_user_group table - 

    

Groups without assigned users (including group name, manager name, and manager email)

In sys_user_grmember table ,

select following column

With filter condition User is empty