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 120 of 911

Office 365: Visio Online (Plan 2) Assigned License Count

Visio Online (Plan 2) Assigned License Count
Matthew Waddell over 1 year ago in Microsoft 365 0

Microsoft 365: Helpdesk Administrator Role User List

Provides a list of users who belong to the Helpdesk Administrator role. Setting up a report against this metric will allow you to audit the current user list across all of your customers. Additionally, creating an Alert to use the "changed" condit...
Paul Taplett over 1 year ago in Microsoft 365 0

Microsoft 365: Conditional Access Administrator Role User List

Provides a list of users who belong to the Conditional Access Administrator role. Setting up a report against this metric will allow you to audit the current user list across all of your customers. Additionally, creating an Alert to use the "chang...
Paul Taplett over 1 year ago in Microsoft 365 0

Microsoft 365: Security Administrator Role User List

Provides a list of users who belong to the Security Administrator role. Setting up a report against this metric will allow you to audit the current user list across all of your customers. Additionally, creating an Alert to use the "changed" condit...
Paul Taplett over 1 year ago in Microsoft 365 0

Microsoft 365: Security Score as Percentage

This metric returns a tenant's Microsoft 365 security score as a percentage of points available. It is an integer, but if you want it to a couple of decimal places, simply remove the ceil function.
Guest about 2 years ago in Microsoft 365 2

Microsoft 365: Consumed License Count by Product Name

Returns the count of consumed licenses by product. A useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP about 2 years ago in Microsoft 365 0

Microsoft 365: Unused License Count by Product Name

Returns the count of unused licenses by product. A useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP about 2 years ago in Microsoft 365 0

Microsoft 365: Current Secure Score

Reports the current Microsoft 365 Secure Score
Paul Taplett about 2 years ago in Microsoft 365 0

Microsoft 365: Microsoft Secure Scores List

Checks which Secure Scores are not 100% completed and displays a list of each with the current status of each. Useful for reporting. Example of what information is displayed: How many Admins have MFA enabled, The number of Global Admins, the numbe...
Zyad Khan over 2 years ago in Microsoft 365 0

Microsoft 365: Licensing Data Set

Microsoft 365 Licensing Metric designed for Power BI consumption.
Paul Taplett over 2 years ago in Microsoft 365 0