Jump to content

Meantime Between Failures


Darren Rose
 Share

Recommended Posts

Hello

Has anyone tried to report on Meantime between failures before and able to offer any tips on how best to do it? 

What I'm after is measuring the time between P1 incidents against a service as one of our availability targets

Thanks

Darren 

Link to comment
Share on other sites

Hi @Darren Rose @Joyce

Glad this is working well for you. 
To answer Darrens question, if you would like to filter this down even further to this year only you can add in criteria to the FROM field as per the following:

 

Quote

    (SELECT h_pk_reference,h_ownerid,h_datelogged,
        (SELECT Min(h_datelogged)       
        FROM h_itsm_requests T2       
        WHERE T2.h_datelogged > T1.h_datelogged AND h_fk_priorityname= 'High' AND h_requesttype = 'Incident' AND YEAR(h_datelogged) = YEAR(curdate())) 
        AS NextDate    
    FROM h_itsm_requests T1    
    WHERE h_fk_priorityname= 'High' AND h_requesttype = 'Incident' AND YEAR(h_datelogged) = YEAR(curdate()) ) AS AllDays

 

 

I hope this helps

Kind Regards

Bob

Link to comment
Share on other sites

  • 9 months later...

@Darren Rose just an update to say in the next Service Manager update, Service Availability metrics will be available, not 100% what you were asking for here but i thought it may be useful from an availability perspective - remembering of course you can change a services status automatically as part of of a business process, and you have the option with this new feature to view MTBF, MTTR and Availability % per SLA per Service

https://wiki.hornbill.com/index.php/Service_Availability

The next update is due in the next week to ten days time

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...