365Tools

1.0

New-MSOLReport.ps1

                                function New-MSOLReport

{

  <#

    .SYNOPSIS

    Creates a CSV-file with user data from Office 365

    .DESCRIPTION

    This function creates a CSV-file with user data fetched from Office 365, such as licensing status, mailbox size, etc. 

    .EXAMPLE

    New-MSOLReport -outfile c:\temp\somefile.csv

    .EXAMPLE

    New-MSOLReport -outfile c:\temp\somefile.csv -Verbose

  #>

  [CmdletBinding()]

  param

  (

    [Parameter(Mandatory=$true, Position=0)]

    [string]

    $outfile

  )

  Write-Progress -Id 1 -Activity "Generating MSOL Report" -Status "Starting Inital Query" -PercentComplete 0

  $arrResults = @()

  $starttime = (get-date)

  $users = get-msoluser

  $total = ($users).count

  write-verbose "Getting $total mailboxes"

  Write-Progress -Id 1 -Status "Getting $total mailboxes" -PercentComplete 10 -Activity "Generating MSOL Report"

  $mbx = get-mailbox

  Write-Verbose "Getting mailbox statistics for $total mailboxes. This might take some time."

  Write-Progress -Id 1 -Status "Getting Statistics for $total mailboxes. This might take some time." -PercentComplete 20 -Activity "Generating MSOL Report"

  $statistics = ($mbx | get-mailboxstatistics)

  write-verbose "Starting processing of $total individual mailboxes"

  Write-Progress -Id 1 -Status "Processing individual users" -PercentComplete 60 -Activity "Generating MSOL Report"

  $current = 0

  forEach ( $user in $users ) {

    $current++

    $status = $user.displayname

    Write-Progress -Activity "Processing $total mailboxes" -Status "Processing mailbox $status" -PercentComplete ($current / $total*100) -ParentId 1

    Write-Verbose "Gathering statistics for $status"

    $stats = ($statistics | Where-Object {$_.Displayname -eq $user.DisplayName})

    $properties = @{'Name'=$user.DisplayName;

      'EmailAddress'=$user.UserPrincipalName;

      'Title'=$user.Title;

      'Licensed'=$user.IsLicensed;

      'MobilePhone'=$user.MobilePhone;

      'LastLogon'=$stats.LastLogonTime;

      'MailboxSize'=$stats.TotalItemSize;

    'DeletedItemSize'=$stats.TotalDeletedItemSize}

    $objResults = New-Object -TypeName PSObject -Property $properties

    $arrResults += $objResults

  }

  Write-Progress -Id 1 -Status "Writing $outfile" -PercentComplete 95 -Activity "Generating MSOL Report"

  $arrResults | Export-CSV -NoTypeInformation -Path $outfile

  $stoptime = (get-date)

  $time = (new-timespan -start $starttime -end $stoptime)

  write-output "Processed $total users in $time, exported to CSV file $outfile."

}