Help with GAM cmd

[Baran Kannan]

Hello There,

Please can you someone help me to find out gam cmd for all google groups, members, users and permissions saved to google sheet. 

I look forward to hear from you. 

Regards,

Baran.

This email and its attachments may be confidential and are intended solely for the use of the intended recipient. If you are not the intended recipient of this email and its attachments, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited. MANGOPAY S.A is a limited liability company incorporated in Luxembourg, having its registered office at 2 Avenue Amélie, L-1125 Luxembourg.

[Maj Marshall Giguere]

For advanced GAM:

Retrieve information about group members see: https://github.com/taers232c/GAMADV-XTD3/wiki/Groups-Membership#display-group-membership-in-csv-format

Example - get all the groups members for all groups in my domain and send to a spreadsheet on your MyDrive:

> gam print group-members domain example.com todrive

This will give all the members for all groups in the domain "example.com"

For information about a group or groups settings: https://github.com/taers232c/GAMADV-XTD3/wiki/Groups#display-information-about-specific-groups

Example - print the information including permission settings for a group:

> gam info group myg...@example.com

This is a pretty printed listing of a groups settings, not a csv, does not include members.

For standard GAM see: https://github.com/GAM-team/GAM/wiki/Command-Reference:-Groups#gam-group-command-reference

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/82ed2d34-3d95-4e47-b37a-89d89bc0e856n%40googlegroups.com.

[Baran Kannan]

Thanks for the swift response. We would like to have all groups (active/non-active), permissions list and members in a csv format. Please help. 

Regards,

Baran.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CADSK1vvZYCvjyevUUSsdPQXFMDH%3DJk7BYFXsAyYrXEUM_80K7g%40mail.gmail.com.

[Maj Marshall Giguere]

This command will retrieve the settings, in CSV form, for all groups in the Workspace, works in either advanced or standard gam

> gam print groups settings

If you want to see "everything" in one lump, group settings and members, members will be a single column vector containing a comma separated list of members.  

> gam print groups settings members

This will produce a CSV with each group as a single row showing the group's settings and a list of all members.  If you need to separate members by type substitute "managers | owners"  for "members"

If you want to know specifically about the members of a group(s) your only choice is the aforementioned "gam print group-members".  Group settings and member  information are separate things.

I suggest you do some experimentation along with reading the wiki pages in order to tailor, as much as possible given the api, the commands to your needs.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BcH436nB3iWZAffZG0EuAEBDbN1dJiVH9dsv%3DOS%3D8ZCVzWh_Q%40mail.gmail.com.

[Baran Kannan]

Hello again, 

Please can you let me know how to get google workspace groups including posting permissions, activity and number of members as well as any routing to a CSV

Regards,

Baran.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CADSK1vuoxXWuW4bb28S3G7EZjX8sFmyKsatZyUwPTNaeJAeLHA%40mail.gmail.com.

[Maj Marshall Giguere]

There is no api support for member posting permissions, it is only available on the GUI interface, you can only see the group setting "whoCanPostMessage".  There is no api support for activity, or routing information that I'm aware of.  

You can get counts of members as a CSV:

$> gam print groups members managers owners countsonly

Mix and match member types as required.

For detailed information see: https://github.com/taers232c/GAMADV-XTD3/wiki/Groups#display-information-about-selected-groups

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BcH436NY%2BxtKwY-RgKtcqNwUoC98yGw3b8Ef4UAGtvyjG7fnw%40mail.gmail.com.

[Baran Kannan]

Can we get posting permissions  and routing information of all google groups via GUI to a CSV please?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CADSK1vtoOx7cfaF7BaOFJGMc%2B%3Dm78XSbFC44JGej%3Df9AnN4vfw%40mail.gmail.com.

[Maj Marshall Giguere]

You can download a csv for each group individually.  It will contain the following information only:

Email address

Nickname

Group status

Email status

Email preference

Posting permissions

Join year

Join month

Join day

Join hour

Join minute

Join second

Time zone

Routing is probably  available on the Admin Console, it is for email, but I'm not sure about groups, you would have to check.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BcH4341AWBACwgkkDAROAkasCi7yao3sr_DbXksW_%2BKp89beg%40mail.gmail.com.

[Baran Kannan]

we would like to download all google groups instead of a group. would it be possible from the admin console?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CADSK1vvkEDCPB00tqfu%2By%3DDu-e6Pja4rWepcOSUO181s84%3DUrQ%40mail.gmail.com.

[Maj Marshall Giguere]

No,  it's a one at a time proposition.  You have to select each group, open the members, click on the downloader, rinse and repeat. Maybe someday Google will enhance the api, but I'm not holding my breath.

Hmm... might be possible to automate with a Python script, Selenium and the Chrome driver... not a project I'd want to take on, but possible I think.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BcH4350j5qoUoVZ7ohtdHrjFncxjBMJu3Mrug_FQrA8Tz0_8A%40mail.gmail.com.

[Baran Kannan]

Thanks, please can we get cmd for the below

1. google groups with active/non-active status 

2. google groups with permission

3. google groups with re-routing

Regards,

Baran.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CADSK1vs7-krjU%3D%2Bumwdo0cJmyReVL1oq%2B1yMvX6CnqudLj6dSQ%40mail.gmail.com.

[Ross Scroggs]

1. This is available for each member

2. The API does not supply this infomation thus it is not available to GAM

3. I'm not usre what this is, where do you see reference to this?

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BcH43682oCacL7YodMZEcXWu%2Bpp3ON922Ke-xuHfRjy1nuWgw%40mail.gmail.com.