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 Andy Althouse
Created on Jun 13, 2023

RELATED METRIC

Datto RMM: Devices offline > X days with Y software installed

This metric will return the hostname and software selected that has been offline for X days AND has Y software installed.

Please adjust the X and Y values to meet your needs. X is offline in days, Y is a software name or partial name

Query

map_by_key(Devices[], DeviceSoftwareAudit[? contains(name, `Y`)].{uid:uid_r, name:name}[], `uid`)[? contains(name, `Y`) && time_since(lastSeen_r, `days`) > `X`].[hostname, name]
  • Attach files