February 2, 2021 - Catapult - a Quisitive Company

Easy IIS log reading with PowerShell

infrastructureBy Chad Simmons February 2, 2021

This is just a bit of PowerShell to make reading and filtering IIS logs quick and easy.

Function Out-GridViewIISLog ($File) { 
   #.Synopsis 
   # Convert IIS log file to CSV and display in a GridView 
   #.LINK 
   # Based on https://stevenaskwith.com/2012/05/22/parse-iis-log-files-with-powershell/ 
   # Performance inspired by http://www.happysysadm.com/2014/10/reading-large-text-files-with-powershell.html 
   ########################################################################################################### 
   $Headers = @((Get-Content -Path $File -ReadCount 4 -TotalCount 4)[3].split(' ') | Where-Object { $_ -ne '#Fields:' });
   Import-Csv -Delimiter ' ' -Header $Headers -Path $File | Where-Object { $_.date -notlike '#*' } | Out-GridView -Title "IIS log: $File";
};
Out-GridViewIISLog -File "C:\InetPub\Logs\LogFiles\W3SVC1\u_ex$(Get-Date -F 'yyMMdd').log"

Function Out-GridViewIISLog ($File) {

#.Synopsis

# Convert IIS log file to CSV and display in a GridView

#.LINK

# Based on https://stevenaskwith.com/2012/05/22/parse-iis-log-files-with-powershell/

# Performance inspired by http://www.happysysadm.com/2014/10/reading-large-text-files-with-powershell.html

###########################################################################################################

$Headers = @((Get-Content -Path $File -ReadCount 4 -TotalCount 4)[3].split(' ') | Where-Object { $_ -ne '#Fields:' });

Import-Csv -Delimiter ' ' -Header $Headers -Path $File | Where-Object { $_.date -notlike '#*' } | Out-GridView -Title "IIS log: $File";

};

Out-GridViewIISLog -File "C:\InetPub\Logs\LogFiles\W3SVC1\u_ex$(Get-Date -F 'yyMMdd').log"

Get the latest version on GitHub.

Using ConfigMgr Compliance to Manage Security Configuration Baselines (Part 2)

infrastructureBy Phil Pritchett February 2, 2021

In part 1, we set the stage for the work we are about to do. We briefly went over the items that led up to our decisions. In the next parts, we’ll walk you through what we did. If you would like, you can go back and read Using ConfigMgr Compliance to Manage Security Configuration…

ConfigMgr Compliance to Manage Security Configuration Baselines blog

Using ConfigMgr Compliance to Manage Security Configuration Baselines (Part 1)

infrastructureBy Phil Pritchett February 2, 2021

You want me to do what? The alarm clock is screaming at me to get the heck out of bed. I snooze it twice, then finally get up. Once I’ve dressed, I cruise to the kitchen for some much needed coffee because I stayed up waaay too late the night before. After coffee, I walk…

SharePoint List JSON Form Formatting & Validations (3)

GeneralBy Catapult Systems February 2, 2021

In this video on SharePoint List JSON Form Formatting with JSON & Validations, we will walk through an end-to-end solution of customizing the Asset Manager Microsoft Lists /SharePoint lists template with the new form formatting JSON options, applying clickable actions in the Header JSON, adding conditional validations and adding the List Form to a…

Daily Archives: February 2, 2021

Easy IIS log reading with PowerShell

Using ConfigMgr Compliance to Manage Security Configuration Baselines (Part 2)

Using ConfigMgr Compliance to Manage Security Configuration Baselines (Part 1)

SharePoint List JSON Form Formatting & Validations (3)