king daddy

IT Professional

Albert Widjaja

<div>
Thanks, Vasil. It is running now.
</div>


<div>
Perfect. Thanks again, Vasil.
</div>


<div>
<div class="content wysiwyg-content">
This is what I am using to get a Mobile Device report from our Office 365 server. I get Identity in the report, but it looks like this and is not easy to work with. <br />
<br />
SERVER.PROD.OUTLOOK.COM/Mi<wbr />crosoft Exchange Hosted Organizations/company365.o<wbr />nmicrosoft<wbr />.com/Displ<wbr />ay Name/ExchangeActiveSyncDev<wbr />ices/Andro<wbr />id?android<wbr />c97397597<br />
SERVER.PROD.OUTLOOK.COM/Mi<wbr />crosoft Exchange Hosted Organizations/company365.o<wbr />nmicrosoft<wbr />.com/Displ<wbr />ay Name/ExchangeActiveSyncDev<wbr />ices/iPhon<wbr />e?7YHLOI8D<wbr />ER5HCN01HY<wbr />HY8UDEC<br />
<br />
This is the power shell I am running:<br />
<br />
$Mailboxes = Get-Mailbox -Identity $_.UserPrincipalName -RecipientTypeDetails UserMailbox -ResultSize Unlimited<br />
$Devices = $Mailboxes | %{Get-ActiveSyncDeviceStat<wbr />istics -Mailbox $_.Identity} | `?{$_.LastSuccessSync | export-csv PATH<br />
<br />
I need to get the email address, UPN, or even the user's display name in a column.<br />
<br />
Any help much appreciated.
</div>
</div>


This is what I am using to get a Mobile Device report from our Office 365 server. I get Identity in the report, but it looks like this and is not easy to work with. 

SERVER.PROD.OUTLOOK.COM/Microsoft Exchange Hosted Organizations/company365.onmicrosoft.com/Display Name/ExchangeActiveSyncDevices/Android?androidc97397597
SERVER.PROD.OUTLOOK.COM/Microsoft Exchange Hosted Organizations/company365.onmicrosoft.com/Display Name/ExchangeActiveSyncDevices/iPhone?7YHLOI8DER5HCN01HYHY8UDEC

This is the power shell I am running:

$Mailboxes = Get-Mailbox -Identity $_.UserPrincipalName -RecipientTypeDetails UserMailbox -ResultSize Unlimited
$Devices = $Mailboxes | %{Get-ActiveSyncDeviceStatistics -Mailbox $_.Identity} | `?{$_.LastSuccessSync | export-csv PATH

I need to get the email address, UPN, or even the user's display name in a column.

Any help much appreciated.

Help getting UPN, email address, or user name from ActiveSyncDeviceStatistics or Get-MobileDeviceStatistics

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Mobile web development, also known as responsive web design, is an approach to web design aimed at crafting sites to provide an optimal viewing and interaction experience—easy reading and navigation with a minimum of resizing, panning, and scrolling—across a wide range of devices (from desktop computer monitors to mobile phones). A site designed with RWD adapts the layout to the viewing environment by using fluid, proportion-based grids, flexible images, and CSS3 media queries.

Mobile

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.