Example to export Chrome Devices with field names

1,304 views
Skip to first unread message

Chris Rollison

unread,
Dec 13, 2017, 10:33:49 AM12/13/17
to GAM for G Suite
Google must have recently changed some of the fields that they export for Chromebooks.  I have been exporting a csv file with the -full command and importing it into a mysql database.  Some of the fields changed and it threw my columns off.  It was a pretty easy fix to go back and add the new columns but I thought it would be better if I only exported out what I currently have columns for.  I'm getting confused on the example for the CROSFIELD name and how to format it correctly.  Does anyone have an example?  Thanks.

Ross Scroggs

unread,
Dec 13, 2017, 12:59:13 PM12/13/17
to google-ap...@googlegroups.com
Chris,

<CrOSFieldName> ::=

        activetimeranges|timeranges|

annotatedassetid|assedid|asset|

        annotatedlocation|location|

annotateduser|user|

        bootmode|

        deviceid|

        ethernetmacaddress|

        firmwareversion|

        lastenrollmenttime|

        lastsync|

        macaddress|

meid|

        model|

        notes|

        ordernumber|

        orgunitpath|org|ou|

        osversion|

        platformversion|

        recentusers|

        serialnumber|

        status|

        supportenddate|

willautorenew

<CrOSFieldNameList> ::= "<CrOSFieldName>(,<CrOSFieldName>)*"


<CrOSOrderByFieldName> ::=

        lastsync|location|notes|serialnumber|status|supportenddate|user


gam print cros [todrive] [query <QueryCrOS>] [limittoou <OrgUnitItem>]

        [orderby <CrOSOrderByFieldName> [ascending|descending]] [nolists] [listlimit <Number>] [start <Date>] [end <Date>]

[basic|full|allfields] <CrOSFieldName>* [fields <CrOSFieldNameList>]


Example: gam print cros fields deviceid,serialnumber,model > ./croslist.csv

Ross

On Wed, Dec 13, 2017 at 7:33 AM, 'Chris Rollison' via GAM for G Suite <google-ap...@googlegroups.com> wrote:
Google must have recently changed some of the fields that they export for Chromebooks.  I have been exporting a csv file with the -full command and importing it into a mysql database.  Some of the fields changed and it threw my columns off.  It was a pretty easy fix to go back and add the new columns but I thought it would be better if I only exported out what I currently have columns for.  I'm getting confused on the example for the CROSFIELD name and how to format it correctly.  Does anyone have an example?  Thanks.

--
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.
To post to this group, send email to google-apps-manager@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/046be1db-a32e-4818-92a9-5f667c4e0039%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

Jason Lockman

unread,
Dec 15, 2017, 9:51:23 AM12/15/17
to GAM for G Suite
Just wondering how you are using this database? I've considered doing something similar recently and was wondering what kind of options this gives you. I just got into GAM and Chrome management this year and still figuring out my workflows.
Reply all
Reply to author
Forward
0 new messages