Metrics Library

This is helpful to someone who's trying to complete an audit of 2025 Windows Servers in an organization. This is a good Metric for a cross customer audit, and could be included in QBRs, recurring site reviews, or an onboarding report. Computers[?OperatingSystem != null && contains(OperatingSystem, 'Windows Server 2025')] | length(@)

This is helpful to someone who's trying to complete an audit of 2022 Windows Servers in an organization. This is a good Metric for a cross customer audit, and could be included in QBRs, recurring site reviews, or an onboarding report. Computers[?OperatingSystem != null && contains(OperatingSystem, 'Windows Server 2022')] | length(@)

This will return us the last logon for the AD user. Users[].join( , [join( , [ AD LOGIN: , to_string(UserName)]), join( , [ . Name of User: , to_string(Name)]),join( , [ : , to_string(LastLogonDate)])])

This is helpful to someone who's trying to obtain/maintain visibility into the count of enabled workstations at an organization. This is a good Metric for QBRs or recurring site reviews. Computers[?Type== Workstation && Enabled == true ] | length(@)

This is helpful to someone who's trying to obtain/maintain visibility into the count of enabled servers at an organization. This is a good Metric for QBRs or recurring site reviews. Computers[?Type== Server && Enabled == true ] | length(@)

This is helpful to someone who's trying to complete an audit of Windows 7 computers in an organization, as they are out of support. This is a good Metric for a cross customer audit, and could be included in QBRs, recurring site reviews, or an onboarding report. This Metric also could be used to create an Actionable Alert for computers that are out of support. Computers[? contains(to_string(OperatingSystem), Windows 7 )]. Name | length(@)

This is helpful to someone who's trying to obtain/maintain visibility into the count of OUs at an organization. This is a good Metric for QBRs or recurring site reviews. OrganizationalUnits | length(@)

This is helpful to someone who's trying to obtain/maintain visibility into a count of stale/inactive users at an organization. This is a good Metric for QBRs or recurring site reviews. Also, this Metric could be used to build a user audit with the intention of an end customer confirming that all looks as expected. Users[? DaysSinceLastLogin < 31 && UserStatus == Active && DaysSinceLastLogin != null && Email != null ] | length(@)

This is helpful to someone who's trying to obtain/maintain visibility into the count of groups at an organization. This is a good Metric for QBRs or recurring site reviews. Groups[] | length(@)

This is helpful to someone who's trying to obtain/maintain visibility into a list of active computers at an organization. This is a good Metric for QBRs or recurring site reviews. Computers[? DaysSinceLastLogin < 31 ].Name