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

Need to run a TSQL command to "UnManage" down interfaces in bulk

FormerMember

I need to set the "UnManaged" bit on multiple interfaces (close to 4k) so NPM will no longer poll those interfaces.

I tested this on a single switch with 58 total interfaces (55 of them were down - or in SQL, [Status] <> '1').

This is the TSQL command I ran:

Use NetPerfMon

UPDATE

dbo.Interfaces

SET Unmanaged = 1

WHERE Fullname like 'BuildingE_Switch%' AND Status <> 1

I verified my command worked in SQL then went out to my NPM Web Console and see that all the interfaces still have checkmarks next to them as if they are still going to be polled.

Any idea why my web console isn't correctly reading the database? Any ideas on another way I can accomplish my need to "unmanage" those 4k interfaces?

Thanks, Joni

Find more posts tagged with

Accepted answers

Hi, in case you really want to do that by TSQL, you need to specify unmanage time period, otherwise system will automatically re-manage those interfaces. Your command should look like.

Use NetPerfMon;

UPDATE dbo.Interfaces SET Unmanaged = 1, UnManageFrom=GETDATE(), UnManageUntil=DATEADD(year, 1, GETDATE())

WHERE Fullname like 'BuildingE_Switch%' AND Status <> 1

This will unmanage all needed interfaces for 1 year. (Condition [Status <> 1] is very wide. Maybe better to use [Status = 2] <= down)

Regards,

All comments

Hi, in case you really want to do that by TSQL, you need to specify unmanage time period, otherwise system will automatically re-manage those interfaces. Your command should look like.

Use NetPerfMon;

UPDATE dbo.Interfaces SET Unmanaged = 1, UnManageFrom=GETDATE(), UnManageUntil=DATEADD(year, 1, GETDATE())

WHERE Fullname like 'BuildingE_Switch%' AND Status <> 1

This will unmanage all needed interfaces for 1 year. (Condition [Status <> 1] is very wide. Maybe better to use [Status = 2] <= down)

Regards,

rjager

Hi ET,

Is there another way to unmanage bulk devices other then then suggested by using TSQL?

Your answer suggests there is, if so, i am interested in how to...

Try to use "Unmanage Scheduling Utility" (located in start menu), but I'm not sure whether it fits to all your needs in this case.

njoylif

either that or got into mange nodes -> select drop down from nodes to interfaces -> choose group by status -> click check box in upper right to select all on that page. system will prompt to see if you want to select all 4k interfaces - say yes if that's what you want, then select unmanage and set your time parameters.

This will take a while so do this and go to lunch.

with that many you may have to take a few swipes, but should ultimately work.

FormerMember

That worked great! We can now better manage our 20k+ interfaces. Thanks for the quick reply.

Joni