Extracting useful user information from Exchange 2010 with Powershell

Finishing a migration to Office 365 and want to send the client a list of remaining user mailboxes that need moving (or deleting!).

get-mailbox and get-mailboxstatistics both have their uses, but I really needed to use something that combined them both.

I found the solution at https://www.experts-exchange.com/questions/28399371/Combining-Get-Mail-Get-Mailboxstatistics-To-Pull-UsageLocation-LastLogonTime.html

And adapted it to my own means:

Get-Mailbox -ResultSize Unlimited | sort-object | Select-Object Name, primarysmtpaddress, @{n="Mailbox Size";e = {$MBXstat = Get-MailboxStatistics $_.name; $MBXstat.TotalItemSize}}, @{n="LastLogonTime";e = {$MBXstat = Get-MailboxStatistics $_.name; $MBXstat.LastLogonTime}} | Export-Csv C:\temp\LastLogonTime.csv

This outputs the User name, Primary SMTP Address from get-mailbox and Mailbox size (formatted to MB) and last logon time from get-mailboxstatistics.

Port forwarding on a Yamaha NVR500 Router in Japanese

Recently had to set up port forwarding on a Yamaha NVR500 router in Japan (the router was in Japan, I was not!).

Google Translate was definitely my friend, as was http://alex.goodchilduk.com/2012/04/05/port-forwarding-on-a-yamaha-nvr500-for-ssh/ which pointed me in the right direction.




Find the Advanced options and Advanced Settings and Information – detailed setting of the basic connection.


You can either set basic port forwards, or as I have here used a DMZ host to forward everything to the Sonicwall behind it.

The button with Japanese characters on is the OK button. Router did reboot, or at least re-connect its internet connection, as I was kicked off, but it reconnected pretty quickly.