How to export all group members with groups in excel?

manmathpanda · ‎04-17-2019

Hi Developers,

In my group list, there are 185 groups and i have to send all groups with group members to my manager. While going to group , i am only able to download groups in excel but not the group members?

Could anyone help me on this how can i achieve this to export all groups with their group members?

Regards,

Manmath

Ankur Bawiskar · ‎04-17-2019

Hi Manmath,

Better way for this is to run a query on sys_user_grmember table

Run a query on sys_user_grmember table with condition as Group.name is one of those 185 groups. it will show all the details then you can export it

you need to dot walk for name field

Another better approach is to run report on sys_user_grmember table but this table may not be available for reporting because it is system table

go to ui properties in left navigation; search with this "List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable."

there you should see this table;

Caution: you can remove the sys_user_grmember table from that list; run the report and again add back this table in that list

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎04-22-2019

Hi Manmath,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ankur Bawiskar · ‎04-29-2019

Hi Manmath,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Charlotte Crawl · ‎02-12-2021

I had the same question and this solution was 100% spot on for my needs. Thank you :- )

Grigory · ‎02-11-2022

There is a situation when the "User Name" is not enough and needs the "user id" also! It cant be exported from the "Group members" table. Does anybody know how to solve this?

Joe78man · ‎02-12-2022

In my case the field User has multiple fields within, I see it like this in the available columns:

User [+]

if I select it, right avobe the add and remove buttons a [+] shows up, when you click there all the fields that are part of 'User' will show up, and I get User ID, among other fields

The table is Group Member. I hope this helps