Metrics Library

Windows Workstation Hostname metric for Visual Insights NetConfig[].DNSHostName

Workstation Drives and Volumes metric to use in Visual Insights, join this data set in Visual Insight with Windows Workstation: Host Name and then add to a Table Widget Drives[?TotalSize != null && SpaceUsed != null].{ Drive: DriveLetter, TotalGB: TotalSize, UsedGB: SpaceUsed, FreeGB: SpaceRemaining, UsedPercent: UsedSpacePct, Bitlocker: BitlockerStatus }

Windows Defend Status Info metric to use in Visual Insights Dashboard [{ ComputerName: SystemInfo.CSName, AMEngineVersion: DefenderInfo.Status.AMEngineVersion, AMProductVersion: DefenderInfo.Status.AMProductVersion, AMServiceEnabled: DefenderInfo.Status.AMServiceEnabled, AntispywareEnabled: DefenderInfo.Status.AntispywareEnabled, AntispywareSignatureLastUpdated: DefenderInfo.Status.AntispywareSignatureLastUpdated, AntispywareSignatureVersion: DefenderInfo.Status.AntispywareSignatureVersion, AntivirusEnabled: DefenderInfo.Status.AntivirusEnabled, AntivirusSignatureLastUpdated: DefenderInfo.Status.AntivirusSignatureLastUpdated, BehaviorMonitorEnabled: DefenderInfo.Status.BehaviorMonitorEnabled, DefenderSignaturesOutOfDate: DefenderInfo.Status.DefenderSignaturesOutOfDate, FullScanOverdue: DefenderInfo.Status.FullScanOverdue, IoavProtectionEnabled: DefenderInfo.Status.IoavProtectionEnabled, IsTamperProtected: DefenderInfo.Status.IsTamperProtected, RealTimeProtectionEnabled: DefenderInfo.Status.RealTimeProtectionEnabled, TamperProtectionSource: DefenderInfo.Status.TamperProtectionSource, AntiVirusStatus: DefenderInfo.Status.ProductStatus }]

This metric will assess whether your workstations are compatible with the upgrade to Windows 11. contains(OS.OperatingSystemName, Microsoft Windows 10 ) && OS.Windows11Compatible == false && No || Yes

Rounds down the RAM to closest integer floor(sum(Ram[].Capacity))

Designed for Windows Workstation Power BI Template OS

Designed for Windows Workstation Power BI Template Drives

Designed for Windows Workstation Power BI Template {Hostname: NetConfig[0].DNSHostName,AvailableUpdate: AvailableUpdates[]}

Designed for Windows Workstation Power BI Template {Hostname: NetConfig[0].DNSHostName,InstalledUpdate: InstalledUpdates[]}

Designed for Windows Workstation Power BI Template AVs[?Name=='Windows Defender'].{Status: State.status, UpdateStatus: State.updateStatus, "Defender": ~.DefenderInfo.Status}