Metrics Library

This is helpful to someone who's trying to obtain/maintain visibility into the licensing breakdown in an organization's ESET instance. This is a good Metric for QBRs or recurring site reviews. Also, this Metric could be used to build a licensing audit with the intention of an end customer confirming that all looks as expected. Licenses[].join( , [join( , [ , to_string(Name)]), join( , [ , State: , to_string(State_r)]), join( , [ , Quantity: , to_string(quantity)]), join( , [ , Days Since Last Update: , to_string(DaysSinceLastUpdate_r)])])

A simple metric returning the number of licenses. A useful metric when reconciling services in the Gradient MSP billing module. Licenses[].quantity | sum(@)

This query is used to check for license overusage and reports it if there's license overusage. Licenses[?to_number(usage) > to_number(quantity)].{Name: Name, Usage: usage, Quantity: quantity}