This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Automated Group Creation - NPM 10.2

Guys I am using NPM 10.2 and I am trying to find an easier way to create groups.  I have a custom property field on all my devices that tell me the Site Name which we update from our CMDB.  What I am trying to do is create a group for each site with a dynamic group query based off that field.  I can easily do it manually however I have a few hundred sites and that lists changes quite a bit.  So this would be a VERY tedious task.

So what I am wondering is could this be done by updating the DB directly with some sort of a script?  I have looked at the DB and have found the 'Container' tables but it looks REALLY messy.  I have a ticket open with support but it does not seem like they are understanding what I am trying to do so I figured I would give this a try.  I am not sure if it is even possible but I figured I would give it a try.

Thanks in advance for any feedback.

 

Mike

  • Hi,

    even it is possible to add groups directly via database you should be aware that such solution is not officially supported. You should focus on table Containers and ContainerMemberDefinitions. Best way how to do that is to create one group via web, then look at its definition in datbase and according to it write script which creates other groups.

  • Yes those are the two tables I was looking at but it looks VERY 'messy', I just wanted to see if anyone else has looked into this.  It would be nice if there was some type of a group import function, however I am not sure how many people are even using them.  I figured I would pose the question and see what kind of feedback I got.

    Thanks for your response.

  • Btw. there is also possibility to add new groups via Orion SDK, there are support verbs for it, so if you are familiar with basic scripting you could do also this way.

  • Really, do you have any documentation or info regarding the SDK?  That might be VERY helpful!!!

    THANKS!!!

  • The SDK information can be found in the Forums -> SolarWinds Community -> Orion SDK or you can just use this link to jump directly to the SDK which includes some documents to assist users in creating scripts.

    I can't tell if you already tried this or not, but you can create a group with a dynamic query based on certain objects. This means you can use the comment custom property to dynamically create your groups. You can then use the Custom Property Editor to import a spreadsheet that has this information or bulk edit the node properties (Start -> Programs -> SolarWinds Orion -> Grouping and Access Control).

    Mav

  • There is dedicated forum on thwack about Orion SDK. Basic information can be found here

    On forum you can found lot of interesting information. So if you master any programming or scripting language it could be good way for you.

  • We use a Custom Property to dynamically update the Group memberships- After you create a group and hit next, you have an option to add a Dynamic Query- in the Add Orion Objects page-

    So far, has worked like a charm!

  • Mike, hello.

    I have the same task, as you mentioned above.

    I already have installed the Orion SDK, but there are no any information and examples about automated group creation in documentation...

    Do you have any success in working on this task?

  • Hello, at this point it does not look like there is an easy way to auto-create a group.  From what I see in the DB there are 2 or 3 tables that are all linked and I dont see a way to auto create those.  I am also looking at the SDK but I dont see anything related to creating groups.  Looks like it is only for adding and changing device and device polling.  If I come up with anything I will let you know.

    Sorry this is not really an answer.  LOL

    Mike

  • Thank you, Mike. Solarwinds techical support advised me to create new feature request on thwack.

    I suppose, development team can implement this feature in later versions, if enough users will be interesting in that.