Run script on servers imported from csv

flynnkeilty1382 · 2018-03-08T16:42:37.000Z

Greetings,

I am trying to run a script (by Ben H) that verifies if a server has a dhcp reservation. I’ve tried numerous tweaks to the script below but I cannot get it to run against the imported servers in the .csv It runs against the local machine. Any help would be appreciated.

Thanks,

Flynn

$reserve = import-csv -path “c:\scripts\reservationinfo.csv”
$reserve | ForEach {
$Servers = $.Servers
$NetAdapters = foreach ( $i in (Get-WmiObject Win32_NetworkAdapterConfiguration -Computername $Servers) | ? {$.DHCPEnabled -eq $True -and $null -ne $.IPAddress} ) { $i.ipaddress[0] }
}
If ($NetAdapters) {
Foreach ($Adapter in $NetAdapters) {
foreach ($ip in $i.ipaddress[0]) {
$Reservation = Get-DhcpServerv4Reservation -ScopeId $IP -ComputerName dhcpserver | ? {$.ScopeId -eq $_.IPAddress}
If ($Reservation) {
Write-Output “$IP is reserved.”
} Else {
Write-Output “$IP does not have a reservation.”
}
}
}
}Else {
Write-Output “No DHCP Enabled NetAdapters with IPAddresses exist on host, likely Static”
}

Neally · 2018-03-08T16:49:52.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

What happens when you run it? Do you get an error? What does the CSV look like?

jitensh · 2018-03-08T17:11:15.000Z

Not tested borrowed from networking - How to Verify Reserved IP with Powershell - Stack Overflow

$computers = import-csv -path "c:\scripts\reservationinfo.csv"
Foreach($computer in $computers){
$NetAdapters = Get-WmiObject Win32_NetworkAdapterConfiguration -ComputerName $computer | ? {$_.DHCPEnabled -eq $True -and $null -ne $_.IPAddress}
If ($NetAdapters) {
    Foreach ($Adapter in $NetAdapters) {
        foreach ($IP in $Adapter.IPAddress) {
            $Reservation = Get-DhcpServerv4Reservation -ScopeId $IP -ComputerName $Adapter.DHCPServer | ? {$_.ScopeId -eq $_.IPAddress}
            If ($Reservation) {
                Write-Output "$IP is reserved on $($Adapter.DHCPServer)."
            } Else {
                Write-Output "$IP does not have a reservation."
            }
        }
    }
} Else {
    Write-Output "No DHCP Enabled NetAdapters with IPAddresses exist on host, likely Static"
}
}

DoctorDNS · 2018-03-08T19:18:21.000Z

What does the CSV file look like?

A couple of points:

Instead of:

$reserve = import-csv -path "c:\scripts\reservationinfo.csv"
$reserve | ForEach {

try

$reserves = import-csv -path "c:\scripts\reservationinfo.csv"
Foreach ($reserve in $Reserves) {

Then within the later code, you’d replace $_. with $Reserve.

The code:

$reserve | ForEach {
$Servers = $_.Servers

makes me wonder what the CSV file looks like. Normally, I’d have expected $Server=$_.Server where the value of the server property comes from a line in the CSV.

flynnkeilty1382 · 2018-03-09T19:04:52.000Z

TFL,

Thank you for your reply. I’ve tried that and I receive the error: ‘The rpc server is not available’ in regards to the $netadapters variable. (I know that it is not an rpc issue, and seems to be related to where the script is looking when putting a variable related to the .csv next to the -computername parameter)

The .csv looks like this:

Servers

server5

server6

It seems like the -computername parameter or the variables on the other side of the pipe in the $netadapters variable are unable to use the data in the .csv.

When I run get-variable it only shows the bottom server next to $reserve.

When I remove the .csv and add an actual servername next to -computername, it runs fine on different servers:

$NetAdapters = foreach ( $i in (Get-WmiObject Win32_NetworkAdapterConfiguration -Computername actualservername) | ? {$_.DHCPEnabled -eq $True -and $null -ne $_.IPAddress} ) { $i.ipaddress[0] } 

If ($NetAdapters) { 
Foreach ($Adapter in $NetAdapters) {
        foreach ($ip in $i.ipaddress[0]) {
            $Reservation = Get-DhcpServerv4Reservation -ScopeId $IP -ComputerName coadhcp | ? {$_.ScopeId -eq $_.IPAddress} 
            If ($Reservation) {
                Write-Output "$IP is reserved."
            } Else {
                Write-Output "$IP does not have a reservation."
            }
        }
    }
}Else {
    Write-Output "No DHCP Enabled NetAdapters with IPAddresses exist on host, likely Static"
}

bitcat · 2018-03-14T01:42:19.000Z

$NetAdapters = Get-WmiObject Win32_NetworkAdapterConfiguration -ComputerName $computer

variable “$computer” contain CVS unit, yes?

THEN we MUST use “-ComputerName $computer.Servers” for give string with “serverName” and “it runs fine on different servers”