Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Historical Interface Reports

I am writing some historical interface analysis reports and report writer in 10.1.1 does not allow you to select historical data for errors and discards..?

This is another report I am having to create in sql, am I missing this or in the wrong type of report to see the historical discards? It seems you can have a mixture of current and historical - but cannot have both historical in the same report!

Find more posts tagged with

historical_interface_reports

errors_and_discards_against_total_packets_inout

Accepted answers

All comments

kweise

mezdem,

I was able to create a report showing both interface errors and discards. I did get an invalid SQL query error when I tried to include the node name along with the interface names. I was able to get the report to generate by including the following fields: Under Interfaces | Interface Details | Full Name. Under Historical Interface Errors I selected both Recv+Xmit Errors and Recv+Xmit Discards. Using those three fields, I was able to get the report to generate.

Hope this helps!

mezdem

sorry I may of rushed my original post the report I am producing needs to show total packets in, error in, discards in, packets out , errors out and discards out for a time range.

This I then sum the values and work out the percentage of discards and errors per interface per day/week/month etc based on the total packets in and out

SELECT     TOP (100) PERCENT CONVERT(DateTime, FLOOR(CAST(dbo.InterfaceTraffic.DateTime AS Float)), 0) AS SummaryDate, dbo.Nodes.NodeID,
                      dbo.Nodes.SysName AS System_Name, SUM(dbo.InterfaceTraffic.In_TotalPkts) AS SUM_of_Total_Packets_Received,
                      SUM(dbo.InterfaceTraffic.Out_TotalPkts) AS SUM_of_Total_Packets_Transmitted, SUM(NULLIF (dbo.InterfaceTraffic.In_TotalPkts, - 2)
                      + NULLIF (dbo.InterfaceTraffic.Out_TotalPkts, - 2)) AS SUM_of_TotalPacketsRecvXmit, SUM(dbo.InterfaceErrors.In_Discards) AS In_Discards,
                      SUM(dbo.InterfaceErrors.In_Errors) AS In_Errors, SUM(dbo.InterfaceErrors.Out_Discards) AS Out_Discards, SUM(dbo.InterfaceErrors.Out_Errors)
                      AS Out_Errors, SUM(dbo.InterfaceErrors.Out_Discards) / SUM(dbo.InterfaceTraffic.Out_TotalPkts) AS Expr1
FROM         dbo.Nodes INNER JOIN
                      dbo.InterfaceTraffic ON dbo.InterfaceTraffic.NodeID = dbo.Nodes.NodeID INNER JOIN
                      dbo.InterfaceErrors ON dbo.Nodes.NodeID = dbo.InterfaceErrors.NodeID AND dbo.InterfaceTraffic.DateTime = dbo.InterfaceErrors.DateTime INNER JOIN
                      dbo.Interfaces ON dbo.Nodes.NodeID = dbo.Interfaces.NodeID AND dbo.InterfaceTraffic.InterfaceID = dbo.Interfaces.InterfaceID AND
                      dbo.InterfaceErrors.InterfaceID = dbo.Interfaces.InterfaceID
WHERE     (dbo.InterfaceTraffic.DateTime > GETDATE() - 42) AND (dbo.Nodes.SysName = 'MAT_Dist_A' OR
                      dbo.Nodes.SysName = 'MAT_Dist_B')
GROUP BY CONVERT(DateTime, FLOOR(CAST(dbo.InterfaceTraffic.DateTime AS Float)), 0), dbo.Nodes.NodeID, dbo.Nodes.SysName
HAVING      (SUM(dbo.InterfaceErrors.Out_Discards) > 5000)
ORDER BY SummaryDate