- Adtran TA924 PRI Conversion – Routing Inbound DIDs to FXS Ports or via a SIP Trunk to Asterisk and Allowing Bi-Directional Communications Between the Two
- Adtran Total Access TA924 – SIP Configuration for Asterisk
- Asterisk – How to Host a PRI Circuit with a Sangoma Card
- Asterisk – Modular Dialplan
- Asterisk Dialplan Module – stdexten
- Auto Logon to a Workstation on a Windows Domain
- BackupExec 2012 – How to Limit CPU Usage and Disk I/O on RALUS with Cron Jobs
- BackupExec 2012 Linux Agent SP1 Patch Update – Ubuntu Fix
- Bash Script – An Alternative to Logrotate.d for Asterisk Log Files
- Bash Script – Auto-Repair an Array of MySQL Database Servers
- Bash Script – Backup All Databases to Separate Files
- Bash Script – Convert a Batch of WAV Files to SLINEAR Format for Asterisk Hold Music
- Bash Script – Install HP Server Management Tools on Ubuntu Server
- Bash Script – Log Concurrent Asterisk Calls to MySQL and Other Useful One-Liners
- Bash Script – Move Asterisk Call Files into Spool Directory
- Bash Script – Move Files into Subdirectories Based on Modified Date – OR – Moving Ntop Netflow Dumps into Subdirectories by Date
- Bash Script – OpenMCU-ru Service Monitor -OR- Monitor and Automatically Restart a Service Upon Failure
- Bash Script – Pcapsipdump Spool Directory File Rotation – OR – Rotate Directories Based on YYYYMMDD Format
- Bash Script – Script Based MySQL Table Replication on an Array of Slaves
- Bash Script – Split a Variable into an Array with Carriage Return Line Feed as the Delimiter
- Bash Script – Sync a File to an Array of Hosts
- Bash Script – Test Veeam Linux Agent Socket and Restart Service if Needed
- 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 – 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”