Page 1 of 1

WMI Query Results Truncated-Solved

Posted: Wed Aug 27, 2014 8:14 am
by isadmin
The results our our WMI query are fine when run from command line but the results are truncated in the Nagios Overview screen
How can we see all the results returned...

Re: WMI Query Results Truncated

Posted: Wed Aug 27, 2014 9:19 am
by slansing
Can you send us an example of the command you are running and its output from the command line? It's possible that you are hitting the max character limit for non "long-output" and we may need to expand it in the database.

Re: WMI Query Results Truncated

Posted: Wed Aug 27, 2014 10:37 am
by isadmin
heres the command line output
OK - E:\ Total=9.40GB, Used=1.51GB (16.1%), Free=7.89GB (83.9%) OK - E:\Database\PFDB\ Total=39.87GB, Used=5.43GB (13.6%), Free=34.44GB (86.4%) OK - E:\Database\ArcDB1\ Total=385.00GB, Used=314.15GB (81.6%), Free=70.85GB (18.4%) OK - E:\Database\DB7\ Total=214.87GB, Used=151.37GB (70.4%), Free=63.50GB (29.6%) OK - E:\Database\DB2\ Total=409.87GB, Used=325.17GB (79.3%), Free=84.71GB (20.7%) WARNING - [Triggered by _Used%>85] - E:\Database\DB4NEW\ Total=409.87GB, Used=377.90GB (92.2%), Free=31.97GB (7.8%) OK - E:\Database\DB5\ Total=385.00GB, Used=261.83GB (68.0%), Free=123.17GB (32.0%) OK - E:\Database\DB9\ Total=390.00GB, Used=294.48GB (75.5%), Free=95.52GB (24.5%) |'E:\ Space'=1.51GB; 'E:\ Utilisation'=16.1%;85;95; 'E:\Database\PFDB\ Space'=5.43GB; 'E:\Database\PFDB\ Utilisation'=13.6%;85;95; 'E:\Database\ArcDB1\ Space'=314.15GB; 'E:\Database\ArcDB1\ Utilisation'=81.6%;85;95; 'E:\Database\DB7\ Space'=151.37GB; 'E:\Database\DB7\ Utilisation'=70.4%;85;95; 'E:\Database\DB2\ Space'=325.17GB; 'E:\Database\DB2\ Utilisation'=79.3%;85;95; 'E:\Database\DB4NEW\ Space'=377.90GB; 'E:\Database\DB4NEW\ Utilisation'=92.2%;85;95; 'E:\Database\DB5\ Space'=261.83GB; 'E:\Database\DB5\ Utilisation'=68.0%;85;95; 'E:\Database\DB9\ Space'=294.48GB; 'E:\Database\DB9\ Utilisation'=75.5%;85;95;

heres is the out put from the web interface
OK - E:\ Total=9.40GB, Used=1.51GB (16.1%), Free=7.89GB (83.9%) OK - E:\Database\PFDB\ Total=39.87GB, Used=5.43GB (13.6%), Free=34.44GB (86.4%) OK - E:\Database\ArcDB1\ Total=385.00GB, Used=314.15GB (81.6%), Free=70.85GB (18.4%) OK - E:\Databa

Re: WMI Query Results Truncated

Posted: Wed Aug 27, 2014 11:11 am
by slansing
We will need to increase the max size limit for character input on the table responsible for displaying plugin output in XI, please run the following from your XI server's SSH session, then for good measure we will restart mysql and then check your output:

Code: Select all

echo 'ALTER TABLE nagios.nagios_servicestatus MODIFY output VARCHAR(2048)' | mysql -pnagiosxi

Code: Select all

service mysqld restart

Re: WMI Query Results Truncated

Posted: Wed Aug 27, 2014 2:12 pm
by isadmin
Thanks that fixed it...