Let's organize aliases, groups, etc..

[Kabbott]

I work at a company that uses Google Workspace since it was G suites.  We have an obnoxious number of aliases and groups which makes administrating the tool hard as $#@&.  Is there a way to export all the groups and aliases to better organize them?  Please help (said like Lilu Dallas).

[icrew]

Hi @Kabbott :

At least in terms of the exporting part, you can do this with the free, open source, command-line, indispensable GAM tool. Check out https://github.com/jay0lee/GAM/wiki, https://github.com/taers232c/GAMADV-XTD3/wiki, and https://groups.google.com/forum/#!forum/google-apps-manager for more details.

Specifically, check out https://github.com/jay0lee/GAM/wiki/GAM3CSVListings

Hope that helps, at least a little,

Ian

[AlanM]

It is also quite easy to use Apps Scripts and the Directory API to manage the required data with Google Sheets.