GAM 7 update

[Shane Jacobson]

I tried to update my GAM install today.  I ended up starting from scratch and I think everything goes ok up to the oauth create.  I am getting stuck on the gam oauth create, it give me this:

Anything I try and do after that says

the oauth2.txt not found

Error: no client access allowed.

My computer time is 14.5 seconds off of the time.is time.  I am on a school windows domain network.

[Ross Scroggs]

gam config clock_skew_in_seconds 20 save

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On Oct 8, 2024, at 11:08 AM, Shane Jacobson <trip...@gmail.com> wrote:

I tried to update my GAM install today.  I ended up starting from scratch and I think everything goes ok up to the oauth create.  I am getting stuck on the gam oauth create, it give me this:

<01.JPG>

Anything I try and do after that says

the oauth2.txt not found

Error: no client access allowed.

My computer time is 14.5 seconds off of the time.is time.  I am on a school windows domain network.

--
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/7f21d0df-3771-482f-ba31-5d6e9a242f4cn%40googlegroups.com.
<01.JPG><01.JPG>

[Shane Jacobson]

That worked, I saw something similar to that command in another thread for the new GAM but didn't know it would work for this version!

I was testing some of my commands this morning and my device move command works but there are errors I can't figure out.  This is the command I run below just as I have always used it along with the errors when I run it now.  The devices move just fine though???

What I do is scan a bunch of device serial numbers on my bench using a bar code scanner into a csv, then move devices to the root OU using GAM and this command below.  From there I can bulk re-name, change Notes and location in the device objects using Gopher for Chrome.

C:\GAM>gam csv devicemove.csv gam update cros query "id:~~serialnumber~~" ou "/"
2024-10-09T12:01:55.190+00:00,0/10,Using 5 processes...
Getting all CrOS Devices that match query (id:8BG2QV2), may take some time on a large Google Workspace Account...
Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...
Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...
Command: gam update cros query >>>id:<<< ou /

ERROR: Invalid Query
Help: Syntax in file C:\GAM\GamCommands.txt
Help: Documentation is at https://github.com/GAM-team/GAM/wiki
Command: gam update cros query >>>id:<<< ou /

ERROR: Invalid Query
Help: Syntax in file C:\GAM\GamCommands.txt
Help: Documentation is at https://github.com/GAM-team/GAM/wiki
Got 1 CrOS Device...
Got 1 CrOS Device that matched query (id:8BG2QV2)
Organizational Unit: /, Add 1 CrOS Device
Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...
Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...
Command: gam update cros query >>>id:<<< ou /

ERROR: Invalid Query
Command: gam update cros query >>>id:<<< ou /
Help: Syntax in file C:\GAM\GamCommands.txt

ERROR: Invalid Query
Help: Documentation is at https://github.com/GAM-team/GAM/wiki
Help: Syntax in file C:\GAM\GamCommands.txt
Help: Documentation is at https://github.com/GAM-team/GAM/wiki
  Organizational Unit: /, CrOS Device: dd05832e-fbbb-4f15-ad6f-91aa06cd9bb7, Added
2024-10-09T12:02:00.223+00:00,0,Processing item 10/10
Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...
Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...
Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...
Getting all CrOS Devices that match query (id:21FKH33), may take some time on a large Google Workspace Account...
Command: gam update cros query >>>id:<<< ou /

ERROR: Invalid Query
Help: Syntax in file C:\GAM\GamCommands.txt
Command: gam update cros query >>>id:<<< ou /
Command: gam update cros query >>>id:<<< ou /
Help: Documentation is at https://github.com/GAM-team/GAM/wiki

ERROR: Invalid Query

ERROR: Invalid Query
Help: Syntax in file C:\GAM\GamCommands.txt
Help: Syntax in file C:\GAM\GamCommands.txt
Help: Documentation is at https://github.com/GAM-team/GAM/wiki
Help: Documentation is at https://github.com/GAM-team/GAM/wiki
Got 1 CrOS Device...
Got 1 CrOS Device that matched query (id:21FKH33)
Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...
2024-10-09T12:02:01.231+00:00,0/10,Waiting for 2 running processes to finish before terminating, wait limit unlimited seconds
Command: gam update cros query >>>id:<<< ou /

ERROR: Invalid Query
Help: Syntax in file C:\GAM\GamCommands.txt
Help: Documentation is at https://github.com/GAM-team/GAM/wiki
Organizational Unit: /, Add 1 CrOS Device
  Organizational Unit: /, CrOS Device: 49720aa9-a449-465e-b414-f55d9499fb4a, Added
2024-10-09T12:02:06.235+00:00,0/10,Waiting for 2 running processes to finish before terminating, wait limit unlimited seconds
2024-10-09T12:02:06.444+00:00,0/10,Processing complete

C:\GAM>

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/7CED4A0D-53DC-4894-BEEC-E00DE3D034BE%40gmail.com.

[Shane Jacobson]

[Ross Scroggs]

Getting all CrOS Devices that match query (id:), may take some time on a large Google Workspace Account...

You have rows in your CSV file in no serial number

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/0daca7cd-2b69-4fcd-81b9-f3aefbbc979dn%40googlegroups.com.

[Shane Jacobson]

It runs fast.  I tried it with a few devices and then tried all kinds of stuff with just 1 device looking through what other people are doing.  This is a shot of the CSV attached.  I have never had any issues with this before.  I just wanted the devices no matter where they were located in our domain to move to the root of the domain.   This is exactly how I have run it for a year or longer.  It still works and moves the device or devices no matter where they are in our domain structure to the root but, it throws the errors now with this version of GAM.  I was only a couple verisons back when I updated and started over.

gam csv devicemove.csv gam update cros query "id:~~serialnumber~~" ou "/"

[Ross Scroggs]

Send me a Meet/Zoom invitation

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/5531868f-13e6-4c9d-ba29-f8b0872adb2bn%40googlegroups.com.
<01.JPG>

[Ross Scroggs]

Shane,

You can keep  the extra column if you do the following:

gam config csv_input_row_drop_filter "serialnumber:regex:^$" csv devicemove.csv gam update cros query "id:~~serialnumber~~" ou "/"

config csv_input_row_drop_filter "serialnumber:regex:^$" - this says to drop any rows with an empty serialnumber/

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/5531868f-13e6-4c9d-ba29-f8b0872adb2bn%40googlegroups.com.
<01.JPG>

[Shane Jacobson]

Sounds great Ross.  I just put a little note by that command in my documentation about using numbers in the second column.  I use those numbers simply as the layout of how they are on my bench.  I can use Gopher for Chrome to put 01-10 or how ever many I have in the asset id or user of the device so I can then sort them in the Gopher for Chrome sheet so they are in order in the sheet to how they are laying on my bench in a line.  Then I can re-name, re-label or what ever I need to do and everything is correct when I am finished, names match labels etc...  I really appreciate the help as well.