GAM/Gopher/GAC/Other Recommendations

[Garrett Mowrey]

I'm interested in how to automate/streamline tasks and not sure if GAM or other tools are worth investing the energy into given the tasks below.  I don't have a scripting background and manage 750 students and around 200 faculty & staff using GAC to manage the org, accounts and ChromeOS devices.  I currently export/import a .xlsx to GAC when making bulk user changes but I'm curious of other methods that offer other tasks that I'm not able to perform without installing GAM/Gopher/etc.

I'm very GUI dependent and find scripting a bit overwhelming and difficult to learn.  

These are the tasks that I'd like your help identifying what tool you'd suggest.  

-Change user accounts status from Active to Suspended and move the affected account to our Suspended OU.

-Identify user accounts that have not signed in in at least a year and suspend account then move to another OU

-Upload a .CSV with new students info to create new accounts and put in the correct OU for the beginning of each school year.  

Thanks in advance!

[Ross Scroggs]

See: https://github.com/GAM-team/GAM/wiki/Bulk-Processing#csv-files

See: https://github.com/GAM-team/GAM/wiki/Meta-Commands-and-File-Redirection#file-redirection

See: https://github.com/GAM-team/GAM/wiki/CSV-Output-Filtering#column-row-filtering

See: https://github.com/GAM-team/GAM/wiki/Users#create-a-user

-Change user accounts status from Active to Suspended and move the affected account to our Suspended OU.

-Let's suppose you have a CSV file SuspendUsers.csv with a column labelled primaryEmail

primaryEmail

us...@domain.com

us...@domain.com

...

Replace "/Suspended" with actual OU path.

gam redirect stdout ./SuspendUsers.txt multiprocess redirect stderr stdout csv SuspendUsers.csv gam update user "~primaryEmail" suspended true ou "/Suspended"

-Identify user accounts that have not signed in in at least a year and suspend account then move to another OU

gam config csv_output_row_filter "lastLoginTime:date<-1y" redirect csv ./SuspendUsers.csv print users fields lastlogintime

gam redirect stdout ./SuspendUsers.txt multiprocess redirect stderr stdout csv SuspendUsers.csv gam update user "~primaryEmail" suspended true ou "/Suspended"

-Upload a .CSV with new students info to create new accounts and put in the correct OU for the beginning of each school year.

-Let's suppose you have a CSV file CreateUsers.csv with columns labelled primaryEmail,firstName,lastName,password,OU

primaryEmail,firstName,lastName,password,OU

msmit...@domain.com,Mary,Smith,xxxxx,/Students/ClassOf2026

rjone...@domain.com,Robert,Jones,xxxxx,/Students/ClassOf2028

...

gam redirect stdout ./CreateUsers.txt multiprocess redirect stderr stdout csv CreateUsers.csv gam create user "~primaryEmail" firstname "~firstName" lastname "~lastName" password "~password" ou "~OU

Ross

----

Ross Scroggs

Ross.S...@gmail.com

--
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 visit https://groups.google.com/d/msgid/google-apps-manager/6d0c3184-977c-43d3-bfd5-2f5f55107a38n%40googlegroups.com.

[Paul Anderson]

We use both GAM and Gopher products. I use GAM with batch files for almost everything and Gopher for a few things, our other techs use the Gopher tools.  I recommend GAM for anyone as it really comes in handy and as you've probably noticed, it is easy to get help here when you need it.