Powershell logparse regexp to csv

Input line: Thu 2017-03-30 00:00:07: user@domain.com (John Doe) checked mail from using IMAP, 0 msgs collected, 21 remaining Powershell script: $rxp = “([a-z0-9!#\$%&’*+/=?^_`{|}~-]+(?:\.[a-z0-9!#\$%&’*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)|(\b\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}\b)|(POP|IMAP)|(^[A-Z][a-z]+\s\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2})” gc “.\*.log” | select-string -pattern $rxp -allmatches | foreach { if ($_.Matches.count -ne 4) { return } [pscustomobject]@{ ‘date’=$_.Matches[0] ’email’=$_.Matches[1] ‘ipaddr’=$_.Matches[2] ‘proto’=$_.Matches[3] } } | export-csv -notype analysis.csv

Read article / April 19th, 2017

SQL2008R2 Licensing Quick Reference updated (PDF)


Read article / February 17th, 2017

GPO Disable Password Expiration or Password Complexity

Big Fat Warning:  Don’t do this. How to disable password expiration Load Local Group Policy Editor (Start –> Type gpedit.msc –> Enter) Expand sections: Local Computer Policy –> Computer Configuration –> Windows Settings –> Security Settings –> Account Policies –> Password Policy Set Maximum password age to 0 to completely disable passwords from expiring. How to disable […]

Read article / February 6th, 2017

Warning, DHCP pool range is limited to 128 addresses

For all ASA models, the maximum number of DHCP client addresses varies depending on the license: If the limit is 10 hosts, the maximum available DHCP pool is 32 addresses. If the limit is 50 hosts, the maximum available DHCP pool is 128 addresses. If the number of hosts is unlimited, the maximum available DHCP […]

Read article / February 6th, 2017

SQL Server 2016 SP1 Edition Limit Changes

Microsoft made the following changes in their documentation (see screenshot above) to accurately reflect the memory limits on lower editions of SQL Server. Edition Information:  https://www.microsoft.com/en-us/sql-server/sql-server-editions Estimate Memory Requirements for Memory-Optimized Tables Key Points The limits for In-Memory OLTP data is per database. The limits for Columnstore segment cache is per SQL Server instance across all the […]

Read article / February 2nd, 2017

My Notes and Benchmarks on VMware Flash Read Cache

I’ve spent some time exploring and studying the use and configuration of VMware Flash Read Cache (vFRC) and its benefits.  These are my notes. Useful Resources VMware Flash Read Cache 1.0 FAQ vSphere 5.5 Flash Read Cache Documentation On a guest virtual machine, vFRC is configured in Disk configuration area.  The virtual machine needs to […]

Read article / February 2nd, 2017