Hello,
I noted an odd problem with getting the data from MSSQL. In general, MSSQL by agent2 was configured, it works under the same script-created user, so the privileges are exactly the same at all hosts. I noted that for some of 10 sample hosts, some values are not pulled or not available from the GUI.
e.g. below MSSQL DB list is not present in the GUI, however once increased agent's debug level directly at host I noted that this counter actually provides an output:
So, I wonder at which level something is wrong, since in some cases all the data is available and in some not. Even for the servers using the same MSSQL version. Any ideas what to check?
I noted an odd problem with getting the data from MSSQL. In general, MSSQL by agent2 was configured, it works under the same script-created user, so the privileges are exactly the same at all hosts. I noted that for some of 10 sample hosts, some values are not pulled or not available from the GUI.
e.g. below MSSQL DB list is not present in the GUI, however once increased agent's debug level directly at host I noted that this counter actually provides an output:
Code:
2024/10/08 15:50:00.961715 [1] processing update request (1 requests)
2024/10/08 15:50:00.961715 [1] adding new request for key: 'mssql.perfcounter.get["sqlserver://localhost:1433","user","password"]'
2024/10/08 15:50:00.962279 [1] created direct exporter task for plugin 'MSSQL' itemid:0 key 'mssql.perfcounter.get["sqlserver://localhost:1433","user","password"]'
2024/10/08 15:50:00.962279 executing direct exporter task for key 'mssql.perfcounter.get["sqlserver://localhost:1433","user","password"]'
2024/10/08 15:50:01.014411 executed direct exporter task for key 'mssql.perfcounter.get[[sqlserver://localhost:1433 user password]]'
2024/10/08 15:50:01.019452 sending passive check response: '{"version":"7.0.4","variant":2,"data":[{"value":"[{\"cntr_value\":4471081,\"counter_name\":\"Uptime\",\"instance_name\":\"\",\"object_name\":\"MSSQL$MSSQLSERVER\"},{\"cntr_value\":0,\"counter_name\":\"Version\",\"instance_name\":\"Microsoft SQL Server 2016 (SP3-GDR) (KB5029186) - 13.0.6435.1 (X64) \\n\\tJul 30 2023 19:53:42 \\n\\tCopyright (c) Microsoft Corporation\\n\\tStandard Edition (64-bit) on Windows Server 2019 Standard 10.0 \\u003cX64\\u003e (Build 17763: ) (Hypervisor)\\n\",\"object_name\":\"MSSQL$MSSQLSERVER\"},{\"cntr_value\":0,\"counter_name\":\"State\",\"instance_name\":\"[B]Database_Prod[/B]",\"object_name\":\"MSSQL$MSSQLSERVER:Databases\"},{\"cntr_value\":0,\"counter_name\":\"State\",\"instance_name\":\"[B]Database_19012023[/B]\",\"object_name\":\"MSSQL$MSSQLSERVER:Databases\"},{\"cntr_value\":0,\"counter_name\":\"State\",
Comment