not getting expected output while putting node in maintenance mode via powershell (SDK)

smahamulkar

Hello Expert ,

i am trying to put the nodes in maintenance mode with the help of power shell , i want to take inputs (node name , from time , to time ) from user. 

i have wrote below script for the same. i am always getting last server information  , however for first and second i am not getting DB values (Uri)

function mutealert
{

Import-Module SwisPowerShell
#$creds = Get-Credential
$swis = Connect-Swis -Hostname 10.10.10.10 -Username username\username  -Password Pass@1234

$hostname=$textBox.Text.Split("`n")

foreach($server in $hostname )
{

Write-Host "----------------- DB query-----------"
[String]$strQuery = "SELECT uri FROM Orion.Nodes WHERE SysName LIKE '" + "$server" + "%'"
Write-Host $strQuery

Write-Host "----------------- DB values-----------"
$uris = Get-SwisData $swis $strQuery
Write-Host $uris

}
}

output---

----------------- DB query-----------
SELECT uri FROM Orion.Nodes WHERE SysName LIKE 'Server-01%'
----------------- DB values-----------

----------------- DB query-----------
SELECT uri FROM Orion.Nodes WHERE SysName LIKE 'Server-02%'
----------------- DB values-----------

----------------- DB query-----------
SELECT uri FROM Orion.Nodes WHERE SysName LIKE 'Server-03%'
----------------- DB values-----------
swis://solarwinds.solarwind.com/Orion/Orion.Nodes/NodeID=170

can someone help me to sort out this issue.

KMSigma.SWI

There are a couple of things:

1. PowerShell functions should be in Verb-Noun naming format and the "Verb" should be one of the 'allowed' PowerShell verbs.  This is not critical right now, but newer versions of PowerShell may block them and you'll want to do this as a best practice.
2. You are trying to run a ForEach on the entries in $Hostname, but the $Hostname variable is never defined in this function, nor is it part of the parameters accepted.  (Technically, you have not defined any parameters in this function, so I can't see how that has the proper data.
3. You are using the Write-Host function which is "ok" but you shouldn't rely on it for valid outputs.  If anything, you should just output the object ( $strQuery instead of Write-Host $strQuery).  They are handled by different parts of the scripting engine and treated differently for processing.  Sometimes Write-Host outputs get lost.

Also, if you are posting code samples on THWACK, please use the Insert Code option in the editor.  It makes it much more readable on the site.