I need a full list of all mailboxes, shared mailboxes, and resources.

Question

I am trying to get a single list that will show me all of our mailboxes, shared mailboxes, and resources, as well as show the license type. When I run this command (Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName, RecipientTypeDetails, Alias) it returns a list of 293 rows. However, if I do individual lists to show mailboxes and another to show shared mailboxes, etc. I end up with a list of 592 unique mailboxes. Looking, I found some of them I can see in 365 Admin center but they are not in Exchange admin center. (Not sure if that is the case with all of them.)

How can I get a single list to show me all of the mailboxes, shared mailboxes and resources as well as what type of mailbox it is?

Ex. John Doe, Shared Mailbox

  Jane Doe, Resource

  Jack Ryan, UserMailbox