Skip to Main Content
Liongard Library

Welcome to Liongard Library, where Lions share! This is a community-led space where Liongard users can come to teach and learn from one another.
Share custom Metrics, get inspired and see what’s trending in the Pride.

Pride Etiquette:
➕ Have great custom Metrics? Add them as entries!
🌟 Want to use a Metric? Copy the query and
follow this doc.
👍 Tried a Metric from the Library? Like it!
📣 Have a question or feedback on a Metric? Add a comment!
🔎 Not sure where to start? Learn about Metrics and how to write them.
💬 Need help writing a metric or want to help support others? Join the conversation in our Liongard Lounge #metrics slack channel.


🥴 See something off? Open a support chat to let us know.

Categories IT Glue
Created by Todd Smith
Created on Jun 27, 2023

IT Glue: List IT Glue Users That Have Not Signed In for More Than 90 Days (Excludes Lite)

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.

Query

Users[?LastSignInAt && time_since(LastSignInAt, `days`) > `90` && MyGlueAccountId == `null` && RoleName != 'Lite'].join(' | Days Since Last Log In: ', [Email, to_string(time_since(LastSignInAt, `days`))])


  • Attach files