Querying a MSSQL 2016 counter

[ath_vc]

Hi I am trying to query a MSSQL 2016 counter

Get-Counter -ListSet 'MSSQL$MSSQLSERVER:SQL Statistics' | Select-Object -ExpandProperty Counter
\MSSQL$MSSQLSERVER:SQL Statistics\Batch Requests/sec
\MSSQL$MSSQLSERVER:SQL Statistics\Forced Parameterizations/sec
\MSSQL$MSSQLSERVER:SQL Statistics\Auto-Param Attempts/sec
\MSSQL$MSSQLSERVER:SQL Statistics\Failed Auto-Params/sec
\MSSQL$MSSQLSERVER:SQL Statistics\Safe Auto-Params/sec
\MSSQL$MSSQLSERVER:SQL Statistics\Unsafe Auto-Params/sec
\MSSQL$MSSQLSERVER:SQL Statistics\SQL Compilations/sec
\MSSQL$MSSQLSERVER:SQL Statistics\SQL Re-Compilations/sec
\MSSQL$MSSQLSERVER:SQL Statistics\SQL Attention rate
\MSSQL$MSSQLSERVER:SQL Statistics\Guided plan executions/sec
\MSSQL$MSSQLSERVER:SQL Statistics\Misguided plan executions/sec

zabbix_get -s mssqlserver.example.com -k perf_counter["\MSSQL$MSSQLSERVER:SQL Statistics\Batch Requests/sec"]
ZBX_NOTSUPPORTED: Cannot obtain performance information from collector

Is the syntax I am using Wrong ?

Best Regards,

A

[ath_vc]

I figured it out, Please close the issue