Tracking AUE Date for Chromebooks

[Bryan Guidroz]

Does anyone have any suggestions on how to track AUE dates for their Chromebooks?

https://support.google.com/chrome/a/answer/6220366?hl=en

I was hoping to us GAM to update some field associated with each Chromebook so I can produce lists of devices meeting the AUE date.

I can do it by model name, but I'd like to have a date in the directory if possible.

Suggestions?

[Jay Lee]

The challenge here is that:

https://support.google.com/chrome/a/answer/6220366?hl=en

is the only "source of truth" for AUE dates but the device names don't fully align with what is in the API / Admin console. Also, pulling the HTML and using that with GAM isn't terribly easy to do nor would it be reliable (HTML format changes, GAM breaks).

I'd suggest putting in a support ticket to Google asking that AUE be added to the admin console and API so that GAM can use it.

Jay

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" 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 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/392b5a54-e7aa-4947-9c0e-f347fafdc97e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Bryan Guidroz]

I was going to add it manually on my own... I was looking for a field to update for the time being.

I'll enter a ticket

I looked here:

https://developers.google.com/admin-sdk/directory/v1/guides/manage-chrome-devices

And there is a "supportEndDate" but I don't see that anywhere else.

 "kind": "directory#chromeosdevices",
  "chromeosdevices": [
     {
       "kind": "directory#chromeosdevice",
       "deviceId": "deviceId value",
       "serialNumber": "device serialNumber",
       "status": "ACTIVE",
       "lastSync": "2013-03-05T17:30:04.325Z",
       "supportEndDate": "2014-04-05T17:30:04.325Z",

[Ross Scroggs]

Bryan,

From the API documentation:

The final date the device will be supported. This is applicable only for those devices purchased directly from Google. The value is in ISO 8601 date and time format. The time is the complete date plus hours, minutes, and seconds in the form YYYY-MM-DDThh:mm:ssTZD. For example, 2010-04-05T17:30:04+01:00.

Ross

--

You received this message because you are subscribed to the Google Groups "GAM for G Suite" 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 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/30812679-4f48-4307-9d24-eaded83a8629%40googlegroups.com.

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

--

Ross Scroggs

ross.s...@gmail.com

[Bryan Guidroz]

Thanks Jay and Ross.

I've submitted a ticket to Google Support requesting the AUE date be added to the Admin Console.

I'll just keep Excel'ing it for the time being.

Bryan

On Monday, May 13, 2019 at 12:29:09 PM UTC-5, Bryan Guidroz wrote:

[Bryan Guidroz]

Just FYI... Google support says:

“
We just finished with our product engineers and they have indicated that the request has been added to the road map. No ETA has been provided. They have indicated that many clients have requested this feature. The request was submitted back on April 24. At this point I will be updating you monthly or as soon as we get new information from our product engineers. ”

[Jay Lee]

OK, I poked around at this and came up with a way to parse the Google AUE help page, generate a list of devices and then do a rough match against the model reported by the API.

https://github.com/jay0lee/GAM/commit/c05c0402412192f6604bba4df8f3ad95b3bbf7ae

Bryan, try the latest code in the GAM repository (let me know which OS / download you use and I can share a binary with you if you need it). And you can run something like:

GAM_CSV_ROW_FILTER='{"guessedAUE": "date<2019-12-31"}' gam print cros model guess_aue

to get a CSV of all devices that will reach AUE by end of year.

Jay

On Mon, May 13, 2019 at 8:02 PM Bryan Guidroz <bryang...@tpsdonline.org> wrote:

Just FYI... Google support says:

“
We just finished with our product engineers and they have indicated that the request has been added to the road map. No ETA has been provided. They have indicated that  many clients have requested this feature. The request was submitted back on April 24. At this point I will be updating you monthly or as soon as we get new information from our product engineers. ”

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" 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 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/0bfee017-02b8-4a36-8c2e-b62e6a24c905%40googlegroups.com.

[Jay Lee]

By the way, the matching of API model against the AUE page model is likely not 100%. You should visually confirm the output is correct before taking some action like deprovisioning devices based on this output.

Jay

[Derry Lyons]

I *think* I see the field in the Admin Console now ... does that mean it'll soon be available in GAM? :)

[Ross Scroggs]

Derry,

It has been for a while.

gam print cros fields autoupdateexsoration,serialnumber,...

Ross

--

ross.s...@gmail.com

On Sep 13, 2019, at 4:08 PM, Derry Lyons <ly...@skschools.org> wrote:

I *think* I see the field in the Admin Console now ... does that mean it'll soon be available in GAM? :)

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" 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/b6a5d47c-785e-4ed4-b0a8-108a426eec6f%40googlegroups.com.

[Derry Lyons]

PERFECT! I was trying to use the supportEndDate field, not the autoupdateexpiration field -- works great now! Thanks for the help... :) Derry

On Friday, September 13, 2019 at 7:05:19 PM UTC-7, Ross Scroggs wrote:

Derry,

It has been for a while.

gam print cros fields autoupdateexpiration,serialnumber,...

Ross

--

ross....@gmail.com

On Sep 13, 2019, at 4:08 PM, Derry Lyons <ly...@skschools.org> wrote:

I *think* I see the field in the Admin Console now ... does that mean it'll soon be available in GAM? :)

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.

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

[Seth Dimbert (Hillel Yeshiva)]

Ok... so for us n00bs, what would the full command be if, say, I wanted to export a Google Sheet that listed the AUE, Asset ID, Serial and OU for all of the devices in domain/Chromebooks and all child OUs?

I know this is wrong but how close am I?

gam csv gsheet cros fields autoupdateexsoration,serialnumber,AssetID,OrgUnit ou and children Chromebooks

-SD

[Frank Austin]

With this in mind. What about if the devices you want are not Chromebooks, but Macs, Windows laptops, with the Model also?

Frank Austin | Senior IT Specialist

859-534-0168 Ext 1026  |  Hebron, Ky, USA

 

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/8e51dc60-21bd-4465-9b02-169e2d57cd2dn%40googlegroups.com.

[Gabriel Clifton]

Keep up the good work on GAM and update expiration. When you can create an auto updating Sheet with this information, it is great.

I have the same thing for my Windows devices pulling information from our software deployment server. Keeps you diligent on making sure systems are up to date and on Chromebooks helps you get some of the old ones out fast.

Yes, those do say 1970, it is a bug with the manufacturer that has not been fixed yet.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CALZxMrNKrySo%2BiG0DE4K0f%2BP%3Djf7iq%2BL4trJEt26_c245%2Bo3Jw%40mail.gmail.com.

--

Gabriel Clifton | Network Administrator

Fort Stockton ISD | Technology Center
gabriel...@fsisd.net | http://www.fsisd.net
Office (432) 336-4055 ext 2

Fax (432) 336-4050
1204 W. Second St., Fort Stockton, TX 79735

CONFIDENTIALITY NOTICE: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.

"You must always be willing to work without applause."
— Ernest Hemingway

"You just have to find that thing that's special about you that distinguishes you from all the others, and through true talent, hard work, and passion, anything can happen."
— Dr. Dre

[Ross Scroggs]

Seth,

gam redirect csv StudentCros.csv cros_ou_and_children /Students print cros fields autoupdateexpiration,serialnumber,assetid,orgunitpath

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/8e51dc60-21bd-4465-9b02-169e2d57cd2dn%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Gabriel Clifton]

