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.
Orion NPM MTTR Report should help
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 1Incorrect syntax near '<'.Msg 1038, Level 15, State 4, Line 1An 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 1An 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 1An 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 1An 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 1The identifier that starts with ';WITH cteTempAS(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 45An 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 45An 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 45An 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 45An 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 45An 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 45An 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 45An 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 45An 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 45An 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 45An 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 45An 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 45An 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 45An 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 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 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
whats problem ?
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. )
SELECTCONVERT(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 MTTRFROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeIDWHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N') ANDdatepart(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 cteTempGROUP BY SummaryMonth, VendorIcon, Caption
-ZackM
Loop1 Systems: SolarWinds Training and Professional Services
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
Try this one. I just tested it in my lab and it is working. (The other one had some syntax errors)
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()))
Very nice dear zackm. Now how I can add this report to SolarWinds web console Reports like other reports such Availability , Current Interface Status, Events and... with MTTR Subject ?
you would need to create a new custom SQL report
you can find training in the videos section of thwack, or in the administrator's guide for NPM.
https://thwack.solarwinds.com/docs/DOC-173478
