Using Power Shell to create groups and then adding a custom query but the filter does not work as expected

joebearaz

Trying to mass add groups that will have custom queries to populate the members of that group, I am testing this with one group, the name of the group will be BK00112 and I want to create a dynamic query that will pull all node names that being with BK00112 (there are two currently), but I cannot get the filter syntax correct to do this, it keeps pulling all nodes instead of filtering.

See code:

$members = @(

    @{ Name = "Store Devices"; Definition = "filter:/Orion.Nodes[Caption StartsWith ‘bk00112’]" }

)

 

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

    # group name

    “bk00112”,

 

    # 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

    "Store Group",

 

    # polling enabled/disabled = true/false (in lowercase)

    "true",

 

    # group members

    ([xml]@(

       "<ArrayOfMemberDefinitionInfo xmlns='">schemas.solarwinds.com/.../Orion'>",

       [string]($members |% {

         "<MemberDefinitionInfo><Name>$($_.Name)</Name><Definition>$($_.Definition)</Definition></MemberDefinitionInfo>"

         }

       ),

       "</ArrayOfMemberDefinitionInfo>"

    )).DocumentElement

  )).InnerText

 

Why is this not working as expected, it creates that group correct but the group member filter is not pull only those nodes that StartWith bk00112, why?

Thanks in advance for any help someone may be able to provide here.

flackovic

I'm assuming you are following the OrionSDK template located HERE.

There is a commented section near the top of the file that includes instructions on how to create a new group using different definition filter methods:

# CREATING A NEW GROUP
#
# Creating a new group with initial Cisco and Windows devices.
#
<# Filter samples w/ all operators:
IP_Address is 192.168.10.10
filter:/Orion.Nodes[IP_Address='192.168.10.10')]
IP_Address is not 192.168.10.10
filter:/Orion.Nodes[IP_Address!='192.168.10.10']
IP_Address starts with 192.168.10.
filter:/Orion.Nodes[StartsWith(IP_Address,'192.168.10.')]
IP_Address ends with .10.%
filter:/Orion.Nodes[EndsWith(IP_Address,'.10.%')]
IP_Address contains .10.
filter:/Orion.Nodes[Contains(IP_Address,'.10.')]
IP_Address matches 192.168.*
filter:/Orion.Nodes[Pattern(IP_Address,'192.168.%')]
#>

Specifically, the method you are looking for is the last method in that comment block. In order to achieve the intended outcome, your Definition should look like this:

filter:/Orion.Nodes[Pattern(Caption,'bk00112%')]

Try out that definition and let me know if it works for you!