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

Mass removal of Pagefile volumes from monitoring - can it be done?

Hi all,

Scanning through the volumes I have monitored I see that by default, all volumes on Windows boxes seem to be added for monitoring when you add a new node. This seems to include all of the page file volumes on my servers, which of course are tightly allocated and almost always near 100% full. Doing a quick look at the database I can see at least 900 of these volumes being monitored and ideally we'd like to remove them. Would be nice to give our polling engines a break!

So the question is, is there any way to unmanage these Pagefile volumes en masse?

I've got a SWQL query that I can use if required:

SELECT NodeID, VolumeID FROM Orion.Volumes where caption like '%agefile%'

Orion Core 2011.2.1, APM 4.2.0 SP1, NPM 10.2.1

Find more posts tagged with

npm_volume_pagefile

Accepted answers

mdriskell

Are you wanting to unmanage or delete??? If you want to delete you can do what I have listed below...not sure how to unmanage directly from the DB on the volumes table.

I would always suggest backing up your DB first before editing directly however it can be done from the database.

If you are certain that this query returns only those volumes you wanted to delete.

SELECT NodeID, VolumeID FROM Orion.Volumes where caption like '%agefile%'

You can run this to delete them directly from the DB. Use with caution.

Delete From Volumes

where caption like '%agefile%'

All comments

mdriskell

Are you wanting to unmanage or delete??? If you want to delete you can do what I have listed below...not sure how to unmanage directly from the DB on the volumes table.

I would always suggest backing up your DB first before editing directly however it can be done from the database.

If you are certain that this query returns only those volumes you wanted to delete.

SELECT NodeID, VolumeID FROM Orion.Volumes where caption like '%agefile%'

You can run this to delete them directly from the DB. Use with caution.

Delete From Volumes

where caption like '%agefile%'

qbarry

Spot on Mike - worked like a charm.

I also created another method using the SDK. There's an example of how to use a delete object method in there that was easy enough to script.

One thing though - I do see a lot of usage information for these volumes in the VolumesUsage_daily, VolumesUsage_Hourly tables in the database. Doesn't appear that deleting a volume objcet removes this data for the removed volumes. So I'm guessing that Orion runs it's own cleanup routines on these tables at some point along the way.... Just an observation...