My Organization has around 600 SQL tables. On each of these, we want to check a few metrics. Does anyone know of a better solution to grab these than having a nagios check per metric as we’d end up with around 3k checks
Write one script that has options to check whichever metrics you want. Then output a message listing every check selected which failed. That would cut down your checks to 600 (1 per table) and would only take about an hour to configure.
Also, if for some reason you really wanted to break it out into multiple checks on the nagios interface then you could use passive checking. That would allow you to send back a check per metric within the same script - just change the service name which each sent packet.