How to modify a custom property for multiple nodes with Powershell

John W Johnson

So, 

I have been working on several  powershell scripts...  Here is what i have.

#Author: John Johnson
#Last Modified: 3/8/22
#Summary: Set Node Custom Properties in SolarWinds

# Be sure to install the SwisPowershell module on Powershell 5 or lower prior to use
# Install-Module SwisPowershell

#Designate Hostname

$server = 'host'

$creds = Get-Credential

$swis = Connect-Swis -HostName $server -Credential $creds

#$nodes = Get-SwisData $swis 'SELECT NodeID, Caption, DNS, IPAddress, Uri FROM Orion.Nodes'

## Export data from SWQL and arrange it in Excel first
## CSV Import Approach
$updates = Import-Csv C:\Users\list.csv

foreach ($update in $updates)
    {
        Write-Host "Updating"$($update.IPAddress)"@$($update.Uri)
        $properties = ''
        $properties = $update.psobject.properties | where-object {($_.Name -ne "Uri") -and ($_.Name -ne "NodeID") -and ($_.Name -ne "IPAddress")}

        $record = @{}
        foreach ($property in $properties)
            {
                if (($($property.Value) -ne $null) -and ($($property.Value) -ne ''))
                    {
                        $record += @{$($property.Name)=$($property.Value)}
                    }
            }

        Set-SwisObject $swis -Uri $($update.Uri) -properties $record

    }

i have a custom property 'NodesCustomProperties.ServiceNow_Owner_1'

how would i be able to use a serverlist.csv, to modify all servers in the list...and modify the custom property above?

sum_giais

Here's a basic example of how to modify custom properties of nodes already in SolarWinds from within PowerShell.

Now if you already are exporting the data into CSV / Excel and making updates there you could just re-import within the GUI too if it's a one-off.

Import-Module -Name SwisPowerShell

$hostname = 'myOrionServer'

$creds = Get-Credential

$swis = Connect-Swis -Hostname $hostname -Credential $creds

$query = @"
	SELECT
		 n.Caption
		,n.IP_Address
		,n.Uri
		,n.CustomProperties.ServiceNow_Owner_1
	FROM Orion.Nodes AS n


$selection = Get-SwisData -SwisConnection $swis -Query $query

ForEach ($node in $selection) {

	$cpUri = $node.Uri + "/CustomProperties"

	Write-Output("Working on " + $node.Caption)

	If ($node.ServiceNow_Owner_1 -ne "myExpected Value" -or [string]::IsNullOrEmpty($node.ServiceNow_Owner_1)) {

		Set-SwisObject -SwisConnection $swis -Uri $cpUri -Properties @{

			ServiceNow_Owner_1 = "myUpdatedValue"

		}

		Write-Output("`tValue for ServiceNow_Owner_1 updated...")

	} Else {

		Write-Output("`tNo updates necessary...")

	}

}

Here's a take on using Read-Host to pull in some input from the console and using it in a query...

Import-Module -Name SwisPowerShell

$hostname = 'myOrionServer'

$creds = Get-Credential

$swis = Connect-Swis -Hostname $hostname -Credential $creds

$prompt1 = "Enter the Node Name (Caption) of the node to edit properties on: "

$CaptionFilter = Read-Host -Prompt $prompt1

$prompt2 = "Which property would you like to edit on '" + $CaptionFilter + "'?"

$customPropertyName = Read-Host -Prompt $prompt2

$query = @"
	SELECT TOP 1
		 n.Caption
		,n.IP_Address
		,n.Uri
		,n.CustomProperties.$customPropertyName
	FROM Orion.Nodes AS n
	WHERE n.Caption = '$CaptionFilter'


$node = Get-SwisData -SwisConnection $swis -Query $query

$cpUri = $node.Uri + "/CustomProperties"

$prompt3 = "What would you like to change the property '" + $customPropertyName + "' to?"

$customPropertyValue = Read-Host -Prompt $prompt3

Set-SwisObject -SwisConnection $swis -Uri $cpUri -Properties @{

	$customPropertyName = $customPropertyValue

}

Warning: that's untested but should give you the idea.