Forum Discussion

rootwontfall's avatar
rootwontfall
Copper Contributor
Jun 08, 2019

Script to export to CSV all Mailboxes and SharedMailboxes

Hi,   I'm trying to make a new script in Powershell to display (for a report) the following attributes in a CSV table like this: DisplayName   UserPrincipalName   Licenses   RecipientTypeDetails  ...
office 365
powershell
jerome317's avatar
jerome317
Brass Contributor
Jun 10, 2019

rootwontfallConfirmed this one has worked... just change the ResultSize to Unlimited

 

Get-Mailbox -ResultSize 10 | select displayname,UserPrincipalName,RecipientTypeDetails,@{Name='Mailbox Size';Expression={Get-MailboxStatistics $_.UserPrincipalName | Select TotalItemSize}},@{Name='Licenses';Expression={(Get-MsolUser -UserPrincipalName $_.UserPrincipalName | Select -ExpandProperty Licenses).AccountSKUID}} |Export-Csv -NoTypeInformation .\Desktop\Test.csv

 

  • rootwontfall's avatar
    rootwontfall
    Copper Contributor
    Jun 11, 2019

    jerome317 

     

    The licenses column still blank and I can't understand why.

     

    I got one script (the one I used before) to give me that kind of information just like this:

     

    Get-MsolUser -All |
    Select DisplayName,UserPrincipalName,@{n="Licenses";e={$_.Licenses.AccountSKUid}} | Sort-Object DisplayName |
    Export-Csv -Path C:\temp\MailboxesLicenciadas.csv -NoTypeInformation

     

    I tried it like this:

    Get-Mailbox -ResultSize:Unlimited | select displayname,UserPrincipalName,RecipientTypeDetails,@{Name='Mailbox Size';Expression={Get-MailboxStatistics $_.UserPrincipalName | Select TotalItemSize}},@{Name='Licenses';Expression={Get-MsolUser -UserPrincipalName $_.UserPrincipalName | Select -ExpandProperty Licenses.AccountSKUID}} |Export-Csv -NoTypeInformation C:\temp\FullExport.csv

     

    But I can't make it work in your script. Do you've any idea why?

    • jerome317's avatar
      jerome317
      Brass Contributor
      Jun 11, 2019

      rootwontfallYou're missing a parenthesis, order of operations.

       

      (Get-MsolUser -UserPrincipalName $_.UserPrincipalName | Select -ExpandProperty Licenses).AccountSKUID

      • rootwontfall's avatar
        rootwontfall
        Copper Contributor
        Jun 12, 2019

        jerome317 

         

        Even making the following command:

         

        Get-Mailbox -ResultSize:Unlimited | select displayname,UserPrincipalName,RecipientTypeDetails,@{Name='Mailbox Size';Expression={Get-MailboxStatistics $_.UserPrincipalName | Select TotalItemSize}},@{Name='Licenses';Expression={(Get-MsolUser -UserPrincipalName $_.UserPrincipalName | Select -ExpandProperty Licenses).AccountSKUID}} |Export-Csv -NoTypeInformation .\Desktop\Test.csv

         

        It still gives me all columns right unless the column called "Licenses".

         

        I've already tried to change the script but the result is the same...

         

        I can't export licenses of each mailboxes.

         

        Thanks for your help jerome317!

Resources