LLD - Calculated Item - Windows PerfMon

[benhanson]

I'm trying to create a calculated item as an item prototype in a low level discovery. The source item is a PerfMon counter which is working fine. When I try to reference that item prototype, I get:

Invalid parameter "/1/params": incorrect expression starting from "last("perf_counter["\SQLServer : Databases({#DBNAME})\Log File(s) Used Size (KB)"]","0")"

Given the format of perfmon items in Zabbix, I'm wondering if something Leeds to be escaped or quoted in the source item. Also tried without the second parameter, same result.

Has anyone successfully done a calculated item prototype with Perfmon counters?

[benhanson]

I was mis-reading documentation, and looking at old samples. Didn't have the /host/ prefix, which in this case was just // because it was the discovered host. The intent of the formula is to show SQL log file whitespace:

last(//perf_counter["\SQLServer:Databases({#DBNAME})\Log File(s) Size (KB)"])-last(//perf_counter["\SQLServer:Databases({#DBNAME})\Log File(s) Used Size (KB)"])

[benhanson]

I was mis-reading documentation, and looking at old samples. Didn't have the /host/ prefix, which in this case was just // because it was the discovered host. The intent of the formula is to show SQL log file whitespace:

last(//perf_counter["\SQLServer:Databases({#DBNAME})\Log File(s) Size (KB)"])-last(//perf_counter["\SQLServer:Databases({#DBNAME})\Log File(s) Used Size (KB)"])