Forum Discussion

sivaponaka's avatar
sivaponaka
Copper Contributor
Dec 30, 2019

Unable to Pass variable value to For each loop

Hello Everyone,   I'm new to Poweshell, Someone tell what's wrong in below code? i want to pass $server value to for each loop but below code is failing     #getServerList $Servers = Invoke-Sql...
Power Shell
sql
oliwer_sundgren's avatar
oliwer_sundgren
Iron Contributor
Jan 07, 2020

Hello sivaponaka 

Sadly im no SQL expert. 

 

But, if you run "Write-output $server" do you get any output and does it look correct? 

 

Also, what error do you get when trying to run the code? 

 

Kind Regards
Oliwer Sjöberg

  • sivaponaka's avatar
    sivaponaka
    Copper Contributor
    Jan 07, 2020

    Thanks for your time oliwer_sundgren 

     

    My issue got resolved after adding parameterized property as below to code.

     

    foreach($Server in $Servers.server_name)

     

     

Resources