7 Replies Latest reply on Jul 8, 2014 1:27 PM by zackm

    How to calculate MTTR & MTBF in Solar NPM

    ahmadd

      hi, I've added network nodes to the NPM monitoring and now I want to obtain MTTR & MTBF Index in NPM.

      How I can calculate this for my network stability ?

       

      MTTR = Mean time to repair/recovery

      MTBF = Mean time between failures

       

      Thanks.

          • Re: How to calculate MTTR & MTBF in Solar NPM
            ahmadd

            Hi, tnx for reply, but when in query in npm database execute query there are several errors. such :

             

            Msg 102, Level 15, State 1, Line 1

            Incorrect syntax near '<'.

            Msg 1038, Level 15, State 4, Line 1

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 1

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 1

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 1

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 103, Level 15, State 4, Line 1

            The identifier that starts with ';WITH cteTemp

            AS

            (

            SELECT

            --DATEADD(M, DATEDIFF(M, 0, GETDATE()), 0) AS SummaryMonth,

            CONVERT(DateTime,LTRIM(MONTH(EventTim' is too long. Maximum length is 128.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            Msg 1038, Level 15, State 4, Line 45

            An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

            whats problem ?

              • Re: Re: How to calculate MTTR & MTBF in Solar NPM
                zackm

                just to be clear, you ran just the SQL query right? not the whole report definition?

                 

                EDIT: Run the one below; the original has some custom properties you probably don't have in your environment (Might have to play with the parenthesis a bit, I haven't tested this, just glancing during lunch. )

                 

                 

                SELECT
                CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/01/' + LTRIM(YEAR(EventTime)),101) AS SummaryMonth,
                Nodes.VendorIcon,
                Nodes.Caption,
                DATEDIFF(Mi, StartTime.EventTime,
                    (SELECT TOP 1
                        EventTime
                        FROM Events AS Endtime
                        WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5
                            AND EndTime.NetObjectType = 'N'
                            AND EndTime.NetworkNode = StartTime.NetworkNode) 
                            ORDER BY EndTime.EventTime)/60.0 AS MTTR
                FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
                
                
                WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N') AND
                datepart(yy,eventtime) = datepart(yy,dateadd(m,-1,getdate())) and datepart(m,eventtime) = datepart(m,dateadd(m,-1,getdate()))
                )
                SELECT SummaryMonth, Region, NetworkLayer, AVG(MTTR) AS MTTR from cteTemp
                GROUP BY SummaryMonth, VendorIcon, Caption
                
                

                 

                 

                -ZackM

                Loop1 Systems: SolarWinds Training and Professional Services

            • Re: How to calculate MTTR & MTBF in Solar NPM
              ahmadd

              hi friends..

              I did not result about this.

              I've edited query & when execute it there isn't any useful thing.

              Pleas help me about this I must prepare MTTR very soon