Nagios Support Forum

Thanks for the info and look forward to that feature in a future release.

No I have deleted clients but I still see them in that directory.

Why is it not cleaning up these files when I delete the client/host? To comb through the files is going to be a pain to see which ones are still valid.

Is there a good way to clean up old servers that were in nagios and no longer are? I am looking in /usr/local/nagios/share/perfdata and there are several servers listed that are no longer valid. What is the best way to clean this up?

WOOT!!!!! That worked. I appreciate all your help on this. I ran through the wizard on more time and read the notes under the Port parameter.....dont configure the port if you are using a named instance. I will have to pay attention to the details in the future. Thanks again.

If this is not what you are asking for let me know. I did look at this and check this command in CCM to make sure it was using the same script I was using on the console and it was, see screenshot. check_xi_mssql_server!-H 'DB-SERVER-IP' -U 'SQL-USER' -P 'PASSWORD' -I 'MSSQLSERVER' -p 1433 --bufferh...

I ran GRANT VIEW SERVER STATE TO SQL-USERNAME and this allowed the script to run on the nagios console. Here are the results: /usr/local/nagios/libexec/check_mssql_server.py -H SERVER-IP -U SQL-USERNAME -P PASSWORD --bufferhitratio OK:Buffer Cache Hit Ratio is 100.0%|Buffer_Cache_Hit_Ratio=100.0%;;;...

I am still having problems getting the script to work. I did give the user I created select rights to the master and tempdb. But I am getting the same message: /usr/local/nagios/libexec/check_mssql_server.py -H SQL-SERVER -U USERNAME -P PASSWORD --bufferhitratio Result is: CRITICAL:Can access server...

Click on 'View the latest configuration snapshots' and click on the view output button. This will give you info as to what it errored out on. I just had one recently where I had to delete the service, save the config, then re-add the service. Not sure what happened as that client/service had been co...

I am not familiar with the select permission. I did give that user db_owner rights to the master and tempdb databases and I get the same error. Here is the command: /usr/local/nagios/libexec/check_mssql_server.py -H SQL-SERVER -U USERNAME -P PASSWORD --bufferhitratio Result is: CRITICAL:Can access s...