SDK/PowerShell - Group Creation Script Issue

Trying to use the following script (based on the 'Groups' example in the SDK) to add groups based on Nodes.Location and a CustomProperty !=

if (! (Get-PSSnapin | where {$_.Name -eq "SwisSnapin"})) {
    Add-PSSnapin "SwisSnapin"
}# Connect to SWIS
$hostname = "localhost"
$username = "username here"
$password = "password here" | ConvertTo-SecureString -asPlainText -Force
$cred = New-Object -typename System.Management.Automation.PSCredential -argumentlist $username, $password 
$swis = Connect-Swis -host $hostname -cred $cred#Set the locatoin of the csv
Set-Location 'C:\Users\username here\Desktop'# read in csv file
$importFile="./MakeGroups.csv"
$importList=IMPORT-CSV $importFile#iterate through each entry in csv file
FOREACH($import in $importList)
{
    $SiteCode = $import.Location
    $members = @(
  @{ Name = "$SiteCode"; Definition = "filter:/Orion.Nodes[Location='$SiteCode' AND CustomProperties.Device_Type != 'Router']" }
)$groupId = (Invoke-SwisVerb $swis "Orion.Container" "CreateContainer" @(
    # group name
    "$SiteCode",
    # owner, must be 'Core'
    "Core",
    # refresh frequency
    60,
    # Status rollup mode:
    # 0 = Mixed status shows warning
    # 1 = Show worst status
    # 2 = Show best status
    0,
    # group description
    "Group created by the PowerShell sample script.",
    # polling enabled/disabled = true/false (in lowercase)
    "true",
    # group members
    ([xml]@(
       "<ArrayOfMemberDefinitionInfo xmlns='http://schemas.solarwinds.com/2008/Orion'>",
       [string]($members |% {
         "<MemberDefinitionInfo><Name>$($_.Name)</Name><Definition>$($_.Definition)</Definition></MemberDefinitionInfo>"
         }
       ),
       "</ArrayOfMemberDefinitionInfo>"
    )).DocumentElement
  )).InnerText
     
}

Keep getting this error:

Invoke-SwisVerb : Entity Orion.Nodes does not contain requested property A

At C:\Users\username here\Desktop\MakeGroups.ps1:32 char:14

