Loop Powershell with two corresponding variables

Question

Loop Powershell with two corresponding variables

Anthony Kirit 21

I have a powershell set of commands listed below. This works great for one nic and it's associatedone public IP. I need to make it work for a set from csv, shown below.

I'm new to this and am not sure how to loop through, with foreach I would imagine.

$vnet = Get-AzVirtualNetwork -Name WestUS2vnet -ResourceGroupName WestUS
$subnet = Get-AzVirtualNetworkSubnetConfig -Name Desktops -VirtualNetwork $vnet
$publicIP = Get-AzPublicIpAddress -name WT1 -ResourceGroupName WVDARM
$nic = Get-AzNetworkInterface -Name WVD-1-nic -ResourceGroupName WVDARM
$nic | Set-AzNetworkInterfaceIpConfig -Name ipconfig -Subnet $subnet -Primary -PublicIpAddress $publicIP
$nic | Set-AzNetworkInterface

This associates the pip WT1 to the nic WVD-1-nic. Below is a CSV for 27 pips and 27 nics. I need to assign the pips to the corresponding nics.

Your help is greatly appreciated

Anthony Kirit 21 Reputation points

2021-06-28T16:03:07.623+00:00

So I basically need to do this with a loop

Set WT0 to WVD-0-nic
Then set WT1 to WVD-1-nic
Then set WT2 to WVD-2-nic

And so on to the end ....

Accepted answer

0 additional answers

Your answer

Anthony Kirit 21 Reputation points

2021-06-28T16:03:07.623+00:00

So I basically need to do this with a loop

Set WT0 to WVD-0-nic
Then set WT1 to WVD-1-nic
Then set WT2 to WVD-2-nic

And so on to the end ....

Answer 1

Rich Matheisen 47,901

So, something like this?

Import-Csv c:\junk\wt.csv |
    ForEach-Object{
        Write-Host "Do something with " $_.NAME " and " $_.NIC
    }

Anthony Kirit 21 Reputation points

2021-06-28T20:23:32.247+00:00

Thank you for your answer. I am not sure of the order or syntax. I tried this but it did not work.

Import-Csv c:\PS\pips.csv |
ForEach-Object{
Write-Host $vnet = Get-AzVirtualNetwork -Name WestUS2vnet -ResourceGroupName WestUS
$subnet = Get-AzVirtualNetworkSubnetConfig -Name Desktops -VirtualNetwork $vnet
$publicIP = Get-AzPublicIpAddress -name $.Nic -ResourceGroupName WVDARM
$nic = Get-AzNetworkInterface -Name $.Name -ResourceGroupName WVDARM
$nic | Set-AzNetworkInterfaceIpConfig -Name ipconfig -Subnet $subnet -Primary -PublicIpAddress $publicIP
$nic | Set-AzNetworkInterface
}

I am sure where to refer to the cs column headers
Anthony Kirit 21 Reputation points

2021-06-28T20:54:13.803+00:00

Nevermind.

I wrote the wrong header name to the wrong spot. It should have been and now it works.

Import-Csv c:\PS\pips.csv |
ForEach-Object{
Write-Host $vnet = Get-AzVirtualNetwork -Name WestUS2vnet -ResourceGroupName WestUS
$subnet = Get-AzVirtualNetworkSubnetConfig -Name Desktops -VirtualNetwork $vnet
$publicIP = Get-AzPublicIpAddress -name $.Name -ResourceGroupName WVDARM
$nic = Get-AzNetworkInterface -Name $.Nic -ResourceGroupName WVDARM
$nic | Set-AzNetworkInterfaceIpConfig -Name ipconfig -Subnet $subnet -Primary -PublicIpAddress $publicIP
$nic | Set-AzNetworkInterface
}
Rich Matheisen 47,901 Reputation points

2021-06-28T21:48:25.727+00:00

Are you sure you want that "Write-Host" there? (immediately after the "ForEach-Object" in you post)

FYI, using the "Code Sample" when posting code makes things much clearer -- and removes this forums editor's annoying habit of turning "<dollar-sign><underscore><period>" character sequences into a "<dollar-sign><period>" sequence. :-)
Anthony Kirit 21 Reputation points

2021-06-28T23:13:21.457+00:00

Why would I not want the write host? I did it that way and it worked. And I will use the Code Sample.

Is there a better way instead of Write-Host?
Rich Matheisen 47,901 Reputation points

2021-06-29T01:23:11.707+00:00

It doesn't harm anything, but isn't it just writing the same information as many times as there are data rows in the CSV?
Anthony Kirit 21 Reputation points

2021-06-29T02:57:21.623+00:00

Ok, thank you.

Share via

Loop Powershell with two corresponding variables

0 additional answers

Your answer