How do I see Students, Org and groups they are in as a CSV

[Rick Humphrey]

Under the root domain we have Students OU.

Is their a way in gam to see the Students email adress with the ORg they are in  and the groups they are in as a CSV file?

Thank you all

[Ross Scroggs]

gam redirect csv ./StudentOrgUnits.csv print users fields ou query "orgUnitPath='/Students'" groups

Headers: primaryEmail,orgUnitPath,GroupsCount,Groups

All groups are space-separated in Groups column

gam redirect csv ./StudentOrgUnits.csv print users fields ou query "orgUnitPath='/Students'" groupsincolumns

Headers: primaryEmail,orgUnitPath,Groups,Groups.0,Groups.1,Groups.2

Each group is in a separate column

Ross

----

Ross Scroggs

Ross.S...@gmail.com

--
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 visit https://groups.google.com/d/msgid/google-apps-manager/041f9e76-e3f1-4587-9329-0c5506b9f26fn%40googlegroups.com.

[Rick Humphrey]

Is it possible to also get the created date in the CSV file? sorry forgot that

[Ross Scroggs]

fields ou,creationtime

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/bd7026f2-f8b0-4f0a-b305-ebe8c4540aa5n%40googlegroups.com.

[Rick Humphrey]

can this be in? If so where do you put it?

gam redirect csv ./StudentOrgUnits.csv print users fields ou query "orgUnitPath='/Students'" groups

Headers: primaryEmail,orgUnitPath,GroupsCount,Groups

All groups are space-separated in Groups column

[Ross Scroggs]

gam redirect csv ./StudentOrgUnits.csv print users fields ou,creationtime query "orgUnitPath='/Students'" groups

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/0588e050-c12b-4979-91b8-7c9407892e40n%40googlegroups.com.

[Rick Humphrey]

Thank you again Ross

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/F17A62BC-53A3-46D0-B21E-D715CC1DD90D%40gmail.com.

--

Rick Humphrey

Wolf Creek Public Schools

Technology Services

403-783-5441  ext 1427