> services. I had a plan of fetching the difference in time of when the
> tickets were opened and when the tickets were resolved. That would give
> me the downtime but I have no idea how to implement that. Any help on
> this regard will greatly appreciated.
That's not really downtime, I wouldn'
Hello
Uday Dey a écrit :
> Hi,
>
>
> I am trying to generate a report for fetching the instance name,
> the related services and what is the downtime for each one of them.
>
> I have figured out something like this:
>
> select t.id, t.queue, t.owner, substr(t.subject,1,20) subject
Hi,
I am trying to generate a report for fetching the instance name,
the related services and what is the downtime for each one of them.
I have figured out something like this:
select t.id, t.queue, t.owner, substr(t.subject,1,20) subject,
t.timeworked, t.status,
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 ov
On Wed, Apr 29, 2009 at 11:18:03AM -0700, Tom Lahti wrote:
> >>> 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
>>> 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
>>> do
: 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
> 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
> downti
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