Groups Clean up and User cleanup

[Raymond Rogers]

I am trying to find old groups who may have members but  have not had an email sent in a year or more so I can delete them. Secondly I would like to find users who have not logged in in 90 days and account is still active. Thanks in advance.

[Ross Scroggs]

Raymond,

Old groups: You are the latest person to ask about groups with no email; unfortunately, there is no good solution.

Old users, Advanced GAM:

gam config csv_output_row_filter "lastLoginTime:date<-90d" print users query "isSuspended=False" fields primaryemail,name,lastlogintime

Old users, Standard GAM

export GAM_CSV_ROW_FILTER="lastLoginTime:date<-90d"

gam print users query "isSuspended=False" fields primaryemail,name,lastlogintime,suspended

Ross

On Thu, Mar 30, 2023 at 10:08 AM Raymond Rogers <raymond...@gilbertschools.net> wrote:

I am trying to find old groups who may have members but  have not had an email sent in a year or more so I can delete them. Secondly I would like to find users who have not logged in in 90 days and account is still active. Thanks in advance.

Under Arizona Law, email to and from public entities may be public records subject to release upon request. This message (including any attachments) contains information intended for a specific individual and purpose. If you are not the intended recipient, please notify the sender immediately by either reply email or by telephone and delete this message from your system.

--
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/a62c1220-1aeb-4086-8ab9-3ce071e7daf4n%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com