how is the command for to print userse with lastLoginTime never?

856 views
Skip to first unread message

Salvatore Caligiore

unread,
Oct 18, 2021, 7:36:01 AM10/18/21
to GAM for Google Workspace
hi maybe is simple and i don't know, but  how can i get list of users that never login in gsuite?

i tried 
 gam print users query "lastLoginTime = 'Never'"

but i get invalid

bye

Chris River

unread,
Oct 18, 2021, 3:44:19 PM10/18/21
to GAM for Google Workspace
The API doesn't support querying against lastLoginTime. The only queryable properties are listed here.

However, if you're using GAMADV-XTD3, you can replicate this via csv output filtering:
gam config csv_output_row_filter "lastLoginTime:time=Never" print users fields lastLoginTime

Ross Scroggs

unread,
Oct 18, 2021, 3:47:04 PM10/18/21
to google-ap...@googlegroups.com
In Standard Gam you can do:

export GAM_CSV_ROW_FILTER="lastLoginTime:regex:Never"  (Use set in Windows)

gam print users fields lastlogintime


Ross


--
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/f4243fac-17e7-49c8-ada5-2aa2903f1ed6n%40googlegroups.com.


--

Salvatore Caligiore

unread,
Oct 19, 2021, 12:52:41 PM10/19/21
to GAM for Google Workspace
 in  GAMADV-XTD3  not work? there is a way?

Ross Scroggs

unread,
Oct 19, 2021, 1:03:44 PM10/19/21
to google-ap...@googlegroups.com
Salvatore,

Here is Chris' solution for Advanced GAM.
gam config csv_output_row_filter "lastLoginTime:time=Never" print users fields lastLoginTime

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/9db99773-9d47-427a-b592-850fcdaba474n%40googlegroups.com.


--

Salvatore Caligiore

unread,
Oct 19, 2021, 1:03:51 PM10/19/21
to GAM for Google Workspace
found!!!  thank for info that show the road

 gam config csv_output_row_filter "'lastLoginTime:regex:Never'" print users lastlogintime

Bye bye


EDWARD ARAGON

unread,
May 12, 2023, 1:47:21 PM5/12/23
to GAM for Google Workspace
Good morning,
            
        How is it expressed if you want to see users that are both suspended and who hasn't logged in for a year?  

Thank you,

Share feedback with us on Let's Talk!

Ross Scroggs

unread,
May 15, 2023, 11:43:53 AM5/15/23
to google-ap...@googlegroups.com
Advanced GAM

gam config csv_output_row_filter "'lastLoginTime:date<-1y'" print users query "isSuspended=true" fields lastlogintime,suspended


Ross


To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/fa0f4c14-be0d-4ea6-852e-d2e98276ec15n%40googlegroups.com.


--
Reply all
Reply to author
Forward
0 new messages