Meantime Between Failures

[Darren Rose]

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 

[Guest]

Hi @Darren Rose

I spent a little bit of time last year looking at achieving this for another customer - have a look through this post and see if it gives you some ideas:

 

Kind Regards

Bob

[Darren Rose]

Thanks, Bob. I've set @Joyce the task of deciphering it all

[Darren Rose]

Hi @Bob Dickinson

thank you for this. It helped get us going in the right direction. I did have one query though, which I tried to work out but couldn't. Is it possible to add filter the results based on calls logged this year? 

Darren 

[Joyce]

Working great thanks @Bob Dickinson

[Guest]

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

[Steven Boardman]

@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