SQL – Log Parser Studio

Posted on By David Kittell

Log Parser Studio is a great free tool from Microsoft TechNet Gallery that allows you to run SQL statements against Log files.

This tool is available as a Zip file, once extracted open “LPS.exe”.

Load Log File(s)
Load Log File(s)

Two examples are below but there is also a category (Code – SQL – Log Parser Studio) for more detailed queries.

SELECT TOP 10 [LogFilename]
	,[c-ip]
	,[date]
	,[time]
	,[cs-uri-stem]
	,[time-taken]
	,[sc-status]
FROM '[LOGFILEPATH]'

SELECT TOP 25  
    STRCAT(TO_STRING(sc-status),  
    STRCAT('.', TO_STRING(sc-substatus))) As Status,  
    COUNT(*) AS Hits  
    FROM '[LOGFILEPATH]'  
GROUP BY Status  
ORDER BY Hits DESC
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Log Parser Studio SQL

Related Posts

WordPress – List All Plugins

Posted on

Place the following code on a file ex. ListAllPlugins.php and then navigate to http://yourdomain.com/ListAllPlugins.php <?PHP require($_SERVER[’DOCUMENT_ROOT’] . "/wp-load.php"); require($_SERVER[’DOCUMENT_ROOT’] . "/wp-admin/includes/plugin.php"); function PrintPluginList($option) { $all_plugins = get_plugins(); if ($option == 1) { print_r(array_values($all_plugins)); } else { echo json_encode($all_plugins); } } PrintPluginList($_GET[’op’]); ?> This is a PowerShell script to automate some…

Read More

PowerShell – Find a file

Posted on

If you run into a need to find a file on your computer/server this script should help make things a bit easier Get-ChildItem -Path f:\ -Filter 2019-10-07.log -Recurse -ErrorAction SilentlyContinue -Force Function Format-FileSize() { Param ([int]$size) If ($size -gt 1TB) { [string]::Format("{0:0.00} TB", $size / 1TB) } ElseIf ($size -gt…

Read More

Mac OSX – Terminal – Read JSON From cURL

Posted on

Prerequisite: OSX Homebrew brew update brew prune brew install node brew upgrade node sudo curl -L https://npmjs.com/install.sh | sh npm update -g npm install -g json brew install python pip install pygments curl -s https://www.kittell.net/tools/jsonexample.php | json | pygmentize -l json curl -s –header "PRIVATE-TOKEN: <private token>" "http://127.0.0.1/api/v3/projects" | json…

Read More