[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Get-messagetracking log and date format

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11
So we have Exchange Hub Transport servers in US and Europe. One of the tasks we sometimes need to carry out is searching the Message Tracking log for users sending and receiving messages and so on.

We often have to search all Hubs globally.


The below is an example:

Get-TransportServer | Get-messagetrackinglog -sender user1@domain.com -recipients user2@domain.com

It would be useful to add the -Start or -End dates to the search, but how does this work if we are searching between Hubs that use a different date format?

For example, if I wanted to search for messages from user1 to user2 after April 16th 2011, then this causes a problem. The US servers would have this as 4/16/2011 however the Europe servers would have this as 16/4/2011. If I check servers Regional Settings, then we can see that they use different date formats.

What do we need to do?

Question by:digitalco
  • 6
LVL 25

Accepted Solution

Ron Malmstead earned 2000 total points
ID: 35428352
You would run it as the regional settings are from wherever you are running it from.
So if you are in Europe... run it the euro way and visa versa.

The saying "when in rome"... still applicable apparently.
LVL 25

Expert Comment

by:Ron Malmstead
ID: 35428357
Have you actually noticed any inconsistency by supplying start/end dates ?

I can't imagine MS would make such a novice mistake in their cmdlet or exchange for that matter.

Author Comment

ID: 35428372

So you're saying that even if we're searching ALL global Hubs, we should use the format of the server we're running the command from?

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

LVL 25

Expert Comment

by:Ron Malmstead
ID: 35428392

If all is well in the Microsoft world... the server you are running it against will convert it from your regional settings to UTC (universal) format anyway, in code.

LVL 25

Expert Comment

by:Ron Malmstead
ID: 35428404
If you supply 7pm...and you are in Germany...

That time is 1pm in the US EST, on the same day, and that is going to be the time it's is searching.
LVL 25

Expert Comment

by:Ron Malmstead
ID: 35428437
This is why when you send a calendar invite to someone cross country, if everything is setup correctly.. the time is converted to match so that you actually meet when you are supposed to.

Same concept applies to e-mail...
LVL 25

Expert Comment

by:Ron Malmstead
ID: 35428442
Oh yea...

If you supply ... 4/29/2011  - 4/30/2011  ...that encompasses   4/28/2011 6:00pm - 4/29/2011 5:59pm EST in the US if you are running it against a server in Germany.

This is a core function of windows, ...regional settings.  Things would be very confusing for all programmers without this consideration.

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to effectively resolve the number one email related issue received by helpdesks.
If you have come across a situation where you need to find some EDB mailbox recovery techniques, then here you will find the same. In this article, we will take you through three techniques using which you will be able to perform EDB recovery. You …
This video discusses moving either the default database or any database to a new volume.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses
Course of the Month19 days, 16 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question