Returns the number of workstations that have been checked in the past 60 days. Further, simplify the query to return the number of workstations:Assets[?DeviceType == 'Desktop/Laptop'] | length(@)Change the DeviceType if you want to count the number of servers or remove the filter to show all managed assets. This is a useful metric when reconciling services in the Gradient MSP billing module.
Assets[?DeviceType == 'Desktop/Laptop'] && Agents[?LastCheckInTime <= '60'] | length(@)