Data export reports that capture all interfaces that are administratively up, but operationally down

RB0033

Looking to have Solarwinds to run data export reports that capture all interfaces that are administratively up, but operationally down for more than X days?  I need to have this include ports that have not been used since before the last switch reload, so that it specifically does not use "last used date/time" by the date of the switch reload. 

The dynamic query in reports doesnt allow me to do admin up vs operational so I looked into swql. This is as far as I got with an output:

SELECT TOP 10

    Name,

    AdminStatus,

    OperStatus

FROM Orion.NPM.Interfaces

Which does give me something, but would need to make it for all nodes, or specific groups?

I also tried the below…..but that just failed "Query Invalid". Any easier ways or thoughts on how to write this?

Thank you!!

SELECT
I.Node.NodeName AS [Node],
I.Name AS [Interface],
I.AdminStatus,
I.OperStatus,
I.LastStatusChange
FROM Orion.NPM.Interfaces I
WHERE
I.AdminStatus = 1
AND I.OperStatus = 2
AND I.LastStatusChange < ADDDAYS(-30)
ORDER BY
I.LastStatusChange

dgsmith80

You will need to change the Date Query to something like:

AND DAYDIFF(DATETRUNK('Day', i.LastChange), GETUTCDATE()) < 30