HI, so I'm trying to do a report on an Interface, i want the report to show me the level of transmit discards for certain weeks withing a year, I'm very new to SWQL so any help would be appreciated!

Question

For more of an idea of what i want: i want a line graph that shows the entire year on the x axis, but for each month there is a specific week for when i want the data to be displayed, so for January it's the first till the 7th and for march i want the 8th to the 14th, for February i want the 1st to the 7th as well, if that makes any sense. I've been trying to do this in the query builder and I'm having no luck, so any advice or help that can be given would really be appreciated. Thank You!

Tejay_2005 · Answer

Thank you so much !! this really helps

sum_giais · Answer

I'd recommend getting SWQL Studio to familiarize yourself, it's a very helpful resource.

https://github.com/solarwinds/OrionSDK/releases
https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions

Below is an example of a SWQL query you could use to start this off.

SELECT TOP 1000
     i.Caption
    ,i.DetailsUrl
    ,i.Status
    ,i.Errors.OutDiscards
    ,i.Errors.DateTime
FROM Orion.NPM.Interfaces AS i
WHERE (
    -- January 1st through the 7th
    DAY(i.Errors.DateTime) BETWEEN 1 AND 7
    AND MONTH(i.Errors.DateTime) = 1
) OR (
    -- February 1st through the 7th
    DAY(i.Errors.DateTime) BETWEEN 1 AND 7
    AND MONTH(i.Errors.DateTime) = 2
) OR (
    -- March 8th through the 14th
    DAY(i.Errors.DateTime) BETWEEN 8 AND 14
    AND MONTH(i.Errors.DateTime) = 3
)

Tejay_2005 · Answer

Thank you ! So how would the SELECT look ? Sorry i'm not very familiar with query languages, also would this show all weeks i want to see at once ? Thanks x