Retrieve students current Org unit from CSV list

[Bill Sammons]

Using GAMADV, can anyone help me with the proper command to pull a report showing the current org unit of the students listed in a CSV file please?

Thank you in advance!

[Ross Scroggs]

Let's assume that your CSV file is named Students.csv and the column header is email

This will give you a file sorted by orgUnitPath and then primaryEmail

gam redirect csv ./StudentOrgUnits.csv multiprocess sortheaders orgUnitPath,primaryEmail csv Students.csv gam user "~email" print users fields ou

This will give you a file sorted by primaryEmail

gam redirect csv ./StudentOrgUnits.csv multiprocess sortheaders primaryEmail csv Students.csv gam user "~email" print users fields ou

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On Feb 27, 2026, at 10:30 AM, Bill Sammons <bill.s...@wpsb.info> wrote:

Using GAMADV, can anyone help me with the proper command to pull a report showing the current org unit of the students listed in a CSV file please?

Thank you in advance!

--
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/4a48ce94-abf0-42f8-9a3f-ce1d9f7111a7n%40googlegroups.com.

[Bill Sammons]

Perfect!  You are the best! 

Thank you!!