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
Store

Resource filter by date

I need some help writing a filter for my Down Interface resource.

I only want to see interfaces that went down during the last 24 or 48 hours.

Thanks

Find more posts tagged with

Accepted answers

All comments

Nodes.Status=1 AND DATEDIFF(Week, InterfaceLastChange, getdate()) = 0

Nodes.Status=1 {so you only see interfaces that are on nodes that are currently UP}

I use Week instead of Day, (Day, Week, Month, and Year are valid)

Hope that helps

Quick Links