WMI Query Results Truncated-Solved

[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...

[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.

[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

[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

[isadmin]

Thanks that fixed it...