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

Microsoft 365

Showing 114 of 880

Microsoft 365: System Info Data Set

Microsoft 365 System Info Metric designed for Power BI consumption.
Paul Taplett almost 2 years ago in Microsoft 365 0

Microsoft 365 Privileged Users Not Logged in Last 30 Days

Microsoft 365 Privileged Users Not Logged in Last 30 Days
Guest almost 2 years ago in Microsoft 365 0

Microsoft 365: Active mailNicknames

This metric outputs the active mail Nicknames from Microsoft 365
Lamont Largie about 2 years ago in Microsoft 365 0

MS365: License Summary (Power BI)

This metric provides license summary details in a JSON output format and is designed to be pulled into Power BI for reporting. Double-click on the query below in order to select all before copying.
Paul Taplett about 2 years ago in Microsoft 365 0

Microsoft 365 | Users Assigned Sku Product Number

Using new roarpath function, get skupartnumber not normally attatched to the user object
Stephen Rankich about 2 years ago in Microsoft 365 0

Microsoft 365 | User Creation By Year

Using new roarpath function, get the creation year of users in M365
Stephen Rankich about 2 years ago in Microsoft 365 0

Microsoft 365 | Control Score Count of Admin Users With MFAV2 Turned On

Using new roarpath function to get count of admin users with MFAV2 turned on
Stephen Rankich about 2 years ago in Microsoft 365 0

Microsoft 365: Percent of Storage Used over 90

Checks for Storage_Used existing, then any users with over 90% storage used, then prints the name and amount of storage used
Leland Shane about 2 years ago in Microsoft 365 0

Microsoft 365: Return Additional Data via M365 Inspector (Checks the 365 concealed user, group, and site names in all reports Setting)

In order to return more data via the Microsoft 365 inspector, you need to disable the setting "Display concealed user, group, and site names in all reports" in the 365 tenancy (refer to Liongard documentation for more information). This metric wil...
Sam Walker about 2 years ago in Microsoft 365 2

Microsoft 365: Licenses set to expire within 30 days with no renewal list

You can use this metric to see which licenses are going to expire within 30 days that are not set to renew. It will also give you a count of how many of those licenses are in the warning state. Use the metric below to get a count of how many licen...
Stephen Rankich about 2 years ago in Microsoft 365 0