GAM Alternatives

GAM reviews and mentions

• What Open Source Projects Do You Use In Your District?
  27 projects | /r/k12sysadmin | 16 Nov 2022

  GAM and GAMADV-XTD3 -- Command line tool for managing G Suite. Allows me to run scripts to manage accounts. Very useful for setting student photos on their G Suite accounts. Great tool for any G Suite admin.

• Remove shares to external non owner users
  2 projects | /r/gsuite | 13 Oct 2022

  #!/usr/bin/env python2 """ # Purpose: For a Google Drive User(s), show all drive file ACLs for files shared with users outside of your account. # Note: This script can use Basic or Advanced GAM: # https://github.com/jay0lee/GAM # https://github.com/taers232c/GAMADV-XTD3 # Usage: # 1: Get users in account # $ Basic: gam print users > accountusers.csv # $ Advanced: gam redirect csv ./accountusers.csv print users # 2: Get ACLs for all files, if you don't want all users, replace all users with your user selection in the command below # $ Basic: gam all users print filelist id title permissions owners > filelistperms.csv # $ Advanced: gam config auto_batch_min 1 redirect csv ./filelistperms.csv multiprocess all users print filelist fields id,title,permissions,owners.emailaddress # 3: From that list of ACLs, output a CSV file with headers "Owner,driveFileId,driveFileTitle,permissionId,role,emailAddress" # that lists the driveFileIds and permissionIds for all ACLs with the non-account users # (n.b., driveFileTitle, role, and emailAddress are not used in the next step, they are included for documentation purposes) # $ python GetSharedWithNonAccountUsersDriveACLs.py accountusers.csv filelistperms.csv deleteperms.csv # 4: Inspect deleteperms.csv, verify that it makes sense and then proceed # 5: Delete the ACLs # $ gam csv deleteperms.csv gam user "~Owner" delete drivefileacl "~driveFileId" "~permissionId" """ import csv import re import sys FILE_NAME = 'name' ALT_FILE_NAME = 'title' QUOTE_CHAR = '"' # Adjust as needed LINE_TERMINATOR = '\n' # On Windows, you probably want '\r\n' PERMISSIONS_N_TYPE = re.compile(r"permissions.(\d+).type") if (len(sys.argv) > 3) and (sys.argv[3] != '-'): outputFile = open(sys.argv[3], 'wb') else: outputFile = sys.stdout outputCSV = csv.DictWriter(outputFile, ['Owner', 'driveFileId', 'driveFileTitle', 'permissionId', 'role', 'emailAddress'], lineterminator=LINE_TERMINATOR, quotechar=QUOTE_CHAR) outputCSV.writeheader() if (len(sys.argv) > 2) and (sys.argv[2] != '-'): inputFile = open(sys.argv[2], 'rbU') else: inputFile = sys.stdin accountUsers = set("[email protected]") usersFile = open(sys.argv[1], 'rbU') for row in csv.DictReader(usersFile, quotechar=QUOTE_CHAR): accountUsers.add(row['primaryEmail']) usersFile.close() for row in csv.DictReader(inputFile, quotechar=QUOTE_CHAR): for k, v in row.iteritems(): mg = PERMISSIONS_N_TYPE.match(k) if mg and v == 'user': permissions_N = mg.group(1) if row.get('permissions.{0}.deleted'.format(permissions_N)) == 'True': continue emailAddress = row['permissions.{0}.emailAddress'.format(permissions_N)] if row['permissions.{0}.role'.format(permissions_N)] != 'owner' and emailAddress not in accountUsers: outputCSV.writerow({'Owner': row['owners.0.emailAddress'], 'driveFileId': row['id'], 'driveFileTitle': row.get(FILE_NAME, row.get(ALT_FILE_NAME, 'Unknown')), 'permissionId': 'id:{0}'.format(row['permissions.{0}.id'.format(permissions_N)]), 'role': row['permissions.{0}.role'.format(permissions_N)], 'emailAddress': emailAddress}) if inputFile != sys.stdin: inputFile.close() if outputFile != sys.stdout: outputFile.close()

• What Open Source Projects Are You Using?
  23 projects | /r/k12sysadmin | 31 Jan 2022

  GAM - Google Workspace. I don't know what I'd do without this.

• Google as email server
  1 project | /r/sysadmin | 13 Jan 2022

  use GAM to share and accept on users behalf https://github.com/jay0lee/GAM It's incredibly powerful and it's all command line.

• Syncing Google Workspace Users with Microsoft AD
  2 projects | /r/k12sysadmin | 6 Dec 2021

  GAM If you have not yet have the pleasure of using GAM, I would highly recommend trying it out -- it's not exactly pertinent to this post, but if you've not used it, it's amazing, and a huge time saver when trying to manage Google sometimes.

• Has anyone had any experience working tech jobs for K-12 schools? What should I expect? What skills should I brush up on?
  1 project | /r/sysadmin | 27 Nov 2021

  It's easy enough to stumble through, and Google provides training online. Also, look into GAM, https://github.com/jay0lee/GAM. Best tool you can ever use.

• Transfer User inc all data from one Workspace account to another
  1 project | /r/gsuite | 26 Nov 2021

  We had to do this a couple years ago when we moved ~500 accounts from one Workspace tenant to another. We used MigrationWiz and GAM to make it less painful, but it still wasn't the prettiest thing ever. If we had to do it over again we'd probably use Google Workspace Migrate which wasn't an option back then.

• Clean Up Inactive Google Accounts
  1 project | /r/k12sysadmin | 22 Nov 2021

  GAM is probably your best bet. You can run a query for suspended accounts and move them to a specified OU. You can also run a query for users with last logon time equal to whatever and then move those accounts.

• Offboarding Google Workspace User
  1 project | /r/msp | 14 Nov 2021

  If it's a very regular process / procedure, you may want to look at https://github.com/jay0lee/GAM

• Workspace account - change primary domain
  1 project | /r/gsuite | 12 Nov 2021

  Do check out GAM, it might do it (not all at Google know about this tool): https://github.com/jay0lee/GAM/releases

• A note from our sponsor - InfluxDB
  www.influxdata.com | 23 Apr 2024

  Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →