Jump to content

Meantime Between Failures

Darren Rose

Recommended Posts

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:



    (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


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


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
  • Create New...