How can I use input file to feed powershell command?

Question

I have a csv file with the following info (for readibility I removed commas) :

box1    1.1.1.1     user        password
box2    2.2.2.2     user        password
box3    3.3.3.3     user        password

I need to execute command with parameters from the csv file, like below :

plink -l user -pw password 1.1.1.1 lsvdisk -delim , -nohdr

and feed a file, with the box name on the start of each line.

In other words, I have ~300 storage boxes (V7k/SVC) and I need an inventory of all the UUID of LUNs. Preferably powershell.

Joey · Accepted Answer · 2019-02-06 08:35:55Z

1

Import-Csv and ForEach-Object are your friend here:

Import-Csv -Header Host,Ip,User,Pw foo.csv | ForEach-Object {
  plink -l $_.User -pw $_.Pw $_.Ip lsvdisk -delim ',' -nohdr
}

Note that we have to enclose the , in quotes to ensure it's passed as a single parameter.¹

Within the script block of ForEach-Object $_ is the current object, which has the properties from the CSV file. We had to give the import custom headers since your file apparently doesn't have any. If that's not how your file looks, then adjust accordingly.

This will give you lots of output, of which perhaps the host name is no longer available. Depending on how the output looks, it may make sense to parse it and wrap it up into nice objects, but I don't really know how the output looks. A simple way of simply capturing output and associating it with the host name would be the following:

Import-Csv -Header Host,Ip,User,Pw foo.csv | ForEach-Object {
  $output = plink -l $_.User -pw $_.Pw $_.Ip lsvdisk -delim ',' -nohdr
  New-Object PSObject -Property @{
    Host = $_.Host
    Output = $output
  }
}

To prefix each line of the output with the host name you can loop over the output again:

Import-Csv -Header Host,Ip,User,Pw foo.csv | ForEach-Object {
  $host = $_.Host
  plink -l $_.User -pw $_.Pw $_.Ip lsvdisk -delim ',' -nohdr | ForEach-Object {
    "${host}: $_"
  }
}

¹ If the command line includes lots of things that PowerShell wants to interpret itself, it's often easier to use %-- to stop parsing for the rest of the line after that, which then passes the rest verbatim to external commands.

edited Feb 6, 2019 at 8:35

answered Feb 5, 2019 at 20:17

Joey

357k88 gold badges704 silver badges699 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jon Markopoulos Over a year ago

The output of the command lsvdisk -delim : -nohdr is something like that : 0:vdisk0:0:io_grp0:degraded:0:mdiskgrp0:10.00GB:striped:::::60050768018300003000000000000000:0:1:empty:0:no:0:1:VDisk1:aux_change 1:vdisk2:0:io_grp0:degraded:0:mdiskgrp0:10.00GB:striped:::::60050768018300003000000000000001:0:1:empty:0:no:0:1:VDisk1:aux_change 2:vdisk2:0:io_grp0:degraded:0:mdiskgrp0:10.00GB:striped:::::60050768018300003000000000000002:0:1:empty:0:no:0:1:VDisk1:aux_change Can I add in the start of each line the name of each box ? Thanks for your elegant answer...

Joey Over a year ago

@JonMarkopoulos: See the edit. Basically it's all the same thing in PowerShell: Add parts to the pipeline :)

Collectives™ on Stack Overflow

How can I use input file to feed powershell command?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related