Query for Service Downtime

Hi,

  I was just wondering if I can generate a report for system

downtime (i.e. the service names and its corresponding downtime) through
query builder. Plan was to give the customer name as input and generate
the graph as well as chart where the instance name, service name and the
downtime is shown. Any help in this regard is greatly appreciated.

Regards,

Uday

DISCLAIMER:“The information contained in this message and the attachments (if any) may be privileged and confidential and protected from disclosure. You are hereby notified that any unauthorized use, dissemination, distribution or copying of this communication, review, retransmission, or taking of any action based upon this information, by persons or entities other than the intended recipient, is strictly prohibited. If you are not the intended recipient or an employee or agent responsible for delivering this message, and have received this communication in error, please notify us immediately by replying to the message and kindly delete the original message, attachments, if any, and all its copies from your computer system. Thank you for your cooperation.”

  I was just wondering if I can generate a report for system

downtime (i.e. the service names and its corresponding downtime) through
query builder. Plan was to give the customer name as input and generate
the graph as well as chart where the instance name, service name and the
downtime is shown. Any help in this regard is greatly appreciated.

xymon (formerly hobbit monitor) makes great availability reports. Not sure
how this is a RT question… ?

– ============================
Tom Lahti
BIT Statement LLC

(425)251-0833 x 117
http://www.bitstatement.net/
– ============================

Thanks Tom, but can I integrate the same with my existing RT (3.8.2)
environment and how can I do that? Where can I get the official
documentation for the Xymon.

Regards,
UdayFrom: Tom Lahti [mailto:toml@bitstatement.net]
Sent: Tuesday, April 28, 2009 10:24 PM
To: Uday Dey
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Query for Service Downtime

  I was just wondering if I can generate a report for system

downtime (i.e. the service names and its corresponding downtime)
through
query builder. Plan was to give the customer name as input and
generate
the graph as well as chart where the instance name, service name and
the
downtime is shown. Any help in this regard is greatly appreciated.

xymon (formerly hobbit monitor) makes great availability reports. Not
sure
how this is a RT question… ?

– ============================
Tom Lahti
BIT Statement LLC

(425)251-0833 x 117
http://www.bitstatement.net/
– ============================

DISCLAIMER:“The information contained in this message and the attachments (if any) may be privileged and confidential and protected from disclosure. You are hereby notified that any unauthorized use, dissemination, distribution or copying of this communication, review, retransmission, or taking of any action based upon this information, by persons or entities other than the intended recipient, is strictly prohibited. If you are not the intended recipient or an employee or agent responsible for delivering this message, and have received this communication in error, please notify us immediately by replying to the message and kindly delete the original message, attachments, if any, and all its copies from your computer system. Thank you for your cooperation.”

I was just wondering if I can generate a report for system downtime
(i.e. the service names and its corresponding downtime) through
query builder. Plan was to give the customer name as input and generate
the graph as well as chart where the instance name, service name and the
downtime is shown. Any help in this regard is greatly appreciated.

xymon (formerly hobbit monitor) makes great availability reports. Not
sure how this is a RT question… ?

Thanks Tom, but can I integrate the same with my existing RT (3.8.2)
environment and how can I do that? Where can I get the official
documentation for the Xymon.

Regards,
Uday

RT doesn’t monitor anything, so it doesn’t really have the necessary data to
create availability reports. Xymon’s web site is
http://hobbitmon.sourceforge.net/ (it still says hobbit monitor all over
it, but they’ve changed the name due to legal issues).

As far as integration, it would be quite simple to have xymon fire an alert
to the email address for a queue, thereby automatically creating a ticket
during an alarm event, something I plan on doing here. But the availability
report would still only be available through xymon, not through RT. That is
not RT’s purpose.

– ============================
Tom Lahti
BIT Statement LLC

(425)251-0833 x 117
http://www.bitstatement.net/
– ============================

I was just wondering if I can generate a report for system downtime
(i.e. the service names and its corresponding downtime) through
query builder. Plan was to give the customer name as input and generate
the graph as well as chart where the instance name, service name and the
downtime is shown. Any help in this regard is greatly appreciated.

xymon (formerly hobbit monitor) makes great availability reports. Not
sure how this is a RT question… ?

Thanks Tom, but can I integrate the same with my existing RT (3.8.2)
environment and how can I do that? Where can I get the official
documentation for the Xymon.

Regards,
Uday

RT doesn’t monitor anything, so it doesn’t really have the necessary data to
create availability reports. Xymon’s web site is
http://hobbitmon.sourceforge.net/ (it still says hobbit monitor all over
it, but they’ve changed the name due to legal issues).

As far as integration, it would be quite simple to have xymon fire an alert
to the email address for a queue, thereby automatically creating a ticket
during an alarm event, something I plan on doing here. But the availability
report would still only be available through xymon, not through RT. That is
not RT’s purpose.

If you had tickets created by the monitoring system, resolve when
the service was restored, you could generate a report with availability
information.

Cheers,
Ken

Kenneth Marshall wrote:> On Wed, Apr 29, 2009 at 11:18:03AM -0700, Tom Lahti wrote:

RT doesn’t monitor anything, so it doesn’t really have the necessary data to
create availability reports. Xymon’s web site is
http://hobbitmon.sourceforge.net/ (it still says hobbit monitor all over
it, but they’ve changed the name due to legal issues).

As far as integration, it would be quite simple to have xymon fire an alert
to the email address for a queue, thereby automatically creating a ticket
during an alarm event, something I plan on doing here. But the availability
report would still only be available through xymon, not through RT. That is
not RT’s purpose.

If you had tickets created by the monitoring system, resolve when
the service was restored, you could generate a report with availability
information.

You could also adapt
http://wiki.bestpractical.com/view/AutoCloseOnNagiosRecoveryMessages
for the Xymon alert emails (if it also sends an “all is ok” once things
are back to normal). No manual intervention on the RT side necessary
unless you want to require human intervention for issue tracking/fixes.

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati