[rt-users] Query for Service downtime

[Uday Dey]

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, t.timeleft, t.told, t.started, t.resolved,
t.lastupdatedby, t.creator, t.created from tickets t, queues q where
t.status='resolved' and t.subject like upper('%down%') and
q.name='&client_name' and q.id=t.queue;

 

        But it's not solving my purpose fully. I am getting the date on
which the services went down and the date on which it got resolved. All
in all I am not getting the respective Downtime for each of the
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. 

 

 

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." 
________________________________________________________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090504/e7d907b8/attachment.htm>