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.

Add a new Metric entry Subscribe
Categories Datto RMM
Created by Erik Zwep
Created on Dec 3, 2024

RELATED METRIC

Datto RMM : Device Status Offline > 90 Days (With Status Check)

Explanation:

`time_since(lastSeen_r, 'days') > 90`: Selects devices that have not been seen for more than 90 days.

`online == 'false'`: Filters devices that are currently offline.

`.hostname`: Returns only the hostnames.

Important:

This query prevents devices with an old "Last Seen" date, but that are now online, from being included. This way, you focus only on devices that have both not been seen for a long time and are actually offline.


Query

Devices[?time_since(lastSeen_r, `days`) > `90` && online == `false`].hostname
  • Attach files