tak.Import-DHCPServerLog.ps1
|
function Import-DhcpServerLog { <# .SYNOPSIS Import DHCP Server Log files. .DESCRIPTION This function imports DHCP Server Log files from CSV format. .EXAMPLE PS C:\> Import-DhcpServerLog Import all logs found in the default log folder. .INPUTS <none> .OUTPUTS [psobject] .NOTES General notes #> [CmdletBinding()] param ( $Path = "C:\Windows\System32\dhcp", $Filter = "DhcpSrvLog*.log" ) process { $csvHeader = @('ID','Date','Time','Description','IP Address','Host Name','MAC Address','User Name','TransactionID','QResult','Probationtime','CorrelationID','Dhcid','VendorClass(Hex)','VendorClass(ASCII)','UserClass(Hex)','UserClass(ASCII)','RelayAgentInformation','DnsRegError') $Logs = Get-ChildItem -Path (Join-Path -Path $Path -ChildPath $Filter) $Logs | Select-String -Pattern "\d{2}," | Select-Object -ExpandProperty Line | ConvertFrom-Csv -Header $csvHeader } } |