One thing to watch for is that I noticed when I did this, the report will pull ALL devices in your domain so I added status so that I could sort through whether it was active, disabled, or deprovisioned. You may be only wanting to track active devices.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS_OyJcuqcha-QFBmzW%3DT50MZTKmUQhjCj8tE08fetCtyQ%40mail.gmail.com.

[Seth Dimbert (Hillel Yeshiva)]

Thanks, everyone (especially Ross!). 

How would I convert the command to produce a Sheet in my drive instead of a CSV file?

-SD

[Gabriel Clifton]

todrive

That always sends to your Google Drive

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/cbd01e5c-6d3c-4cbe-bdaf-65f826ce538an%40googlegroups.com.

[Ross Scroggs]

Seth,

With Gabriel's suggestion you want:

gam cros_ou_and_children /Students print cros fields autoupdateexpiration,serialnumber,assetid,orgunitpath todrive

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJXDcnvsMDwjCrbPxO-%3DWaNLYdieom%3Dr%3D1BkBtD6wo0JyhEP4Q%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

[Seth Dimbert (Hillel Yeshiva)]

Thanks again, Ross. :)

I added a few whiz-bangs and gee-gaws... and now I have a single command which exports the following data to a Google Sheet in a Shared Drive folder of my specification:

• Status
• AUE
• Serian Number
• AssetID
• OU

Here's the command:

gam cros_ou_and_children /Chromebooks print cros fields status,autoupdateexpiration,serialnumber,assetid,orgunitpath todrive tduser us...@domain.org tdparent <<folderID>> tdtitle CB_Info

In that example, I'm gathering data for all Chromebooks in the /Chromebooks OU (and all child OUs) and exporting it to a Sheet called CB_Info located in the Shared Drive folder specified by <<folderID>>. us...@domain.org must be a user with write-access to that folder.