Myujth

I am working on getting a script together that will tell me every binding on a server and what live IPv4 address that binding resolves to. I am very close, but because I am exporting my results from IIS to CSV and then running Test-connection on each binding from that CSV, I'm having trouble adding the results to an array and exporting the finished results to a CSV file. Here is the script:

Import-Module WebAdministration
$hostname = hostname
$Websites = Get-ChildItem IIS:Sites
$date = (Get-Date).ToString('MMddyyyy')
foreach ($Site in $Websites) select-object Value
 Do
 if( $Bindings[($i)] -notlike "sslFlags=*") Add-member Path $site.physicalPath
 $obj 
 else$i=$i+1
 while ($i -lt ($bindings.count))


$CSVvar = import-csv "c:temp$date-$hostname.csv"
$i=0
foreach ($v in $CSVvar)
If ($v.Header -ne '') 
$result = Test-Connection $v.Header -ErrorAction SilentlyContinue
if ($result) 
 $IP = ($result.IPV4Address).IPAddressToString
 echo $IP
 $v.ResolveAddress = $IP



$CSVvar | export-csv "c:temp$date-$hostname.csv" -Append -notypeinformation

I am thinking it would be best to ping each binding before the CSV file is exported the first time, but I can't figure out a way to get it to try each element of the Header object individually, and I keep crashing the script that way. If I can get the IP address(es) to save back to the $CSVvar.ResolveAddress column, that would be fine by me. Any help is appreciated!

That seems like a lot of code, just to do this. How about this approach.

### Get website info

Import-Module -Name WebAdministration
Get-Website | select name,id,state,physicalpath,
@n="Host"; e= $env:COMPUTERNAME ,
@n="Bindings"; e= select -expa collection) -join ';' ,
@n="LogFile";e= select -expa directory, 
@n="attributes"; e=($_.attributes , 
@n="ConnectionTest"; e=:')[1] -Count 1 -Quiet) | 
Export-Csv -NoTypeInformation -Path 'C:tempmy_list.csv'

Import-Csv -Path 'C:tempmy_list.csv'

# Results

name : Default Web Site
id : 1
state : Started
physicalPath : %SystemDrive%inetpubwwwroot
Host : IIS01
Bindings : http *:80:;https *:443: sslFlags=0
LogFile : %SystemDrive%inetpublogsLogFiles
attributes : name=Default Web Site;id=1;serverAutoStart=True;state=1
ConnectionTest : True

name : kcd
id : 2
state : Started
physicalPath : C:inetpubkcd
Host : IIS01
Bindings : http 192.168.7.11:80:kcd.contoso.com
LogFile : %SystemDrive%inetpublogsLogFiles
attributes : name=kcd;id=2;serverAutoStart=True;state=1
ConnectionTest : True

Of course one could break out / cherry pick all the other collected pieces / info into separate calculated properties as needed.

Update for OP

... but really all I'm having trouble with is getting the IPv4 info from
the ConnectionTest response appended to the original document ...

Just use the same code I used for the Test-Connection.

Import-Module -Name WebAdministration
Get-Website | select name,id,state,physicalpath,
@n="Host"; e= $env:COMPUTERNAME ,
@n="Bindings"; e= select -expa collection) -join ';' ,
@n="LogFile";e= select -expa directory, 
@n="attributes"; e=($_.attributes , 
@n="ConnectionTest"; e=:')[1] -Count 1 -Quiet),
@n="SiteIPA"; e=($Bindings -split 'http