Get Summary of Outlook Versions connecting to Exchange 2007

Asked for a query to get a summary of the Outlook Clients that are connecting to our Exchange server. The following Code will run against all mailboxes in a specific OU, but removing the filter will get all mailboxes on an Exchange server.

Your final results will include a count of the client versions in your environment. As you can see, each of our CIO dept has a Blackberry device (hence 2 MAPI Outlook client versions) and is running Outlook 2003 SP3 (Google 11.0.8161).

For example:
Count Name
----- ----
4 6.0.8069.0
4 11.0.8161.0

One note: I spent about 20 minutes researching a disparity between the mailbox count ($mbxes.count) and the end data. There are 5 mailboxes in this container. The 5th is a group mailbox for the department. No one ever directly connects to this mailbox. Get-logonstatistics returned a null query, which makes sense, no client version to report.

$mbxes = Get-Mailbox -OrganizationalUnit "CIO"
$ls = $mbxes | %{Get-LogonStatistics -Identity $_.distinguishedname}
$cv = $ls | group Username, ClientVersion

$Clients = @()
foreach ($y in $cv) {
        $clientver = $y.group[0].clientversion
        $Clients += $ClientVer
}
$clients | group

More on "Get-LogonStatistics"

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <blockquote> <center> <hr> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <drupal6>, <html>, <java>, <javascript>, <php>, <posh>.

More information about formatting options