Using SWis query to get interface utilization

dmahler99

I am trying to use the SDK SWis (and not use ODBC), but am having some issues with getting the right query together.   I am familiar with table joins and date manipulation in SQL, but so far cannot see how to pull it all together in SWis. 

for example, show min/max/avg utilization for yesterday for a router interface managed by NPM.      showing the router, interface description, min/max/avg ... for yesterday.. or for each day this  month.   or for prime shift hours each weekday this month.   etc.... you see what I mean.

I found a related query in the report writer, but it uses SQL.  i need examples of date manipulation.  and avg/max function calls in SWIS .  

are these examples somewhere in the SWis toolkit and I have just not spotted them yet?

Don M

SELECT   

TOP (100) PERCENT

CONVERT(DateTime, FLOOR(CAST(dbo.InterfaceTraffic.DateTime AS Float)), 0) AS DayRound,

1. dbo.InterfaceTraffic.NodeID,
2. dbo.InterfaceTraffic.InterfaceID,
3. dbo.Interfaces.Caption,

AVG(dbo.InterfaceTraffic.In_Averagebps) AS In_Averagebps,

MIN(dbo.InterfaceTraffic.In_Minbps) AS In_Minbps,

MAX(dbo.InterfaceTraffic.In_Maxbps) AS In_Maxbps,

**snip**

derhally

The "Orion SDK.pdf" that comes with the SDK should have a list of supported functions and various constructs.

For the query in your comment, here is a SWQL version that returns the utilization for all interfaces in the last 24 hours

SELECT InterfaceID, AVG(InAveragebps) AS InAvgBps, MIN(InMinbps) AS InMinBps, MAX(InMaxbps) AS InMaxBps

FROM Orion.NPM.InterfaceTraffic

WHERE DateTime > (GETDATE() - 1)

GROUP BY InterfaceID

SWQL is very similar to SQL.  There are differences and those should be documented in that pdf.