I am trying to implement a local check that monitors my backups on SQL Server. The script is in C:\check_mk\local and all it does is run a stored procedure in the local SQL instance that generates output such as:
P _sqlserver_backups_SVWCHI6PSQL1_DBA_full minOld=5480.05;10080;11520 Full backup for database DBA last occurred 3.80559 days (91.3342 hours) ago. P _sqlserver_backups_SVWCHI6PSQL1_master_full minOld=515.4;10080;11520 Full backup for database master last occurred 0.357917 days (8.59 hours) ago. P _sqlserver_backups_SVWCHI6PSQL1_model_full minOld=515.4;10080;11520 Full backup for database model last occurred 0.357917 days (8.59 hours) ago. P _sqlserver_backups_SVWCHI6PSQL1_msdb_full minOld=515.383;10080;11520 Full backup for database msdb last occurred 0.357905 days (8.58972 hours) ago. P _sqlserver_backups_SVWCHI6PSQL1_ReportServer_full minOld=5479.87;10080;11520 Full backup for database ReportServer last occurred 3.80546 days (91.3311 hours) ago. P _sqlserver_backups_SVWCHI6PSQL1_ReportServer_log minOld=5.4;=120;300 Log backup for database ReportServer last occurred 0.09 hours ago. P _sqlserver_backups_SVWCHI6PSQL1_SentryOne_full minOld=5476.65;10080;11520 Full backup for database SentryOne last occurred 3.80323 days (91.2775 hours) ago. P _sqlserver_backups_SVWCHI6PSQL1_SQLdmRepository_full minOld=5470.42;10080;11520 Full backup for database SQLdmRepository last occurred 3.7989 days (91.1736 hours) ago.
we have a similar script that outputs the same info for our postgres backups on Linux. The only difference is that it prints
<<<local>>> first - I had removed it from the windows version after reading some other stuff online but it doesn’t work with it, either. I also tried writing the output to a log in C:\check_mk\temp as was suggested somewhere online as well.
I’ve done many tabula rasa refreshes, restarted the local cmk agent, etc. but nothing seems to make the cmk server see this new check. I also see it when I run
.\check_mk_agent.exe test > test.out locally.
Any ideas what might be needed to get this check recognized ?