How to query from the list in powershell script

Question

I have this response in json format:

{
    "properties": {
        "basic": {
            "nodes_table": [
                {
                    "node": "node1.prod.local:80",
                    "state": "active",
                    "weight": 1
                },
                {
                    "node": "node2.prod.local:80",
                    "state": "disabled",
                    "weight": 1
                },
                {
                    "node": "node3.prod.local:80",
                    "state": "disabled",
                    "weight": 1
                },
                {
                    "node": "node4.prod.local:80",
                    "state": "disabled",
                    "weight": 1
                },
                {
                    "node": "node5.prod.local:80",
                    "state": "active",
                    "weight": 1
                }
            ]
        }
    }
}

What I am trying to do in my powershell script is to find out if given node(s) is available in the nodes_table and get their state. For example:

$nodes_table_hostnames = $GetNodesResponse.properties.basic.nodes_table.node
$nodes_table_status = $GetNodesResponse.properties.basic.nodes_table.state

if($nodes_table_hostnames -contains "node1.prod.local:80" -and $nodes_table_status -eq "active")
    {
        Write-Output  "Node matches and is Active"
    }

Problem: I am having an issue in getting the state of the "specific" node, so I want to check if "given" node is in the table and that node's state is active/disabled. How would I accomplish that in the script?

mklement0 · Accepted Answer · 2018-04-30 20:07:12Z

5

$Active = $GetNodesResponse.properties.basic.nodes_table |
            Where {$_.Node -eq "node1.prod.local:80" -and $_.state -eq "active"}
If ($Active) {Write-Output  "Node matches and is Active"}

edited Apr 30, 2018 at 20:07

mklement0

452k68 gold badges728 silver badges988 bronze badges

answered Apr 30, 2018 at 16:49

iRon

24.4k10 gold badges60 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bruce Payette · Accepted Answer · 2018-04-30 21:45:42Z

1

To check against multiple strings, use the -in operator

Where {$_.Node -in "node1.prod.local:80", "node5.prod.local:80" -and $_.state -eq "active"}

or you could use the -like or -match operators to match a pattern as in:

Where {$_.Node -like "node[15].prod.local:80" -and $_.state -eq "active"}

answered Apr 30, 2018 at 21:45

Bruce Payette

2,67912 silver badges8 bronze badges

1 Comment

Shahboz Over a year ago

Thanks for the answer Bruce! Your solution definitely works.

Collectives™ on Stack Overflow

How to query from the list in powershell script

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related