Report Request: Groups Without Managers and Assigned Users

bharathvall
Giga Contributor

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.

2 REPLIES 2

Dr Atul - LNG
Tera Patron

Hi @bharathvall 

Create a report on Group table

  • Manager is empty

 

DrAtulGLNG_0-1776420485037.png

 

for 2nd:

DrAtulGLNG_1-1776420566312.png

 

https://youtu.be/UNnSPE2eP4s

 

Dive into the fundamentals of turning raw data into meaningful insights. Understand key visualization techniques and when to use them. Watch a hands-on demo that brings these concepts to life. Learn how effective visuals can drive smarter decisions and storytelling. They are only for knowledge ...

Tanushree Maiti
Tera Patron

Hi @bharathvall 

 

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

In Sys_user_group table - 

    Screenshot 2026-04-17 154920.png


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

 

In sys_user_grmember table ,

select following column

Screenshot 2026-04-17 155850.png

 

With filter condition User is empty