On 3 Feb 2010, at 11:04, James Wallace wrote:
Hi All,
I've been using opsview for a few months now to monitor a number
of production windows servers, which is working very well. We would
like to start producing some availability reports for our senior
managers showing the all important availability statistics (xx%
service availability)
We monitor a lot of information about our servers, such as windows
event logs, free disk space etc which do not affect the availability
of the server, however they appear to affect the availability figure
stated in the report (I assume as Opsview doesn't know which is
important and which isn't)
Delving into the ODW database, I can see that we a
service_availability_hourly_summary table with a seconds_ok and
seconds_not_ok field against a service check, so I think the data I
need is getting into ODW in a filterable way.
In a long and drawn out way, how can I modify the report/report
template to say which service checks I would like to be "counted"
towards my availability ?
A mySQL view could be used to filter the data out, can I simply
change the report to look at
"my_service_availability_hourly_summary_view" instead of the real
table... or is there a better way ?
Opsview 3.5.2 has a new report which is based on keywords, so you can
get a weekly availability report from that. But we are not doing any
further development on that technology.
Alternatively, if you want to write your own SQL, you can look at the
example ODW queries:
http://docs.opsview.org/doku.php?id=opsview-community:odw#example_queries
Opsview Enterprise comes with the Reporting Module which is a more
flexible reporting mechanism and comes with some pre-canned reports: http://www.opsera.com/opsview.html
Ton
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
