☰

Vergleichen von 2 CSV-Dateien in Powershell und Exportieren der Unterschiede in eine andere Datei

tag-icon • tag-icon powershell scripting reverse-dns csv
Vergleichen von 2 CSV-Dateien in Powershell und Exportieren der Unterschiede in eine andere Datei

Ich habe dieses Skript geschrieben und könnte schwören, dass es mir heute früh die Meldung „Fehlgeschlagen“ angezeigt hat, aber jetzt bekomme ich nichts und weiß nicht, warum.

Im Grunde muss ich die Unterschiede zwischen den Dateien vergleichen und in eine andere CSV-Datei exportieren. Für jede Hilfe zum Abrufen der Ausgabedatei wäre ich dankbar. Oder eine bessere Möglichkeit zum Vergleichen als das Cmdlet „Compare-Object“ wäre großartig. Danke $SourceAddress.$OutputAddress

###########################################################
#
# Douglas Francis
# DNS Audit Script
# V 1.2
# Date: 05/06/2014
#
# Pulls IP address from a text file. Parses the IP's in the text file for their DNS entry and exports to a CSV file. 
# For IP address' that do not resolve get parsed to a new file.
#
#
###########################################################

#This creates an ouput folder called Script_Results to put the results in.

    $CheckFolder = Test-Path -PathType Container Script_Results
    if($CheckFolder -eq $false)
    {
        New-Item 'Script_Results' -Type Directory
    }



#This gets the IP address' from the file

    $IPADDR = Get-Content "C:\Users\douglasfrancis\Desktop\IP_test.txt"



#This logic runs through each line in the text file to get the IP's perform a reverse DNS search and pulls the IP and hostname to be outputted and sorted later. It also ignores the errors from failed results

    $SortIP =@()
    ForEach ($IPADDR in $IPADDR)
    {
        $ErrorActionPreference = "SilentlyContinue"
        $SortIP += [System.Net.DNS]::GetHostbyAddress($IPADDR)  | Add-Member -Name IP -Value $IPADDR -MemberType NoteProperty -PassThru | Select Hostname, IP 
    }



#Running through the data from $SortIP sorts by hostname and exports to CSV

    $SortIP | Sort -Property Hostname | Export-Csv     "C:\Users\douglasfrancis\Desktop\Script_Results\ReverseLookup.csv" -NoTypeInformation



#Here we start to work some voodoo magic. Instead of attempting to parse the errors from the failed DNS results we're going to compare the orginal IP address txt file to the output file of the DNS
#By comparing those two files we can determine what files failed to resolve a DNS and output that to a file for review.

    #Here we're reimporting the exported CSV file of the DNS results. Pulling the IP address column from it and then exporting it again with only the IP info.
    Import-csv "C:\Users\douglasfrancis\Desktop\Script_Results\ReverseLookup.csv" | Select IP | Export-csv -Path "C:\Users\douglasfrancis\Desktop\Script_Results\OutputAddress.csv" -NoTypeInformation

    #Now for some futher voodoo data manipulation. Going to take the source IP address file import it back in as a CSV file with a IP column header.
    # After that we will then reexport it back again as a CSV file so a comparision can be done between the two files.
    Import-csv "C:\Users\douglasfrancis\Desktop\IP_Test.txt" -Header "IP" | Export-csv -Path "C:\Users\douglasfrancis\Desktop\Script_Results\InputAddress.csv" -NoTypeInformation

    #Alright just a bit more voodoo for some more data manipulation. Going to take those parsed data files from above and assign them to a var for further magic
    $OutputAddress = Import-csv "C:\Users\douglasfrancis\Desktop\Script_Results\OutputAddress.csv" -NoTypeInformation
    $SourceAddress = Import-csv "C:\Users\douglasfrancis\Desktop\Script_Results\InputAddress.csv" -NoTypeInformation


#Finally here we make use of all the voodo magic and do a comparison of data so we can find out what IP's failed to resolve via DNS and export that to the failed file.

    Compare-Object $OutputAddress $SourceAddress | Select InputObject | Export-csv "C:\Users\douglasfrancis\Desktop\Script_Results\ReverseLookup_failed.csv" -NoTypeInformation



#Alrighty, one final thing to do some housecleaning and we're outta here!

    Remove-Item "C:\Users\douglasfrancis\Desktop\Script_Results\InputAddress.csv"
    Remove-Item "C:\Users\douglasfrancis\Desktop\Script_Results\OutputAddress.csv"

Antwort1

Wurde zum Try/Catch weitergeleitet, das die von mir benötigte Fehlerbehandlung durchführt, dies behebt das Problem.

Try {
             [System.Net.DNS]::GetHostbyAddress($IPADDR)  | 
              Select Hostname,@{label='IP';expression={$IPADDR}} 
            }

        Catch {
               Add-Content -Value "$IPADDR failed lookup" -Path     "C:\Users\douglasfrancis\Desktop\Script_Results\ReverseLookup_failed.csv" 
              }

verwandte Informationen