Want to know how Can I know the users who is not a member of any group?

ahmed21 · ‎12-07-2017

Hello ServiceNow community, I have a requirement to know who from the active users we have is not a member of a group with type "ITIL" (Type is an out of the box field on the group table.

we are on Helsinki Patch 11

Thanks a lot.

Kamal17 · ‎12-08-2017

Hi Ahmed,

You can pull all users who are not mapped to any group using the following method.

1. Create a script include and place the below function in it.

script:

*************************

*****************************

2. Create a report on 'sys_user' table and call the script include function in the report filter. Please refer the below screenshot. On running the report, you'll get the list of users who are not member of any group.

Similarly, you can use the below script to fetch the list of users who are member of non ITIL type group.

-Udhay

Please Hit like, Helpful or Correct depending on the impact of the response

View solution in original post

sushant007 · ‎12-07-2017

create a database view on sys_user and sys_user_grmember table.

Join these 2 tables considering all active sys_user records who are member or non-ITIL type group.

ahmed21 · ‎12-07-2017

Hello Sushant,

Can you help me with that, please?

Snow_123 · ‎09-12-2023

How to filter the users who are not managers of any group.