Trying to use GAM to bulk suspend users.

[R2Carney]

Hi,

I am trying to use GAM in a powershell script to bulk suspend a list of users. 

The script I am using is this..

$list = Import-Csv C:\gam\suspend.csv

foreach ($entry in $list)

 { 

 c:\gam\gam.exe update user $($entry.username) suspended on

 }

I am getting an error that says the following:

Error: didn't expect on command at position 4

{}

Dito GAM 3.02

j...@ditoweb.com (Jay Lee)

Python 2.7.5 64-bit final

google-api-python-client 1.2

Windows-7-6.1.7601-SP1 AMD64

Path: C:\gam\

Has anyone seen that or know what might be causing it? 

Thanks, 

Robin

[Jay Lee]

Powershell can be a pain in the neck sometimes. GAM 3.1 can process the CSV much easier and MUCH faster:

gam csv C:\gam\suspend.csv gam update user $email suspended on

just make sure suspend.csv has a header line of "email" and you should be good to go.

Regards,

Jay Lee
Director of Google Apps Deployments   |  Dito

☎ (267) 712-9533  |  ✉ j...@ditoweb.com

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/1eee5059-dec2-4578-81e4-c35dc89d58de%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[R2Carney]

Thanks Jay!

 

That worked great on most of the users. I initially had a list of 369 users and this worked on all but 84 of them. The error i'm getting on the ones it didn't work for is:

 

<HttpError 403 when requesting https://www.googleapis.com/admin/directory/v1/use
rs/user...@warriors.winnacunnet.org?quotaUser=4ba52ec083cfc90e1625a6e092eb
54a44749fa04&fields=primaryEmail&alt=json&prettyPrint=false returned "Requestrat
e Exceeded">

 

Any idea what would cause that?

 

Thanks for your help,

-Robin

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

[Bruce Selzler]

Hello Team,

Does the CSV file contain a list of email address' or usernames? 

- Sez

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

[Andrew Rowland]

I'm getting the error: Error 404 resource not found: userKey - not found

Any ideas?

[Jay Lee]

Andrew,

  Can you offer a little more context here? Are you trying to suspend a bunch of users or something else?

  Have you confirmed the user exists and you have the address exactly right?

Jay Lee

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.

To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/7544e13b-24c2-4ac6-96f3-67066f928537%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Garren McKelvey]

hello.  I'm having a similar issue.  I'm trying to suspend users in bulk.  I used the command below:

gam csv C:\gam\suspend.csv gam update user ~email suspended on

But I keep getting this error:

c:\gam-64>gam csv C:\gam\suspend.csv gam update user ~email suspended on

Traceback (most recent call last):

  File "<string>", line 7346, in <module>

IOError: [Errno 2] No such file or directory: u'C:\\gam\\suspend.csv'

The error is clear.  For some reason the command is trying to put two \ marks where there should only be one.  However I can't see any way to fix this.  Help?

[Brian Gray]

On Thursday, May 28, 2015 at 2:37:15 PM UTC-5, Garren McKelvey wrote:

gam csv C:\gam\suspend.csv gam update user ~email suspended on

You can try these 2 ideas:

1) move the CSV file to the same folder as the gam executable, and leave out any path references:  gam csv suspend.csv gam update user ~email suspended on

2) use forward slash instead of backslash: gam csv C:/gam/suspend.csv gam update user ~email suspended on

[Shane Schaetz]

For posterity, the command should have been gam csv C:\gam\suspend.csv gam update user ~email suspended on

Notice the ~ instead of the $.

Jay Lee

Any ideas?

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.

To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/1eee5059-dec2-4578-81e4-c35dc89d58de%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.

[Scott Matarazzo]

I run "gam csv suspend.csv gam update user ~email suspended on" and get "error 403 not authorized to access this resource/api - forbidden"

it suspends the first account listed in the csv but not the rest and ends with that error.

Can someone help? I need to do a bulk suspend on Tuesday April 5,2016

[Nate Ferrell]

Sounds like you need to double check the admin permissions for the user running the command... wouldn't hurt to reauthorize GAM too as a checkpoint

if any of the users you're suspending are admins, then you *may* need to have SuperAdmin privileges to suspend them

[Scott Matarazzo]

Nate thanks for the response. After I tried reauthorizing and running the command I realized what the issue was. It was user error on my part, I had a typo in the email account. This has resolved my issue.

Thanks again!

[Nate Ferrell]

Awesome!! 😁

Thank you for your time,

Nate Ferrell

Systems Engineer | Google Apps Certified Administrator

x5120 | 817.494.0332

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Manager" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/R64nHwDlXww/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.

To post to this group, send email to google-ap...@googlegroups.com.

Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/3748fa51-c311-4343-b594-cc4195e1b4a6%40googlegroups.com.

[Manuel Pedro Barros]

Thanks for the ~tip Shane!