Metrics Library

This is helpful to someone who's trying to obtain/maintain visibility into a server. This is a good Metric for QBRs, recurring site reviews, and an onboarding report. SystemInfo.[join( , [ Name: , to_string(Name)]), join( , [ Type: , to_string(MachineType)]), join( , [ OS: , to_string(Caption)]), join( , [ Make: , to_string(Manufacturer)]), join( , [ Model: , to_string(MachineModel)]), join( , [ Serial Number: , to_string(SerialNumber)]), join( , [ Physical Memory: , to_string(TotalVisibleMemorySize)]), join( , [ Virtual Memory: , to_string(TotalVirtualMemorySize)]), join( , [ Processors: , to_string(Processor)]), join( , [ Drive Breakdown: , to_string(StrHardDrives)])]

Windows Server metric for Drives and Volumes to use in Visual Insight. Join this metric with Windows Server: Hostname(VI) to add the host name, then add updated data set to table widget in Visual Insights Drives[?TotalSize != null && SpaceUsed != null ].{ Drive: DriveName, TotalGB: TotalSize, UsedGB: SpaceUsed, FreeGB: SpaceRemaining, UsedPercent: UsedSpacePct, Bitlocker: BitlockerStatus, FileSystem: DriveFormat }

Server Hostname metric for Visual Insights NetConfig[].DNSHostName

This is helpful to someone who's trying to obtain/maintain visibility into the amount of free virtual memory on a Windows server. This is a good Metric for QBRs, recurring site reviews, and an onboarding report. Also, this Metric could be used to build an audit in order to ensure that all servers have enough memory available for an end customers needs. Also, this Metric can be used to build a report to inform on if there is a need to buy additional servers/infrastructure in the near future. This Metric can also be used to create a pointed Actionable Alert that alerts on if Servers' free memory surpasses an undesired threshold. SystemInfo.FreeVirtualMemory

This is helpful to someone who's trying to obtain/maintain visibility into the amount of free physical memory on a Windows server. This is a good Metric for QBRs, recurring site reviews, and an onboarding report. Also, this Metric could be used to build an audit in order to ensure that all servers have enough memory available for an end customers needs. Also, this Metric can be used to build a report to inform on if there is a need to buy additional servers/infrastructure in the near future. This Metric can also be used to create a pointed Actionable Alert that alerts on if Servers' free memory surpasses an undesired threshold. SystemInfo.FreePhysicalMemory

This is helpful to someone who's trying to obtain/maintain visibility into the count of failed patches on a Windows server. This is a good Metric for QBRs, recurring site reviews, and an onboarding report. Also, this Metric could be used to build a patching audit that allows users to see the patching state across their managed servers. This Metric can also be used to create a pointed Actionable Alert that Alerts on if the failed patches count exceeds specified thresholds. Patches[? Result == Failed ].Title

Useful for creating a metric for a specific software application version. Could be paired with an alert or report. Software[?Name=='APP_NAME_HERE'].Version

per https://docs.connectwise.com/ConnectWise_Unified_Product/Supportability_and_Vulnerability_Statements_for_ConnectWise_Unified_Product/How_to_Disable_the_ConnectWise_Global_Search disableding this task to limit risks for Log4J ScheduledTasks[?Name == ConnectWiseIndexer_sync && Status == Enabled ].join( : , [Name,Status]) | sort(@)

per https://docs.connectwise.com/ConnectWise_Unified_Product/Supportability_and_Vulnerability_Statements_for_ConnectWise_Unified_Product/How_to_Disable_the_ConnectWise_Global_Search it is recommended to disable this task ScheduledTasks[?Name == ConnectWiseIndexer_meta-sync && Status == Enabled ].join( : , [Name,Status]) | sort(@)

Show Java 8 Version, current version should be 8.0.3310.11 or newer. Software[?contains(Name, Java 8 )].join( : , [Name,Version]) | sort(@)