How to sort a report

[Don Beck]

I run this command that prints to a google sheet with it sorting by user.  I'd like to sort the sheet by clientid instead.  What should I add to accomplish that

gam config csv_output_header_filter "^user$,clientId,displayText" redirect csv UserApps.csv todrive tdfileid <id> tdtitle "3rd Party Apps OAuth Tokens" tdupdatesheet tdsheet id:<id> tdsheettitle "Report Date" tdsheettimestamp true all users print tokens 

I tried using aggregateusersby appname but that eliminates the user column

Thanks

Don

[Ross Scroggs]

See: https://github.com/GAM-team/GAM/wiki/Meta-Commands-and-File-Redirection#file-redirection

gam config csv_output_header_filter "^user$,clientId,displayText" redirect csv UserApps.csv sortheaders clientId todrive tdfileid <id> tdtitle "3rd Party Apps OAuth Tokens" tdupdatesheet tdsheet id:<id> tdsheettitle "Report Date" tdsheettimestamp true all users print tokens 

Ross

----

Ross Scroggs

Ross.S...@gmail.com

PLEASE NOTE
The information in this E-Mail message is legally privileged and confidential information intended only for the use of the individual(s) named above.  If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message.  If you have received this E-mail in error, please notify the sender. Thank you!

--
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/a400e292-3791-4382-b0c7-2dd6774b9720n%40googlegroups.com.

[Don Beck]

Thanks Ross!!

 

Thanks,

Don

 

Don Beck

Director of Systems & Technology

Meriwether Godsey

(434) 258-1775 (cell)

 

 P Please consider the environment before printing this e-mail

You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/UOSovEMB1ps/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-man...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/3DF1787B-174F-4390-AD7D-20A2B34391EC%40gmail.com.