IT Glue: List IT Glue Users That Have Not Signed In for More Than 90 Days (Excludes Lite)
submitted
T
Todd Smith
When you have a lot of IT Glue accounts it can be hard to know which are no longer needed, since you are not able to easily filter by Last Login Date. This metric can help review IT Glue users and excludes the My Glue accounts and Lite accounts.
Users[?LastSignInAt && time_since(LastSignInAt,
days
) > 90
&& MyGlueAccountId == null
&& RoleName != 'Lite'].join(' | Days Since Last Log In: ', [Email, to_string(time_since(LastSignInAt, days
))])