powershell use CSV to create variables

Question

I am a total novice when it comes to powershell. I would like to create a little script to save me a lot of time and after a little research, I am sure it can be achieved using Import-CSV command.

Basically I need to run a command on multiple PC's but the variable is different for each command. I wish to pull that variable from a comparision in a CSV file. So find current Hostname, then use that hostname to find the corresponding asset number in the CSV and then use that asset number as a variable in the final comamnd.

Looking at other examples on here, I have this so far:

$Asset = @()
$Host = @()

Import-Csv -Path "C:\hostnametoasset.csv" |`
ForEach-Object {
    $Asset += $_.Asset
    $Host += $_.Host
}

$Hostname = (Get-WmiObject -Class Win32_ComputerSystem -Property Name).Name

if ($Host -contains $Hostname)
{
C:\BiosConfigUtility64.exe /setvalue:"Asset Tracking Number","$Asset"
}

Section of the CSV:

Asset,Host
10756,PCD001
10324,PCD002
10620,PCD003

Any help would be greatly appreciated.

1. Don't use $Host as a variable name (it's a built-in variable). 2. You're not using any host name in the BIOS utility configuration command, so it's not clear why you need a host name in the first place. — Bill_Stewart
– Bill_Stewart, Commented Aug 8, 2018 at 20:06
yes I swapped $Host to $Name and updated my CSV. The host name is needed for comparision in the CSV to return the asset number — Kevin
– Kevin, Commented Aug 9, 2018 at 11:44

MisterSeajay · Accepted Answer · 2018-08-08 23:35:09Z

3

Couple of different points... Importing a CSV results in an array of objects that you can filter on.

$Lines = Import-Csv -Path "C:\hostnametoasset.csv"
$Line = $Lines | ?{$_.host -match $ENV:COMPUTERNAME}

You can then use the filter results directly by accessing the member you need.

C:\BiosConfigUtility64.exe /setvalue:"Asset Tracking Number","$($Line.Asset)"

NOTE: I cannot test this directly right now so hopefully I got the syntax right.

edited Aug 8, 2018 at 23:35

MisterSeajay

4,7891 gold badge28 silver badges53 bronze badges

answered Aug 8, 2018 at 20:27

WayneA

3391 silver badge7 bronze badges

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

1 Comment

Kevin Over a year ago

thanks very much. the final script looks like this:

$csv = Import-Csv -Path "\\lsqus009\HPSSM\BCU\hostnametoasset.csv" $Line = $csv | ?{$_.Name -match $ENV:COMPUTERNAME} \\lsqus009\HPSSM\BCU\BiosConfigUtility64.exe /setvalue:"Asset Tracking Number","$($Line.Asset)"

and it works beautifully

Collectives™ on Stack Overflow

powershell use CSV to create variables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related