{"id":12141,"date":"2011-11-09T00:01:00","date_gmt":"2011-11-09T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2011\/11\/09\/troubleshoot-outlook-problems-with-powershell\/"},"modified":"2011-11-09T00:01:00","modified_gmt":"2011-11-09T00:01:00","slug":"troubleshoot-outlook-problems-with-powershell","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/troubleshoot-outlook-problems-with-powershell\/","title":{"rendered":"Troubleshoot Outlook Problems with PowerShell"},"content":{"rendered":"

Summary:<\/strong> Microsoft Scripting Guy Ed Wilson teaches how to use Windows PowerShell to troubleshoot Microsoft Outlook problems.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

\"Hey,<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span>Hey, Scripting Guy! I have a problem with Microsoft Outlook on my laptop. It seems that it goes to sleep or something. I will be working, go to check my email, and nothing appears. But if I look at my Windows 7 mobile phone, it shows that new email is in my inbox. I am thinking that I have a problem with Outlook. <\/span><\/p>\n

—BT<\/span><\/p>\n

 <\/span><\/p>\n

\"Hey,<\/span><\/span><\/span><\/span><\/span><\/span><\/span>Hello BT, <\/span><\/p>\n

Microsoft Scripting Guy Ed Wilson here. <\/span>The Scripting Wife<\/span><\/a> and I had a wonderful time at the Geek Ready conference. She knows many of the Microsoft premier field engineers (PFEs) because she has met them at various Windows PowerShell User group meetings, at conferences, or just from hanging around me. She had a chance to meet several PFEs who have written guest Hey, Scripting Guy! Blog articles, but that she had never met in person. It really was awesome. We were up late on several nights having “Windows PowerShell side meetings” with various PFEs, and on a couple occasions, we ended up having impromptu script club meetings. The results of all this engagement will be appearing for months to come on the Hey, Scripting Guy! Blog, so stay tuned. <\/span><\/span><\/p>\n

Anyway, with all the geeks taking over the hotel where we were staying, poor <\/span>Microsoft Outlook<\/span><\/a> was struggling. In fact, Internet connectivity was spotty most of the time, just due to the sheer magnitude of the demands placed on the infrastructure by us. The nice thing is that, by using Windows PowerShell, I can do an awful lot of discovery.<\/span><\/span><\/p>\n

When I am doing event log exploration, things go a whole lot faster if I store the particular lot in a variable. So that is what I am going to. Microsoft Outlook writes events to the application log using the source id of outlook<\/b>. <\/i>I therefore use the Get-EventLog<\/b> cmdlet and gather up all the entries that have a source of outlook<\/b>.<\/i> I store these EventLogEntry<\/b> objects in a variable I call $log<\/b>. The <\/span>EventLogEntry .NET Framework class<\/span><\/a> appears in the System.Diagnostics<\/b> namespace, and documentation appears on MSDN. This command is shown here:<\/span><\/span><\/p>\n

$log = Get-EventLog application -Source outlook<\/span><\/p>\n

Once I have all of the outlook<\/b> entries in a variable, I can begin to examine them. I am curious about how many entries I have, so I use the count<\/b> <\/i>property to see. This command and output are shown here:<\/span><\/p>\n

PS C:\\> $log = Get-EventLog application -Source outlook<\/span><\/p>\n

PS C:\\> $log.count<\/span><\/p>\n

280<\/span><\/p>\n

Next, I want to see what type of structure I am dealing with, so I index into the array of records, and pick off one record to examine and pipe the results to the Format-List<\/strong> cmdlet (fl<\/strong> is an alias for the Format-List<\/strong> cmdlet). Here is the command I use:<\/span><\/p>\n

$log[0] | fl * -Force<\/span><\/p>\n

This command and the associated output appear in the following figure.<\/span><\/p>\n

\"Image<\/a><\/span><\/p>\n

Wow, as it turns out, that was a bad <\/i>example because it goes on and on and on. It can be useful, however, because this shows me all of the add-ins that Microsoft loads. Remember, seeing the Microsoft Outlook splash screen that shows how many add-ins it is loading? It looks like EventID 45 tells me about loading add-ins. <\/span><\/p>\n

A better event log entry is the one that is shown in the following figure. The reason this event log entry is better is that it allows me to see representative data from all of the different properties in a single screen shot.<\/span><\/p>\n

\"Image<\/a><\/span><\/p>\n

Event ID 26 looks like it tells me when Microsoft Outlook has lost connectivity to the Microsoft Exchange server. Hmmm, that might be useful. Let me look at all event ID 26s and see what they say. To do this, I pipe the collection of event log entries that are stored in the $log<\/b> variable to the Where-Object<\/b> cmdlet (?<\/b> Is an alias for Where-Object<\/b>). In the script block associated with the Where-Object<\/b> cmdlet, I look for eventid<\/b> <\/i>that is equal (-eq<\/b>) to 26. This command is shown here:<\/span><\/p>\n

$log | ? {$_.eventid -eq 26}<\/span><\/p>\n

My screen quickly floods with entries. Interestingly enough, it seems that Event ID 26 reports lost connectivity as well as restored connectivity. This can actually be a useful thing. What I can do first is look at how many disconnects and how many connection restored messages there are. This command is shown here:<\/span><\/p>\n

PS C:\\> $log | ? {$_.eventid -eq 26} | group message -NoElement | select name, count | ft -AutoSize<\/span><\/p>\n

Name                                                                                               Count<\/span><\/p>\n

—-                                                                                               —–<\/span><\/p>\n

Connection to Microsoft Exchange has been lost. Outlook will restore the connection when possible.    36<\/span><\/p>\n

Connection to Microsoft Exchange has been restored.                                                   34<\/span><\/p>\n

Now that I see that there are a significant number of times when the connection to the Microsoft Exchange server dropped, I would really like to see when this is happening. To do this, I want to focus on the timewritten<\/b> property from the eventlog. The problem is that if I find my events, and group by the timewritten<\/b> property, the result will be 70 separate lines and no real grouping because each timewritten<\/b> record will be unique. Therefore, nothing exists to group on. The command is shown here:<\/span><\/p>\n

$log | ? {$_.eventid -eq 26} | group timewritten<\/span><\/p>\n

The command and output are shown in the following figure.<\/span><\/p>\n

\"Image<\/a><\/span><\/p>\n

The trick is to realize that the timewritten<\/b> <\/i>property contains a DateTime<\/b> object. This is important because I know that an instance of the DateTime<\/b> object exposes a day<\/b> <\/i>property. I can then use the Group-Object<\/b> cmdlet to organize the eventlog records by day. I used the Get-Member<\/b> cmdlet (gm<\/b> is an alias) to discover that the timegenerated<\/b> <\/i>property contains a DateTime<\/b> object. This command and output are shown here:<\/span><\/p>\n

PS C:\\> $log[0] | gm timegenerated<\/span><\/p>\n

   TypeName: System.Diagnostics.EventLogEntry#application\/Outlook\/1073741869<\/span><\/p>\n

 <\/span><\/p>\n

Name          MemberType Definition<\/span><\/p>\n

—-          ———- ———-<\/span><\/p>\n

TimeGenerated Property   System.DateTime TimeGenerated {get;}<\/span><\/p>\n

 <\/span><\/p>\n

The problem is exposing that DateTime<\/b> object to the Group-Object<\/b> cmdlet. For example, the following command attempts to use dotted notation to directly access the day<\/b> <\/i>property of the DateTime<\/b> object:<\/span><\/p>\n

$log | ? {$_.eventid -eq 26} | group timewritten.day<\/span><\/p>\n

The command and output are shown here (they are not impressive):<\/span><\/p>\n

PS C:\\> $log | ? {$_.eventid -eq 26} | group timewritten.day<\/span><\/p>\n

Count Name                      Group<\/span><\/p>\n

—– —-                      —–<\/span><\/p>\n

   70                           {System.Diagnostics.EventLogEntry, System.Diagnostics.EventLogEntry,<\/span><\/p>\n

The following commands also do not work. In fact, some generate errors:<\/span><\/p>\n

$log | ? {$_.eventid -eq 26} | group (timewritten).day<\/span><\/p>\n

$log | ? {$_.eventid -eq 26} | group $(timewritten).day<\/span><\/p>\n

$log | ? {$_.eventid -eq 26} | group $_.timewritten.day<\/span><\/p>\n

The trick is to use the Select-Object<\/b> cmdlet with the expandproperty <\/i>parameter to expand the timewritten<\/b> <\/i>property from the Get-EventLog<\/b>. In this way, I can then use the Group-Object<\/b> cmdlet to group the eventlog records by day. I decided to leave the details because they let me see which days I am having problems. The command is shown here:<\/span><\/p>\n

$log | ? {$_.eventid -eq 26} | select -expandproperty timewritten | group day<\/span><\/p>\n

The command and associated output are shown in the following figure.<\/span><\/p>\n

\"Image<\/a><\/span><\/p>\n

It is obvious from the preceding figure, that there were problems on November 4 and October 16. This is great information because I could work with a customer, or someone who says, “I had a problem with Outlook last week sometime. I don’t really remember when, but it seemed like it kept dropping off, and not working.” And with Windows PowerShell and the Get-EventLog<\/b> cmdlet, I can actually connect remotely to their computer and retrieve the information I need. And then I can say, “Yes, I see you had a problem on November 4, but we were applying patches to the Exchange server that day, and it was up and down all day. So, no, there is no problem with Outlook.”<\/span><\/p>\n

But what if we look back, and we were not performing maintenance? Maybe, instead I want to see if there is a pattern by hour. I also know that the DateTime<\/b> object contains an hour<\/b> <\/i>property. Therefore, using my trick from earlier, I come up with the following command:<\/span><\/p>\n

$log | ? {$_.eventid -eq 26} | select -expandproperty timewritten | group hour<\/span><\/p>\n

The command and associated output follow. It is very revealing. Thirty-six of the disconnects occurred between the hours of 20:00 (8:00 P.M.) and 22:00 (10:00 P.M.). <\/span><\/p>\n

\"Image<\/a><\/span><\/p>\n

 <\/span><\/p>\n

BT, that is all there is to using Windows PowerShell to assist in troubleshooting Microsoft Outlook problems. Join me tomorrow for more cool Windows PowerShell things. <\/span> <\/span><\/p>\n

I invite you to follow me on <\/span>Twitter<\/span><\/a> and <\/span>Facebook<\/span><\/a>. If you have any questions, send email to me at <\/span>scripter@microsoft.com<\/span><\/a>, or post your questions on the <\/span>Official Scripting Guys Forum<\/span><\/a>. See you tomorrow. Until then, peace.<\/span><\/span><\/p>\n<\/p>\n

Ed Wilson, Microsoft Scripting Guy<\/b><\/span><\/p>\n

<\/span> <\/p>\n

 <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Microsoft Scripting Guy Ed Wilson teaches how to use Windows PowerShell to troubleshoot Microsoft Outlook problems.   Hey, Scripting Guy! I have a problem with Microsoft Outlook on my laptop. It seems that it goes to sleep or something. I will be working, go to check my email, and nothing appears. But if I […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[212,49,3,45],"class_list":["post-12141","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-microsoft-outlook","tag-office","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Microsoft Scripting Guy Ed Wilson teaches how to use Windows PowerShell to troubleshoot Microsoft Outlook problems.   Hey, Scripting Guy! I have a problem with Microsoft Outlook on my laptop. It seems that it goes to sleep or something. I will be working, go to check my email, and nothing appears. But if I […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=12141"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12141\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=12141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=12141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=12141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}