List of users including custom attributes
965 views
Skip to first unread message
Marie Kennedy
May 21, 2021, 12:55:07 PM5/21/21
to GAM for Google Workspace
OK. I'm slammed, but of course, and need a report of all users. I can't seem to get a report from google for all users, including custom attributes. Google support kindly suggested that I request the feature.
The field I need is called STUDENTID, but I'm not sure how to get the full field name (what Google sees it as). Any help would be much appreciated.
~~~~~~~~~~~~~~~~~~~~~
Marie Kennedy
Systems Administrator
Oregon Trail School District
Ross Scroggs
May 21, 2021, 12:58:09 PM5/21/21
to google-ap...@googlegroups.com
Marie,
From that name, it's probably in a custom schema.
Do: gam show schemas
Is there a schema with that field?
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/CA%2BKVMemdYstgaTqvv1StZFwM9fn3JvPcHeW4jQCrc3TKq0gqxA%40mail.gmail.com.
Ross Scroggs
Ross Scroggs
May 21, 2021, 1:01:37 PM5/21/21
to google-ap...@googlegroups.com
Marie Kennedy
May 21, 2021, 1:09:27 PM5/21/21
to GAM for Google Workspace
There is. There are 2, this is the one that I need.
Schema: Student_ID (2/2)
schemaId: rrN-4kr6Q3u5e2OJoa-Nig==displayName: Student ID
Field: STUDENT_ID
fieldId: akQ1N_m5RS6OVh3Jwo_kUg==
fieldType: INT64
displayName: STUDENTID
multiValued: False
readAccessType: ADMINS_AND_SELF
~~~~~~~~~~~~~~~~~~~~~
Marie Kennedy
Systems Administrator
Oregon Trail School District
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS-fGxXMpRfDg5sT%3Di0o7oh9MzN0TMfWpvtLMMzdZ9PN0w%40mail.gmail.com.
Marie Kennedy
May 21, 2021, 1:09:50 PM5/21/21
to GAM for Google Workspace
Ah, OK. Just saw this.
~~~~~~~~~~~~~~~~~~~~~
Marie Kennedy
Systems Administrator
Oregon Trail School District
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS-Gw5LnurTgp8KK7ihjD5syVJ4G0oUv_Z1Xyjpyp2r60A%40mail.gmail.com.
Marie Kennedy
May 21, 2021, 1:13:55 PM5/21/21
to GAM for Google Workspace
Doesn't look like it's showing the custom Student_ID field from that command though.
~~~~~~~~~~~~~~~~~~~~~
Marie Kennedy
Systems Administrator
Oregon Trail School District
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS-Gw5LnurTgp8KK7ihjD5syVJ4G0oUv_Z1Xyjpyp2r60A%40mail.gmail.com.
Ross Scroggs
May 21, 2021, 1:43:01 PM5/21/21
to google-ap...@googlegroups.com
Marie,
Try: gam print users custom Student_ID
Ross
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BKVMemC8QNPfgWkhS0NSiW0F6OmpT2Kuk9V-QdBnsBkEYjF0Q%40mail.gmail.com.
Ross Scroggs
Marie Kennedy
May 21, 2021, 1:52:28 PM5/21/21
to GAM for Google Workspace
Yeah, had tried that. Sending an invite now. Thanks, Ross!
~~~~~~~~~~~~~~~~~~~~~
Marie Kennedy
Systems Administrator
Oregon Trail School District
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS83_RcFQ%3DU6F6sDn-Jg7mVwUiw7DUYi_2mObsxRLf94nA%40mail.gmail.com.
Marie Kennedy
May 21, 2021, 2:07:50 PM5/21/21
to GAM for Google Workspace
I got it, Russ. Case sensitive (although I thought I had gotten that right the first time). Thanks!!!
~~~~~~~~~~~~~~~~~~~~~
Marie Kennedy
Systems Administrator
Oregon Trail School District
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS83_RcFQ%3DU6F6sDn-Jg7mVwUiw7DUYi_2mObsxRLf94nA%40mail.gmail.com.
Ross Scroggs
May 21, 2021, 2:31:18 PM5/21/21
to google-ap...@googlegroups.com
Marie,
I got pulled into a support call, is the meeting still valid?
Ross
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BKVMek5WgBL4LcZFy_SDQo%3Dg6nQnBuuzZxuE%2B%3DHY2XZUw05Fw%40mail.gmail.com.
Ross Scroggs
Marie Kennedy
May 21, 2021, 2:35:46 PM5/21/21
to GAM for Google Workspace
I got it, Russ. Case sensitive. I should have remembered. Thanks!!!
~~~~~~~~~~~~~~~~~~~~~
Marie Kennedy
Systems Administrator
Oregon Trail School District
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS9wG%2BpYsJVZc5REthhPe4nr0ZY%2BLmmBm%2B5ko91WQSt06Q%40mail.gmail.com.
Ross Scroggs
May 21, 2021, 2:36:54 PM5/21/21
to google-ap...@googlegroups.com
Good Deal GOOD DEAL good deal
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CA%2BKVMe%3DQ_Wznoz7d%3DDtUJtuWhHfXN6iOxWExrhbCKUnWLafKPA%40mail.gmail.com.
Ross Scroggs
Seth Dimbert (Hillel Yeshiva)
Aug 24, 2021, 1:07:57 PM8/24/21
to GAM for Google Workspace
Ross,
The custom keyword helps.. but how can I send allfields *and* custom schema to a single sheet?
Ross Scroggs
Aug 24, 2021, 1:14:41 PM8/24/21
to google-ap...@googlegroups.com
Seth,
Say "schemas all" to get info for all schemas or "schemas abc,xyz" in you only want information for specific schemas.
gam print users allfields schemas all
Ross
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/4533392f-06b9-4e65-ba3e-eff7047b6dban%40googlegroups.com.
Ross Scroggs
Seth Dimbert (Hillel Yeshiva)
Aug 24, 2021, 2:14:27 PM8/24/21
to GAM for Google Workspace
I want to see all of the columns I get from gam ou_and_children_ns Student print allfields todrive along with the custom schemas as well.
I tried gam print users allfields schemas all todrive but it didn't do what I expected; all I got was email and the custom schema values. I want to see, for example, the OU path we well.
-SD
Seth Dimbert (Hillel Yeshiva)
Aug 25, 2021, 8:28:16 AM8/25/21
to GAM for Google Workspace
What I'm trying to do is export all of my student OUs and see the standard columns (included in allfields) alongside the custom schema data I've added, all in single spreadsheet. Can someone help me with this?
I'm stumped. :(
Ross Scroggs
Aug 25, 2021, 9:31:29 AM8/25/21
to google-ap...@googlegroups.com
Seth,
THe code is messed up but this should do what you want.
gam print users full todrive
Ross
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/7c28f49b-0586-44e3-9534-27ffcb8e6652n%40googlegroups.com.
Ross Scroggs
Reply all
Reply to author
Forward
0 new messages