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

Script to Move Nodes from One Group to Another

I need to come up with a script that processes a list of defined nodes and move each from one NPM group to another. This will be done on a regular interval as the typography changes from week to week.

I attempted to write a test script (in Perl) to perform this via making the changes in the database, but ended up with strange results.

My script located the the member's records in the ContainerMemberDefinitions and ContainerMemberSnapshots table and updated the rows to change to a different ContainerID.

Afterwards, the nodes still showed up only in the original group on the Group Summary page. But when you go to manage the groups, the nodes would show in the list of both groups. And when you go to "Add & Remove Objects", the nodes would only be in the destination group.

Am I missing other tables that need to be changed to move nodes from one group to another?

How can this be done in an automated manner?

The manual process to move these nodes from one group to another is too time consuming.

Any help is appreciated.

Find more posts tagged with

Accepted answers

All comments

chad.every

Your script would have to be 2 part and use the API.

Part 1: Remove node from group

Part 2: Add node to group.

I searched thwack quickly and found this post where someone was using perl to do this.

Need help trying to add a node to a group container using Perl

I've dealt more on the powershell side of the house when interacting with Orion's APIs.

Here are some other links that i find handy.

SDK on github:https://github.com/solarwinds/OrionSDK/wiki and https://github.com/solarwinds/OrionSDK/tree/master/Samples/PowerShell

JSON API Examples: https://thwack.solarwinds.com/message/227207

conguir

wouldn't be easier if you use custom properties and dynamic queries inside the groups? You could create a custom property (for example 'Membership') and then you create groups with dynamic queries that automatically populate devices depending on the value of Membership.

With this structure you just have to modify the value of the custom property to each device (either manually or through a simple script) in order to relocate them in different groups.

Raul Gonzalez

Prosperon - UK SolarWinds Partners

Installation | Consultancy | Training | Licenses

chad.every

+1 to what conguir said. Using a dynamic query builder and custom properties would be a far easier way to go.

There are some scripts on Thwack already that outline how to modify CP's via the Orion API

PowerShell script to modify a NODE Custom Property via Rest API/JSON

PowerShell script to modify an APPLICATION Custom Property via Rest API/JSON

meech

Hi boballen,

Can you explain the use case for wanting to move nodes from one group to another?--I just want to make sure I understand the why of it. Thanks!

Kellie

boballen

Kellie,

In our particular case, we have 3 to 4 video cameras being monitored at each golf course hole. Each week the actual golf course changes and the number of cameras at each hole and specific hole each camera is assigned also changes. They have these cameras grouped by the hole they are assigned, so they can see at a glance which holes are having camera issues and when alerts are generated they can immediately know which hole is having issues.

Their desire is to provide a spreadsheet each week of the hole-camera assignments and have a script that adjusts the group assignments for each camera as needed. I have looked at the database tables Containers, ContainerMemberDefinitions, and ContainerMemberSnapshots; but manually manipulation of these tables doesn’t seem to have the desired effect.

Thanks,

Bob