Exclude Time from CSV Output

[Bassel Massamiri]

Hi,

Is there anyway to exclude time from CSV or todrive output 

2024-07-24T17:00:45Z , I need to remove T17:00:45Z

Thanks,

[Ross Scroggs]

Command line: https://github.com/GAM-team/GAM/wiki/Todrive#command-line-options

tdtimestamp off

gam.cfg: https://github.com/GAM-team/GAM/wiki/Todrive#config-file-options

todrive_timestamp off

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/633f9ace-7418-43c8-9a9f-d1751998de74n%40googlegroups.com.

[Bassel Massamiri]

Hi Ross,

The tdtimestamp off didn't work

Here is my Command:

gam config num_threads 20 never_time "1970-01-01T00:00:00Z" csv_output_row_drop_filter "'lastLoginTime:date>=-90d','creationTime:date>=-60d','Groups:regex:<Group email>'" ous "'Ou1','Ou2'" print users fields creationTime,lastlogintime,orgUnitPath,relations groups todrive tdtimestamp off

The output still date and time : 

Thanks

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/2C112E26-FC84-4317-B803-67E7DC16248A%40gmail.com.

[Ross Scroggs]

I thought you wanted to remove the timestamp from the file name.

Sen: https://github.com/GAM-team/GAM/wiki/gam.cfg

Scroll down to output_timeformat

gam config num_threads 20 output_timeformat "%Y-%m-%d" never_time "1970-01-01T00:00:00Z" csv_output_row_drop_filter "'lastLoginTime:date>=-90d','creationTime:date>=-60d','Groups:regex:<Group email>'" ous "'Ou1','Ou2'" print users fields creationTime,lastlogintime,orgUnitPath,relations groups todrive 

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On Sep 23, 2025, at 8:28 AM, Bassel Massamiri <bassel.m...@cogeco.com> wrote:

Hi Ross,

The tdtimestamp off didn't work

Here is my Command:

gam config num_threads 20 never_time "1970-01-01T00:00:00Z" csv_output_row_drop_filter "'lastLoginTime:date>=-90d','creationTime:date>=-60d','Groups:regex:<Group email>'" ous "'Ou1','Ou2'" print users fields creationTime,lastlogintime,orgUnitPath,relations groups todrive tdtimestamp off

The output still date and time : 

<image.png>

Thanks

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/CAPJrYBJg5m%3DsLNQBbrpYoCCrhsd9qfQOqygLRuiTi-W2mZrcQw%40mail.gmail.com.

[Bassel Massamiri]

Thanks Ross , This works perfectly

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/F05D4EFD-F094-4461-B64C-8D61528DEFF0%40gmail.com.