I have number of processes running . They create logs some within text file and other in SQL server 2008R2 tables. I wish to create a framework by using which I can run SQL queries on SQL server through NAGIOS. NAGIOS will receive return results from SQL and these results to be added on a nice dashboard with Centroen Graphs.
Basically I want NAGIOS/Centroen so streamlined that I will write a new SQL and automatically graphs will be built for it.
I can send you info including SQL tables and data within them once I have your response with profile details.