RE: Is it possible to insert Asset ID using GAM for each device?

[Ajmal Rasouli]

Hi,

Is it possible to insert mass Asset ID using GAM?

I have 300 Chromebook, they are added into an OU in the G suite. I would like to assign each chromebook device with a code from 001 to 301. Without GAM I will click on each device and assign the Asset ID but will take time. Is it possible to insert mass Asset ID using GAM?

Kind regards,

Ajmal

[Jason Komendat]

Yea this is what I used

gam csv devices.csv gam update cros query:id:~theserialnumber assetid ~districttag

The CSV looks like this:

theserialnumber,districttag

121321,test1 121322,test2

[Ajmal Rasouli]

Thanks Jason,

Since I am a new GAM user just wanted to double check something with you. I have something similar to the following:

my OUs:

mydomain.org > abc.com > students > 5A >

this is my my list: How should I make the csv file? Also, how can I tell GAM to only update devices in the 5A ou?

Serial number Asset ID Location

GFTDF45 001 5A

GHFFGF5 002 5A

HGFGFG7 003 5A

HJHGUH8 004 5A

MJHGFDF 005 5A

GHDSWF4 006 5A

HGFDR45 007 5A

I have moved the 300 devices to 5A OU. 

Thanks for the help.

Kind regards,

Ajmal

[James SEYMOUR]

Hi Ajmal,

If you are updating the Chromebooks using a CSV then the location is not needed in the CSV. The CSV just needs the serial number and the new Asset ID. The command will find the Chromebook with a specific Serial Number and then update the corresponding Asset ID. I tend to make my headings without spaces so it is easier to write and run the GAM commands. Headings are case-sensitive. I you need help with making the CSV then I think you need to check Google for that :)

So your devices.csv will look like;-

Serialnumber,AssetID

GFTDF45,001

GHFFGF5,002

HGFGFG7,003

HJHGUH8,004

MJHGFDF,005

GHDSWF4,006

HGFDR45,007

The Command will be;-

gam csv devices.csv gam update cros query:id:~Serialnumber assetid ~AssetID

Cheers

James

[Ross Scroggs]

Ajmal,

Jame's command needs a slight modification.

gam csv devices.csv gam update cros query:id:~~Serialnumber~~ assetid ~AssetID

Ross

--

ross.s...@gmail.com

Jerudong International School
https://www.jerudonginternationalschool.com

Follow us on:

    

--
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/18bf80db-72cc-4151-a84a-149763ecc52cn%40googlegroups.com.

[Ajmal Rasouli]

Thanks James and Ross for your help.

Great community. 

Kind regards,

Ajmal

[sami dean]

Hi All,

Note sure if this is still an active thread. Command is not working for me, getting below error:

C:\GAM>
C:\GAM>gam csv TestAssetID.csv gam update cros query:id:~~Serialnumber~~ assetid ~AssetID

ERROR: Header "Serialnumber" not found in CSV headers of "Serialnumber,AssetID".

C:\GAM>

my csv file looks like this:

Serialnumber,AssetID

123456,asdasd

9874984,asdkbuasd

[James SEYMOUR]

Hi Sami,

Your command and CSV you have posted looks OK and works for me. I recreated the CSV and got this. Not sure what may be causing this, but looks like it is in the CSV, so have you tried to recreate it?

gam csv TestAssetID.csv gam update cros query:id:~~Serialnumber~~ assetid ~AssetID 2023-02-28T07:22:53.852+08:00,0/2,Using 2 processes...
Getting all CrOS Devices that match query (id:9874984), may take some time on a large Google Workspace Account...
Getting all CrOS Devices that match query (id:123456), may take some time on a large Google Workspace Account...
Got 0 CrOS Devices...
Got 0 CrOS Devices that matched query (id:9874984)
Got 0 CrOS Devices...
Got 0 CrOS Devices that matched query (id:123456)

[AST Tech (Linda)]

This is what I use to update asset id.

gam update cros cros_sn <SERIAL> assetid <ID> 

I use GAM in Google Cloud Shell and use Google Sheets as CSV, so an example of the command I use is:

gam csv gsheet <EMAIL> <SHEET URL> <SHEET NAME> gam update cros cros_sn ~sn assetid ~id