Sort this Report by column

[Don Beck]

I would like to add to this command to get the report sorted by column C which is called displayText

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

[Ross Scroggs]

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

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On Apr 10, 2026, at 11:06 AM, Don Beck <dcb...@merig.com> wrote:

I would like to add to this command to get the report sorted by column C which is called displayText

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

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/5a2fda68-f377-4da5-afad-593c3be4b9bfn%40googlegroups.com.

[Don Beck]

Hi Ross

This works but it sorts by user and then by the displayText field.  I'd like to group all the apps together by displaytext only.  Is that possible.

Thanks

Don

[Ross Scroggs]

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

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/0404bbf4-ad8a-4559-b320-229fc2354e8en%40googlegroups.com.

[Don Beck]

That did the trick!!

Thanks Ross

Don

[Ross Scroggs]

This will sort by displayText, then user so the users are always in the same order

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

Ross

----

Ross Scroggs

Ross.S...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/6e407637-3751-486b-a960-d4b2b1487289n%40googlegroups.com.

[Don Beck]

Even better!!!

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/o_5rfRnAhsY/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/A18BD1BA-48D6-4A29-9465-9B64CAE8A1C7%40gmail.com.