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

Report on Last Time 'List resources' was Run against a Node

Guys, looking to create a daily report and/or dashboard showing the last time 'List Resources' was run on a network device. I have been doing an audit and found many network devices not being monitored for routing tables etc. Often when I run 'List Resources' against them I see something like this:

Is there a canned option for this or if not, might anyone know the SQL for it? SDK is also an option for me.

Find more posts tagged with

Accepted answers

All comments

bmallon

Yeah, OI agree this should be a thing. I have so many devices and we want to keep things current.

shocko

Anyone any ideas on this one?

shocko

This looks like a start:

SELECT * FROM [dbo].[nodes]

RIGHT JOIN [dbo].[NodeListResourcesCache]

ON [dbo].[NodeListResourcesCache].NodeID = [dbo].[nodes].NodeID

ORDER BY CachedTime