how to create a report that shows the group details which has less than 5 ?

[Vasu20]

A report that shows groups which has less than 5 members needs to be displayed to the user.

Any help around this will be appreciated.

Thank you so much in advance.

Best Regards,

Vasu

[Maik Skoddow · Accepted solution]

Hi @Vasu20 

you can build on table "sys_user_group" as usual however additionally you have to configure a related list condition for table "sys_user_grmember". See https://docs.servicenow.com/bundle/vancouver-platform-user-interface/page/use/using-lists-v3/task/cr... 

Maik

[Vasu20]

Thank you so much, it helped.

Best Regards,

Vasu