RDS Connection Parser

This Powershell script will parse the Windows event logs of your Remote Desktop Session host servers and give you a nice report in Excel (xlsx) format.

Instructions

• Before you run, edit $SessionHosts to include one or several of your own servers.

Requirements

• ImportExcel module needs to be installed and imported before use.
  • https://github.com/dfinke/ImportExcel
• Some basic powershell knowledge.

Source

This is a modified copy of the script by Mike Crowley, located at

• https://gallery.technet.microsoft.com/Remote-Desktop-Connection-3fe225cd
• https://mikecrowley.wordpress.com/2015/04/08/a-new-and-an-updated-powershell-script/