August 7, 2015

Get Office 365 Report - Mailbox Size, Last Logon Time, Licence

This PowerShell script provides information about Exchange Online mailboxes. It includes following attributes: FirstName, LastName, DisplayName, Alias, UserPrincipalName, Office, Department, TotalItemSize, LastLogonTime, RecipientTypeDetails and basic licensing information.
Script combines Get-MsolUser, Get-Mailbox and Get-MailboxStatistics cmdlets into single one. You must have appropriate permissions in your tenant to run these cmdlets.
Discovery Mailboxes are excluded from report. TotalItemSize values are converted to MB.
Windows Azure Active Directory Module for Windows PowerShell is required. Otherwise Get-MsolUser and whole script will fail.
Download O365Report.ps1, open PowerShell, navigate to folder where script was downloaded, run the script. You will get credentials popup to connect to your tenant (make sure that you use the same account to access Office 365 Admin Portal and Exchange Online). Results will be exported to CSV file.

# 8/20/2015 - User Title and Archive statistics have been added to report. 
# 9/11/2015 - For tenants with managed default domain "LastPasswordChangeTimestamp" and "PasswordExpirationIn (Days)" information has been added.

August 6, 2015

Easy and Fast offline VMware VMDK to Hyper-V VHDX conversion

I have just converted VMware VMDK file to Hyper-V VHD in very easy and fast manner. I posted about QEMU-Img for Windows port and finally tried it. There is Infoblox IPAM Express free system for IP Address Management (actually deserves another huge post about) that I want to try. It distributes in VMware VMDK format. Since I am Hyper-V man I need to convert this image to Hyper-V format. I don't want to install any programs and check any prerequisites. I have simple task and want to achieve it simple as well.

I run following command and I have my image converted:
qemu-img.exe convert InfobloxIPAMExpress.vmdk -O vhdx -o subformat=dynamic InfobloxIPAMExpress.vhdx

Very fast and simple.