Analyzing Exchange Transaction Log Generation Statistics UPDATED

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 thrown:

Cannot convert value “21/05/2010” to type “System.DateTime”

See the original blog post for examples:

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:

  • Get-Culture
  • Get-UICulture


%d Bloggern gefällt das: