Using a csv file of device SN's

[Paul D'Hondt]

Hi everyone,

I'm trying to use a csv of over 1000 devices (serial numbers), and get a printout file of which ou each are in. (see below for why). Since I have SN's and not deviceid, I need to use query:id in there too.

I can't seem to figure out a way to do this. any thoughts? I've tried:

gam info cros query:id:serialnumberhere fields orgunitpath targetfolder c:\gam\testoutput

and 

gam print cros query:id:LR048CS6 fields orgunitpath (but it doesn't like a query when using print)

(I used Gam to move 1023 devices to a new ou.. but only 999 moved - I imagine a limit in google? - so I need to know which of the 1023 devices did'nt get moved so I can move them into an alternative ou).

[Ross Scroggs]

Paul,

This will give you all of the Chromebooks that aren't already in the correct OU; substitute your OU for /StudentChromebooks

Basic GAM:

set GAM_CSV_ROW_DROP_FILTER=orgUnitPath:regex:/StudentChromebooks

gam print cros query "id:LR048CS6" fields deviceid,orgunitpath,serialnumber > testoutput.csv

Advanced GAM:

gam config csv_output_row_drop_filter "orgUnitPath:regex:/StudentChromebooks" redirect csv ./testoutput.csv print cros query "id:LR048CS6" fields deviceid,orgunitpath,serialnumber

Verify that testoutput.csv makes sense.

Now you can move these to the correct OU.

gam update ou /StudentChromebooks croscsvfile ./testoutput.csv:deviceId

Ross

--
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/1e522646-1aa1-4c1a-a876-0489eeab921en%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Paul D'Hondt]

oh wow thanks Ross. Do I run this command each time for each device (like from a batch file?)

[Ross Scroggs]

Paul,

Let's call your serial number file crossns.csv with a column serialNumber

This will give you all of the Chromebooks that aren't already in the correct OU; substitute your OU for /StudentChromebooks

Basic GAM:

set GAM_CSV_ROW_DROP_FILTER=orgUnitPath:regex:/StudentChromebooks

gam csv crossns.csv gam print cros query "id:~~serialNumber~~" fields deviceid,orgunitpath,serialnumber > testoutput.csv

Edit testoutput.csv and delete all of the duplicate header rows, leave the one at the top: deviceId,serialNumber,orgUnitPath

Advanced GAM:

gam config csv_output_row_drop_filter "orgUnitPath:regex:/StudentChromebooks" redirect csv ./testoutput.csv multiprocess csv crossns.csv gam print cros query "id:~~serialNumber~~" fields deviceid,orgunitpath,serialnumber

testoutput.csv is ready to use, no editing required.

Verify that testoutput.csv makes sense.

Now you can move these to the correct OU.

gam update ou /StudentChromebooks croscsvfile ./testoutput.csv:deviceId

Ross

--

ross.s...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/07751815-42b7-4c2a-aebf-ab0a5a5e3cb3n%40googlegroups.com.

[Paul D'Hondt]

many thanks. It's greatly appreciated!

[Paul D'Hondt]

I'm using Basic gam, and I get "ERROR: Query:id:1234567 is not a valid argument for "gam print cros"". 

I had to add the additional colon, but it doesn't work without it either. (from the code above, it gave me "Error: queryid:123456 is not a valid argument" error.

[Ross Scroggs]

Paul,

What is: gam version

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/4a2478f2-9b70-4f1e-843e-819d72ea76d4n%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Paul D'Hondt]

a very, very old one. thanks for your help Ross.