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."
_______________________________________________________________________________________________________________________________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
