Skip to content

Paper Street Online

YOU'RE NOT YOUR FUCKING KHAKIS

Tag: vbs VBscript

Browse Recent:

Posted on March 29, 2016March 29, 2016

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”

Archives

Categories

  • Art (20)
    • Music (16)
      • Cover Song Lyrics (1)
      • Linzie Borden (2)
      • Side Projects (2)
      • The Farm Hands (9)
    • Photography (1)
    • Poetry (3)
    • Video (1)
  • Conspiracy Fact (3)
    • Chemtrails (3)
  • LAMP (4)
  • Tech (145)
    • Conferencing (6)
    • Linux (44)
      • Asterisk (13)
      • Bash Scripting (19)
    • Mac (8)
    • Microsoft Windows (90)
      • Batch Scripting (9)
      • Group Policy (23)
      • Microsoft Exchange (16)
    • Networking (12)
      • Cisco (5)
      • Mikrotik (3)
    • Programming (31)
      • Open-Source (31)
    • VMware (4)
    • VoIP (14)

Recent Posts

  • Implementing DKIM on Exchange 2019 CU11 with Microsoft DNS
  • Donovan Park
  • NextCloud – Purge Music Library from DB
  • NextCloud – Rescan Music Library for All Users
  • Google AdSense Ads Are Not Displayed in Firefox with Startpage Privacy Protection Installed
Proudly powered by WordPress