Home

Welcome to the CB_Activity wiki!

Here's the semi-automatic instruction.

The entire tool requires access to your superadmin/CB Admin account. Else nothing will work.

It's possible to just download and copy this Sheets template.

Do note that if you're in a country where comma (,) is used as a delimiter in Sheets formulas, you may have to replace all my semi-colons (;) as that's what's used in Sweden. Sorry.

CB_Activity Sheets template

Then you need to activate a trigger in your script. So open the Script Editor in the Tools menu. Go to Edit, Current project's triggers, and Add Trigger.

Choose function listCrOS, deployment Head, event source Time-driven, trigger type Hour timer, and interval Every hour. Also pick a notification setting, I suggest Notify me daily. Save.

I definitely recommend you read the contents of the script before running any functions. If for nothing else at least so you know it looks like it'll only do what I say.

The scripts can't do anything at all until you authorise them.

I've run the automatic export from a domain with 23 500 devices, without getting a time-out. It did take a while, but it kept going till it was done.

Now, this is not as fancy as GAT+, Gopher for Chrome, BetterCloud or Fleet or other such professional tools, but it has two advantages. It's free, and, for a lot of people, easier than doing the management with GAM.

GAM/GAMADV-XTD3 can, of course, do all this, but it requires a steady hand.

If you don't want to create a Sheet copy, the script is also available here in this repo.

DO NOTE! If you copy the script from here, instead of copying the entire Sheets file, you will have to enable the API manually. Here's how you do that. Click the following menus.

Tools / Script Editor Resources Advanced Google Services

Then click the button for

Admin Directory API

Ok and save.