Reporting on drive events by owner for users in an OU

[Aaron Smith]

I need to run a report for drive events by OU and by owner. I am wanting to find files and folders that still have people viewing and editing them even though the owner of the file has a suspended account.

I have 2 GAM commands that I have been working on but neither one is giving me exactly what I need.

• The first one returns all of the drive events were the users in the OU are Actors, but I need to see the drive events where all of those users are owners.

gam report drive OU <OU-Path> events view,edit

• The second command returns all of the users but fails to pass the primaryEmail to the second part of the command. In the second part of the command I am able to specify a single email address which returns what I am looking for however I need this to be dynamic so that it ban repeated for all accounts in the OU.

gam print users query "orgUnitPath='/Path/To/OU'" | gam csv - gam report drive filter "owner==~primaryEmail" events edit,copy,download,print,view todrive

Any idea?

Thanks

[Ross Scroggs]

Aaron,

Correction, use ~~ ariunf primaryEmail

gam print users query "orgUnitPath='/Path/To/OU'" | gam csv - gam report drive filter "owner==~~primaryEmail~~" events edit,copy,download,print,view todrive

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 on the web visit https://groups.google.com/d/msgid/google-apps-manager/3b802131-245a-407c-b876-539382b779ddn%40googlegroups.com.

[Aaron Smith]

Excellent! Thank you that worked!

[Aaron Smith]

Would you happen to know how I could append each of those reports so the output appears in a single Google Sheet instead of multiple Google sheets? Right now it is creating a google sheet for each person that owns a file.

[Ross Scroggs]

Aaron,

See: https://github.com/taers232c/GAMADV-XTD3/wiki/Meta-Commands-and-File-Redirection#file-redirection

gam print users query "orgUnitPath='/Path/To/OU'" | gam redirect csv - multiprocess todrive csv - gam report drive filter "owner==~~primaryEmail~~" events edit,copy,download,print,view

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/d9d825b6-38f7-4480-aeb3-3adb101f9e78n%40googlegroups.com.

[Aaron Smith]

Thanks once again. That worked perfectly!