Renaming bulk nodes

rodeyd

Hi,

I'm new at scripting for Solarwinds. I followed the script example Remove Domain and Capitalize Node Captions and modified for my needs. The script (below) works for a single node but doesn't for a bulk change. It is writing what it will be renaming and nothing happen.

I don't know what could be wrong.

Any help would be appreciated.

******************************************

$credential = Get-Credential
$swis = Connect-Swis -Hostname localhost -Cred $credential

$query = "
Select
caption, URI

From Orion.Nodes

Where Caption Like 'T5040PD-xxx.xx.%'
"
$result = Get-SwisData -SwisConnection $swis -Query $query

foreach ($node in $result) {

$newname = $node.Caption -replace "xxx.xx.",""

Write-Output " Renaming nodes $($node.Caption) to $newname " }

Set-SwisObject -SwisConnection $swis -Uri $node.URI -Properties @{ Caption = $newname }

sum_giais

Hi there @rodeyd ,

Looks like there was a curly brace in the wrong place at the end of the Write-Output, causing the foreach loop to end at that. Try this:

$credential = Get-Credential
$swis = Connect-Swis -Hostname localhost -Cred $credential

$query = @"
	SELECT
		 n.Caption
		,n.Uri
	FROM Orion.Nodes AS n
	WHERE n.Caption LIKE 'T5040PD-xxx.xx.%'


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

ForEach ($node in $result) {

	$newname = $node.Caption -replace "xxx.xx.",""

	Write-Output(" Renaming node '" + $node.Caption + "' to '" + $newname + "'")

	Set-SwisObject -SwisConnection $swis -Uri $node.Uri -Properties @{ Caption = $newname }

}