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

UDT report showing nodes without Layer 3 jobs

Any suggestions on creating a report to identify devices without Layer 3 UDT jobs? Trying to be proactive about ensuring we have IP and Host Name information correlated with the MAC address.

Thanks all

Find more posts tagged with

Accepted answers

All comments

Try this as a custom SQL report:

selectn.caption as 'Device',case  when j.jobtype = 2 then 'Layer 2'  when j.jobtype = 3 then 'Layer 3'  when j.jobtype = 5 then 'Remote Event Log'end as 'Job Type',dateadd(mi, datediff(mi, getutcdate(), getdate()), j.joblastrun) as 'Last Run'from nodesdata njoin udt_job j on j.nodeid = n.nodeidorder by n.nodeid, j.joblastrun desc

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

Quick Links