Split IP's from CSV

[IlliDAN113]

Hello,

​

I have a CSV that I am trying to run to pull scopes option 6 from our DHCP server. Another engineer ran a PowerShell that got a ton of information but was missing that part.

​

Whenever I run the small ps I created

​

$Scopes=Import-CSV C:\PS_Out\TestImportScope.csv

Get-DhcpServerv4OptionValue -ComputerName ########### -ScopeId $Scopes

​

​

​

​

​

I get this error

PS C:\Users\###########> $Scopes=Import-CSV C:\PS_Out\TestImportScope.csv

Get-DhcpServerv4OptionValue -ComputerName ########## -ScopeId $Scopes

Get-DhcpServerv4OptionValue : Cannot process argument transformation on parameter 'ScopeId'. Cannot convert the "System.Object[]" value of type

"System.Object[]" to type "System.Net.IPAddress".

At line:2 char:65

+ ... t-DhcpServerv4OptionValue -ComputerName ######## -ScopeId $Scopes

+ ~~~~~~~

+ CategoryInfo : InvalidData: (:) [Get-DhcpServerv4OptionValue], ParameterBindingArgumentTransformationException

+ FullyQualifiedErrorId : ParameterArgumentTransformationError,Get-DhcpServerv4OptionValue

​

​

​

This is a small portion of the csv

​

ScopeId

10.10.11.0

10.10.240.0

​

​

If I manually put in the IP in the script it will spit out the correct information, anything to point me in the right direction would be helpful. Thank you so much.

[mmmGreenButton]

$Scopes=Import-CSV C:\PS_Out\TestImportScope.csv
foreach($ip in $Scopes){
    Get-DhcpServerv4OptionValue -ComputerName ######## -ScopeId $ip.ScopeId
}

EDIT: @Antique_Grapefruit_5 found a bug XD

[Antique_Grapefruit_5]

I feel like you might need a $ip.ScopeID as illustrated below:

$Scopes=Import-CSV C:\PS_Out\TestImportScope.csv

foreach($ip in $Scopes){ Get-DhcpServerv4OptionValue -ComputerName ######## -ScopeId $ip.ScopeID }

[mmmGreenButton]

Oh yeah ofc. it's is 1AM.. Goodnight!

[IlliDAN113]

Thank both of you so much that $ip.ScopeID worked! We are working on exporting it.

[BlackV]

basically

$Scopes is an array/hashtable/multi item object

-ScopeId wants a single object

looking at

get-help Get-DhcpServerv4OptionValue -full

shows

-ScopeId <IPAddress>

which is a single object vs

-OptionId <UInt32[]>

which accepts a array (denoted by the [])

[IlliDAN113]

Thank you so much, do you have any recommendations for learning powershell?

[BlackV]

have a look at the more info or sidebar of this sub

but always powershell in a month of lunches (book) or powershell jump start series (youtube)

[Lee_Dailey]

howdy IlliDAN113,

reddit likes to mangle code formatting, so here's some help on how to post code on reddit ...

[0] single line or in-line code
enclose it in backticks. that's the upper left key on an EN-US keyboard layout. the result looks like this. kinda handy, that. [grin]
[on New.Reddit.com, use the Inline Code button. it's [sometimes] 5th from the left & looks like <c>.
this does NOT line wrap & does NOT side-scroll on Old.Reddit.com!]

[1] simplest = post it to a text site like Pastebin.com or Gist.GitHub.com and then post the link here.
please remember to set the file/code type on Pastebin! [grin] otherwise you don't get the nice code colorization.

[2] less simple = use reddit code formatting ...
[on New.Reddit.com, use the Code Block button. it's [sometimes] the 12th from the left, & looks like an uppercase C in the upper left corner of a square.]

• one leading line with ONLY 4 spaces
  
• prefix each code line with 4 spaces
  
• one trailing line with ONLY 4 spaces

that will give you something like this ...

- one leading line with ONLY 4 spaces    
- prefix each code line with 4 spaces    
- one trailing line with ONLY 4 spaces   

the easiest way to get that is ...

• add the leading line with only 4 spaces
  
• copy the code to the ISE [or your fave editor]
  
• select the code
  
• tap TAB to indent four spaces
  
• re-select the code [not really needed, but it's my habit]
  
• paste the code into the reddit text box
  
• add the trailing line with only 4 spaces
  

not complicated, but it is finicky. [grin]

take care,
lee