Page 1 of 1

Stats for 2013

Posted: Wed Dec 18, 2013 8:02 am
by WillemDH
Hello,

I need to find out what's the total amount of warnings and errors generated in 2013, but I can't find this in the report tab. How could i best obtain this data? If possible, I would want this data seperately for active check services and passive check services (but I would already be happy with the total), as we had some passive services receiving 20000+ events, I would like to see them excluded..

Thanks for any guidance in how to do this..

I already tried to use the state history report, configure it for "this year" and tried to export is to csv, but after waiting some time, I just get a blank page and no download in Firefox and in IE10, I get a http error 500. there are more then 100000 records and 4000 pages, so I guess there is a litle too much informaton...

Willem

Re: Stats for 2013

Posted: Wed Dec 18, 2013 9:55 am
by WillemDH
In the meantime I was able to export to csv the state history per three months. Imported this in Excel and excluded the passive services. So I guess this call can be close. For those who would be interested:

Servers in SCOM Januari 2013 => 185
Servers in Nagios Januari 2013 => 0
Servers in SCOM December 2013 => 113
Servers in Nagios December 2013 => 153
SCOM Infra (ITIL tool) Incidents => 530
Nagios Infra (ITIL tool) Incidents => 330
Warnings SCOM:29112 Nagios:5616
Critcals SCOM:59802 Nagios:30724
Windows Events to Nagios => 93859 (mostly cause by problems with our backup, which generated 40000+ events in one week)

Grtz

Re: Stats for 2013

Posted: Wed Dec 18, 2013 11:22 am
by abrist
Just a note: The generation of the yearly csv may have timed out. You may need to increase some limits in php.ini. What is the output of:

Code: Select all

grep "memory_limit\|max_execution\|max_input" /etc/php.ini 

Re: Stats for 2013

Posted: Mon Dec 23, 2013 3:20 am
by WillemDH
Result:

; max_input_time
max_execution_time = 30
max_input_time = 60
;max_input_nesting_level = 64
memory_limit = 128M

Which parameter should I expand?

Grtz

Re: Stats for 2013

Posted: Mon Dec 23, 2013 9:26 am
by scottwilkerson
To process this much info, you will likely need to bump up the max execution time and restart httpd

change

Code: Select all

max_execution_time = 30
to

Code: Select all

max_execution_time = 90
Then

Code: Select all

service httpd restart

Re: Stats for 2013

Posted: Tue Jul 08, 2014 4:48 am
by WillemDH
This thread can be closed. Setting max execution time higher helped.