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 Matt Scutt
Created on Aug 22, 2022

IT Glue: List Users Who Haven't Signed In For More Than 90 Days

Returns a list of users who haven't signed in for more than 90 days.

To only return Lite users (Or another specific type of user, add the following after the first "[": RoleName == `Lite` &&


Change the 90 to however many days you want to monitor

Query

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

  • Attach files