The script published by the Exchange Team (Analyzing Exchange Transaction Log Generation Statistics) requires an update when run on a system that does not use the en-US locale as Culture.
When the script analyses the saved log file information, a DateTime error is being thrown:
Cannot convert value „21/05/2010“ to type „System.DateTime“
See the original blog post for examples: http://blogs.technet.com/b/exchange/archive/2013/10/07/analyzing-exchange-transaction-log-generation-statistics.aspx
The script utilizes the Get-UICulture cmdlet to fetch the culture settings required to have [DATETIME]::Parse() work as expected.
DateTime values are stored in the CSV file using the UICulture setting, but [DATETIME]::Parse() uses the local culture settings to parse values by default.
To check your settings in PowerShell use the following cmdlets:
- Updated Script at TechNet Gallery: https://gallery.technet.microsoft.com/Analyzing-Exchange-be8899c8
- Updated Script at GitHub: https://github.com/Apoc70/Get-TransactionLogStats