export list of oauth third party apps for a specific OU

[Mittal Chandra]

Hi Ross,

I’d like to export the full list of third‑party apps from Security > API Controls > App access control, filtered by a specific OU and Ownership = Third-party. However, when I use the UI option “Download list”, I’m unable to export the results to Google Sheets or CSV.

Is there a GAM command that can help with this?

I found the following command:
gam domains_ns "list of domains" print tokens aggregateusersby appname > user_apps.csv

My understanding is that this generates a report for the entire domain. How can I generate a similar report only for a specific OU, with the filters (OU and Third‑Party ownership)?

Thanks in advance

[Ross Scroggs]

Replace domains_ns "list of domains" with ou "/Path/to/OU"

If you want sub-ous as well use ou_and_children "/Path/to/OU"

I on't konw about: Ownership = Third-party

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/730c4336-725e-49ef-877d-446df014299en%40googlegroups.com.

[Mittal Chandra]

Hi Ross, 

I was able to run the command, but the output is empty for some reason. I’m currently using the latest GAM version, 7.33.

$ gam ou "<ou_name>" print tokens aggregateusersby appname

Getting all Users in the Organizational Unit for <ou_name>, may take some time on a large Organizational Unit...

Got <# of users> Users in the Organizational Unit for <ou_name>...

Got <# of users> User directly in the Organizational Unit for <ou_name>

Getting Access Tokens for <an_account> 

clientId,displayText,anonymous,nativeApp,users,scopes

$ 

Can I please verify with you if I'm missing anything?

[Ross Scroggs]

Send me  a private Meet/Zoom invitation and we'll investigte.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/87f91713-24e4-4472-9fa4-0a30da3ab769n%40googlegroups.com.

[Mittal Chandra]

Thanks Ross, I have sent an invite