+ $groupId = (Invoke-SwisVerb $swis "Orion.Container" "CreateContainer" @(

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidOperation: (:) [Invoke-SwisVerb], FaultException`1

+ FullyQualifiedErrorId : SwisError,SwisPowerShell.InvokeSwisVerb

Looking in the DB, the script is creating the group under 'Containers', but there is not an entry being created under 'ContainerMemberDefinitions'

All help is appreciated

Find more posts tagged with

automatic

auto

group_creation

posh

PowerShell

sdk

Group

Accepted answers

All comments

derhally

Do any of the values in your CSV have quotes in them?

This script worked for me

if (! (Get-PSSnapin | where {$_.Name -eq "SwisSnapin"})) {      Add-PSSnapin "SwisSnapin"  }  # Connect to SWIS  $hostname = "localhost"  $swis = Connect-Swis -host $hostname  $SiteCode = "Dev";  $members = @( @{ Name = "$SiteCode"; Definition = "filter:/Orion.Nodes[Location='Washington' AND CustomProperties.Department='$SiteCode']" })  $groupId = (Invoke-SwisVerb $swis "Orion.Container" "CreateContainer" @(      # group name      "$SiteCode",      # owner, must be 'Core'      "Core",      # refresh frequency      60,      # Status rollup mode:      # 0 = Mixed status shows warning      # 1 = Show worst status      # 2 = Show best status      0,      # group description      "Group created by the PowerShell sample script.",      # polling enabled/disabled = true/false (in lowercase)      "true",      # group members      ([xml]@(         "<ArrayOfMemberDefinitionInfo xmlns='http://schemas.solarwinds.com/2008/Orion'>",         [string]($members |% {           "<MemberDefinitionInfo><Name>$($_.Name)</Name><Definition>$($_.Definition)</Definition></MemberDefinitionInfo>"           }         ),         "</ArrayOfMemberDefinitionInfo>"      )).DocumentElement    )).InnerText

JesperVestergaard

I wanted to do something like this, but did not get the point about the csv file (as for me, all my relevant data is in solarwinds databases)

Honestly, i´m no programmer (by far) but find it interesting how to save time, and have consistent data - Lazy network engineer mindset i guess

I had some help, and ended up with this - And is working perfect for me .

Next step is to create groups for my sites, where category is NOT WAN, and then figure out how to script dependancies between the two groups for the site - wan and lan

And ... a feature request - Build this into the application instead

Albeit i love this scripting (over manual labor) i´d appriciate the feature natively, and not customized, if i can

$cities = Get-SwisData $swis "SELECT DISTINCT City FROM Orion.NodesCustomProperties WHERE City IS NOT NULL"foreach($city in $cities){$members = @(  @{ Name = "$city WAN nodes"; Definition = "filter:/Orion.Nodes[Contains(CustomProperties.Category,'WAN') AND CustomProperties.City='$city']" })$groupId = (Invoke-SwisVerb $swis "Orion.Container" "CreateContainer" @(    # group name    "$city WAN",    # owner, must be 'Core'    "Core",    # refresh frequency    60,    # Status rollup mode:    # 0 = Mixed status shows warning    # 1 = Show worst status    # 2 = Show best status    0,    # group description    "$city WAN nodes, selected based on custom property value nodes city",    # polling enabled/disabled = true/false (in lowercase)    "true",    # group members    ([xml]@(       "<ArrayOfMemberDefinitionInfo xmlns='http://schemas.solarwinds.com/2008/Orion'>",       [string]($members |% {         "<MemberDefinitionInfo><Name>$($_.Name)</Name><Definition>$($_.Definition)</Definition></MemberDefinitionInfo>"         }       ),       "</ArrayOfMemberDefinitionInfo>"    )).DocumentElement  )).InnerText}

zyontist

Hi I know this is an old thread but I am not a Powershell expert and trying to do something like this where it is automatically creating groups dependant on site information of newly discovered sites.

Our naming convention is like this:

We are looking to make up groups and sub groups as follows:

Main Group

2 Sub groups for each site

<Site Code> WAN devices

<Site Code> LAN devices

So my question is this:

Is it possible using a Powershell script to create groups and sub groups and using the codes in the naming convention to create those and work out the group members? We have criteria to differentiate WAn/LAN devices per site as at the moment we are doing it manually and there are 100's of sites so looking to see if it can be done automatically to speed it up?

Kind regards,

tdanner

Yes, this is possible. The samples in OrionSDK/Groups.ps1 at master · solarwinds/OrionSDK · GitHub show all of those basic operations. You would just need to write some loops to handle the logic for your organization and naming convention. Let me know if you have issues.

patriot

zackm,

I know this is an old post, but I am just now needing to do something very similar. I have over 1500 stores in most States and I need to create a Group for each store and then have a way to automatically create a next level Group for each state and automatically place the proper store groups in the state group (i'm thinking that I will need a separate group custom property for that part),

Can this script be used for that purpose? If so, what changes might be needed for it to work with Platform 2017 DB schema?

zackm

All of the current examples are in the Orion SDK Github: OrionSDK/Groups.ps1 at master · solarwinds/OrionSDK · GitHub

There are multiple different examples in that script, including creating subgroups. None of this would be dependent on the DB Schema, so it is scalable.

fjpeterson

If you use GitHub - freemanpeterson/SWIFTPowershell: Powershell Module for SolarWinds .

I created simple cmdlet.

#Adding a simple group at root

Add-SWGroup -Group "Department"

#Adding Subgroup with group members

$GroupMembers = @(

@{ Name = "My Lookup"; Definition = "filter:/Orion.Nodes[CustomProperties.App='$App']" }

)

Add-SWGroup -Parent "Department" -Group "App" -GroupMembers $GroupMembers