How to export all group members with groups in excel?

[manmathpanda]

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 · Accepted solution]

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

[Mark Roethof]

Hi Manmath,

Is this question solved with answering https://community.servicenow.com/community?id=community_question&sys_id=feda9c4cdb8933000be6a345ca96...? Or do you need more info?

Let me know.

Kind regards,
Mark

---

LinkedIn

[Joe78man]

Great option only if you are granted permission to admin tables. Another obvious should have had option missed by SNow.

I have to manually copy the list and paste it because I won't be granted access to sys tables. I actually can see the list, can copy the list manually, but I cannot right click > download as it should have been possible from the beginning.

Another obvious must have option missed only possible to work arround by having access to sys_tables

[Mark Roethof]

Hi Manmath,

Is this question solved with answering https://community.servicenow.com/community?id=community_question&sys_id=feda9c4cdb8933000be6a345ca96...? Or do you need more info?

Let me know.

Kind regards,
Mark

---

LinkedIn