- VBScript – How to Access Environment Variables -OR- How to Get the Username, Domain, or a User’s SID
- VMware vSphere Client – Remove Cached Entries on Connection Screen
- Windows – How to Run Elevated Scripts as a Regular User with Task Scheduler -OR- How to Restart Services as a Standard User
- Windows – Play a WAV file with PowerShell and the .NET SoundPlayer Class
- Windows 8.1 – Disable IPv6 Components
- Windows 8/Server 2012 – Install A Theme for All Users
- Windows Explorer – Cannot Read From the Source File or Disk
- Windows Server – Disable VMware Tools Icon
- Windows Server 2K P2V Conversion VMware BSOD
- Windows Terminal Server – Three Ways to Disable AVG Tray Icon via Group Policy
- Windows Update Error 80073712 When Installing KB2943357 – OR – How to Repair Corrupted Windows Update Files on Windows 7 or Server 2008
- Windows Update Error 8024402C – Bypass WSUS for VPN Computers Joined to the Domain
- Windows XP – VMware Standalone Converter Install Sysprep Tools
- WinSCP – Import/Export Your Saved Sessions List and Settings from a Computer that is Offline
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”