{"id":1417,"date":"2013-04-04T01:48:29","date_gmt":"2013-04-04T01:48:29","guid":{"rendered":"https:\/\/pipe2text.com\/?page_id=1417"},"modified":"2013-04-06T22:05:31","modified_gmt":"2013-04-06T22:05:31","slug":"using-powershell-in-exchange-2010-to-export-activesync-device-partnerships-to-a-csv-file","status":"publish","type":"page","link":"https:\/\/pipe2text.com\/?page_id=1417","title":{"rendered":"Using PowerShell in Exchange 2010 to export ActiveSync Device Partnerships to a csv file"},"content":{"rendered":"<p>Hi all,<\/p>\n<p>In this blog I wanted to make you aware of a quick and easy way to get a list of all your ActiveSync Device Partnerships displayed nicely in csv file. This will give you lots of useful information including but not limited the device models, associated users, iOS versions, last successful sync times etc\u2026 It\u2019s a good way to get a look into what is connecting via ActiveSync and take inventory.<\/p>\n<p>All you need to do is open up the Exchange Management Shell and issue the 2 commands listed below. This will retrieve all the information and put in a csv file in the root of the c drive call \u201cASDdevice.csv\u201d.<\/p>\n<p><b><span style=\"text-decoration: underline;\">The Commands <\/span><\/b><\/p>\n<p>$Devices=Get-CASMailbox -ResultSize unlimited -filter {HasActivesyncDevicePartnership -eq $True}<\/p>\n<p>$Devices | % {Get-ActiveSyncDeviceStatistics -Mailbox $_.identity} | Export-Csv c:\\ASDevices.csv \u2013NoTypeInformation<\/p>\n<p>Once the commands are complete you can open them up in Excel for a nicely formatted Activesync Device Inventory\u00a0to sort\u00a0and clean it up accordingly.<\/p>\n<p>I hope this helps. As always, if you have a question or feedback please leave a comment.<\/p>\n<p>Related Links:<\/p>\n<p><a title=\"Troubleshooting ActiveSync in Exchange 2010 using PowerShell and the Export-ActiveSynclog cmdlet\" href=\"https:\/\/pipe2text.com\/?page_id=1454\"><strong>Troublesho<\/strong><\/a><a title=\"Troubleshooting ActiveSync in Exchange 2010 using PowerShell and the Export-ActiveSynclog cmdlet\" href=\"https:\/\/pipe2text.com\/?page_id=1454\"><strong>Troubleshooting ActiveSync in Exchange 2010 using PowerShell and the Export-ActiveSynclog cmdlet<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi all, In this blog I wanted to make you aware of a quick and easy way to get a list of all your ActiveSync Device Partnerships displayed nicely in csv file. This will give you lots of useful information &hellip; <a href=\"https:\/\/pipe2text.com\/?page_id=1417\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"class_list":["post-1417","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/pages\/1417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pipe2text.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1417"}],"version-history":[{"count":11,"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/pages\/1417\/revisions"}],"predecessor-version":[{"id":1462,"href":"https:\/\/pipe2text.com\/index.php?rest_route=\/wp\/v2\/pages\/1417\/revisions\/1462"}],"wp:attachment":[{"href":"https:\/\/pipe2text.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}