Good Morning THWACK Community,
I need a little help with an SQL Query I use to filter the 'Down Interfaces' resource. I have been asked to use the Down Interface resource to show interfaces that have gone down in the last 24 hours and a second 'Down Interfaces' resource to show the interfaces that have been down for the last 7 days. This seemed pretty straight forward...
For the 'Down Interface' in the last 24 hours resource, I used this SQL filter
InterfaceLastChange >= DATEADD(dd,DATEDIFF(dd,0,GETDATE()),-1)
For the 'Down Interfaces' in the last 7 days resource, I used this SQL filter
InterfaceLastChange >=DATEADD(dd,DATEDIFF(dd,0,GETDATE()),-7)
Then I realized that this is kinda redundant for the first 24 hours. The same interfaces will show up in both resources for the first 24 hours. Is there a way to tweak my second filter to exclude the time frame from the first filter?