DHCP Log Parser

-
I am sharing the script which I had created long time back for parsing DHCP Logs. This script will pull out computer name and IP address details for each log files placed in "DHCPLogs" folder and save the result in .CSV file.


Steps:

1. Copy the script in notepad and save as "DHCPLogParser.vbs" or whatever you like.

2. Create a folder named "DHCPLogs" in script directory.

3. Copy all DHCP Logs with folders / subfolders in "DHCPLogs" folder

4. Run the script

5. Result will be saved in DHCPLog-Parsed.csv file.

Dim objCurrentFolder

Set objFso = CreateObject("Scripting.FileSystemObject")

Set objResult = objFso.CreateTextFile("DHCPLog-Parsed.csv")

CheckFolder objFso.GetFolder ("DHCPLogs")

WScript.Echo "Done !!!"


'#### Sub CheckFolder

Sub CheckFolder(objCurrentFolder)

For Each objFile In objCurrentFolder.Files

'WScript.Echo "Processing " & objFile.Path & " ...."

ParseLogFile objFile.path

Next

'Recurse through all of the folders

For Each objNewFolder In objCurrentFolder.subFolders

CheckFolder objNewFolder

Next

End Sub


'####Sub ParseLogFile

'Extract only those lines where computer name is present

Sub ParseLogFile(strFileName)

Set objStream = objFso.OpenTextFile(strFileName)

Do While Not objstream.AtEndOfStream

strText = objStream.ReadLine

txtArray = Split(strText,",")



If UBound(txtArray) =7 Then

If txtArray(5) <>"" Then

objResult.WriteLine strText

End If

End If

Loop

End Sub


Comments

Post a Comment

Popular posts from this blog

SCCM Software Distribution Troubleshooting

-
Image
1.    Content Monitoring and Validation from Console The below article provide details of content monitoring and validation from console. https://blogs.technet.microsoft.com/inside_osd/2011/04/06/configuration-manager-2012-content-monitoring-and-validation/ 2.    Reports SCCM reports should be the first thing to check the software deployment status. By looking into the report you can determine the scope of failure such as large scale failure, location based failure or client specific issues. A large scale failure may be caused by an issue with package or programe while issue can be related with specific client if deployment failure rate is low and limited to few clients. There are multiple reports available for each category.  All Software Distribution reports can be found in below folders under Monitoring > Reporting > reports. ·          Software Distribution – Collections · ...
Read more

Powershell - List AD Organizational Unit and GPOs linked to them

-
The below script will search Active Directory for all Organizational Unit which contain specific name and list them along with all Group Policies linked to those OUs. Example: The below command will get a list of all OUs which name contains 'Test'. It will also show the details of all GPOs linked to OUs. Usage Example: .\Get-OUList.ps1 –OUName “Test” #Script [ CmdletBinding () ] Param (   [ Parameter (Mandatory = $True ) ]   [ string ] $OUName   ) $invocation = ( Get-Variable MyInvocation ) . Value $directorypath = Split-Path $invocation . MyCommand . Path $outputfile = $directorypath + "\Result.csv" $OUName = "*" + $OUName + "*" $Results = @() $OUList = Get-ADOrganizationalUnit -Filter * | Where-Object -FilterScript { $PSItem . distinguishedname -like $OUName } foreach ( $OU in $OUList ){     $LinkedGPOs = Get-ADOrganizationalUnit -Identity $OU | select -Expa...
Read more

Troubleshooting System Center Endpoint Protection (SCEP) Client

-
Image
Microsoft System Center Endpoint Protection provides an antimalware and security solution for the Microsoft platform. This can be integrated with System Center Configuration Manager. I have consolidated the information which are useful for SCEP client side troubleshooting. 1. Managing Endpoint Protection client with Command Line Interface – MpCmdRun.exe The MpCmdRun.exe (Microsoft Antimalware service command line utility) is very useful tool to manage local Endpoint protection client with command line.  The MpCmdRun.exe is located in C:\Program Files\Microsoft Security Client folder. On Windows 10 machines, the MpCmdRun.exe is available in C:\Program Files\Windows Defender folder. When executed, this command automatically creates a log file named as MpCmdRun.log in C:\Users\ username\AppData\Local\Temp folder. This log file records the commands that are executed using MpCmdRun.exe. Few of most commonly used command lines are listed below. For a complete l list of av...
Read more