First it is important what version of CMK agent do you installed (1.5 or 1.6)?
For this task the plugin “mssql.vbs” exists. It is possible that you must configure a small ini file for this plugin if your database don’t allow the connection as local system.
The plugin “mk_mysql.vbs” must be used. There also a small configuration file for the database credentials is needed.
Inside the normal CMK agent there as already a very bare monitoring for the IIS (wmi_webservices).
But the plugin @kdeutsch mentioned goes more in depth.
Thanks @andreas-doehler , this one helped me a lot. I’m now able to get the MSSQL instance status (installed locally) by using mssql.vbs plugin copied over to plugins/ folder. This was not asked for any ini file.
I have also placed mk_mysql.vbs into the plugins folder, but this is not working correctly. I guess this require an ini file with the mysql user credentials to work same as on Linux. But not sure where to set this ini file, and what could be the content. Can you outline the correct step for this?
I see the wmi_webservices plugins included by default, but all those checks are still in pending status. I’m able to load the websites from the server, but the CMK still has it as PEND status.
The Status column has the error “WAITING - Counter based check, cannot be done offline”. As I said, the web server is online and I’m able to load from outside of the server just fine. Not sure why this check is being stated as this.
For “Mailenable/Smartermail/IceWarp queue”, these are the commonly installed MTA (Mail Servers) on Windows system. If there is any chance to check the queue status, would be helpful.
The ini files needs to be inside the /config folder. This folder is for 1.6 C:\ProgramData\checkmk\agent\config
Naming - from the plugin comments
' Use either an instance specific config file named mysql_<instance-id>.ini
' or the default mysql.ini file.
The file is then used as a –defaults-extra-file for the mysql call.
That means the content of the config file must be the same format as inside a –defaults-extra-file.
This message means your are inside the WATO and not in your normal status view. Inside WATO checks with counters cannot be done as you need two or more intervals to get an result.
Activate your changes and look at the service status view of your host.