- Auto Logon to a Workstation on a Windows Domain
- Batch Script – Get User’s SID One-Liner
- Batch Script – Parse MS Exchange IIS Log File, Filter All External Requests, and Email It
- Batch Script – RDS Start Menu Application and Taskbar Shortcut Removal Tool
- Batch Script – Ribbon UI Customization: Take Ownership and Change Permissions of the CommandStore Subkeys in the Registry
- Batch Script – Sending Items to the Recycle Bin Without Calling Any Third-Party Applications
- Batch Script – Zip/Compress Files Without Calling Any Third-Party Applications
- Batch Script – How to Check if the Current User is a Member of a Group
- Cannot Log onto Windows – Trust Relationship Failed
- Cisco VPN Client Won’t Connect on Windows 7 x64 via 3g Modem
- Classic Shell – Pin Items to the Classic Start Menu via Group Policy
- Classic Shell – Registry Entries for Custom Windows 7 Style Start Menu
- Classic Shell – Remove First Run Wizard with Group Policy
- Configure NTP Peers for Windows Time Service
- CryptoWall 3.0 Ransomware – Ouch, It Hurts So Good…Get Out the Backup Tapes. You’ve Got Those Right?
- Enable Clock via Group Policy on a Terminal Server
- Exchange 2010 – Add Send As Permission for All Users/Future Users from a User Account
- Exchange 2010 OWA – Can’t Delete Messages
- Exchange 2010 OWA – Mailbox is Disabled
- Exchange 2010 OWA – Outgoing Attachments Not Visible in Compose New Message Window
- Exchange 2010 OWA – Remove Cached Email Recipients/Auto Complete Entries
- Exchange Server 2010 – Changing Message Tracking Log Retention Period
- Exchange Server 2010 – Export Message Tracking Log Results to CSV File
- Exchange Server 2010 – Get a List of All Mailbox Columns/Attribute Names
- Exchange Server 2010 – Get a List of Mailboxes by Creation Date
Batch Script – Parse MS Exchange IIS Log File, Filter All External Requests, and Email It
I needed a way to track which Exchange users were remotely retrieving their emails outside of the office on their phones and other email clients, so I pieced together this batch/pseudo VB script that can be ran from the Windows Task Scheduler at midnight. The only dependency/third party app required is the MS Log Parser executable. Also, for the SQL query to filter out the proper internal networks from the log file, you will have to edit the LOCALSUBNET and CHARLENGTH variables.
Continue reading “Batch Script – Parse MS Exchange IIS Log File, Filter All External Requests, and Email It”