Public/Mailbox/Get-EXOResourceMailbox.ps1
|
function Get-EXOResourceMailbox { <# .SYNOPSIS Export Office 365 Resource Mailboxes and Calendar Processing .DESCRIPTION Export Office 365 Resource Mailboxes and Calendar Processing .PARAMETER Filter Provide specific mailboxes to report on. Otherwise, all mailboxes will be reported. Please review the examples provided. .PARAMETER DetailedReport Provides a full report of all attributes. Otherwise, only a refined report will be given. .EXAMPLE Get-EXOResourceMailbox | Export-Csv c:\scripts\All365Mailboxes.csv -notypeinformation -encoding UTF8 .EXAMPLE '{emailaddresses -like "*contoso.com"}' | Get-EXOResourceMailbox | Export-Csv c:\scripts\365ResourceMailboxes.csv -notypeinformation -encoding UTF8 #> [CmdletBinding()] param ( [Parameter()] [string[]] $Filter, [Parameter()] $ResourceMailbox ) begin { <# $MailboxProperties = @( 'DisplayName', 'Office', 'RecipientTypeDetails', 'UserPrincipalName', 'Identity', 'PrimarySmtpAddress', 'Alias' ) #> if ($Filter) { $AllUserMailboxes = Get-Mailbox -filter $CurFilter -RecipientTypeDetails RoomMailbox, EquipmentMailbox -ResultSize Unlimited $MailboxLegacyExchangeDNHash = $AllUserMailboxes | Get-MailboxLegacyExchangeDNHash } else { $AllUserMailboxes = Get-Mailbox -RecipientTypeDetails RoomMailbox, EquipmentMailbox -ResultSize Unlimited $MailboxLegacyExchangeDNHash = $AllUserMailboxes | Get-MailboxLegacyExchangeDNHash } $Selectproperties = @( 'Identity', 'RecipientTypeDetails', 'AdditionalResponse', 'AddAdditionalResponse', 'AddNewRequestsTentatively', 'AddOrganizerToSubject', 'AllBookInPolicy', 'AllowConflicts' 'AllowRecurringMeetings', 'AllRequestInPolicy', 'AllRequestOutOfPolicy', 'DeleteAttachments', 'DeleteComments', 'DeleteNonCalendarItems' 'DeleteSubject', 'EnableResponseDetails', 'EnforceSchedulingHorizon', 'ForwardRequestsToDelegates', 'IsValid', 'OrganizerInfo' 'ProcessExternalMeetingMessages', 'RemoveForwardedMeetingNotifications', 'RemoveOldMeetingMessages', 'RemovePrivateProperty' 'ScheduleOnlyDuringWorkHours', 'TentativePendingApproval', 'BookingWindowInDays', 'ConflictPercentageAllowed', 'MaximumConflictInstances' 'MaximumDurationInMinutes', 'AutomateProcessing', 'MailboxOwnerId', 'ObjectState' ) $CalculatedProps = @( @{n = "ResourceDelegates" ; e = { @($MailboxLegacyExchangeDNHash[$_.ResourceDelegates]) -ne '' -join '|' } }, @{n = "BookInPolicy" ; e = { @($MailboxLegacyExchangeDNHash[$_.BookInPolicy]) -ne '' -join '|' } }, @{n = "RequestInPolicy" ; e = { @($MailboxLegacyExchangeDNHash[$_.RequestInPolicy]) -ne '' -join '|' } }, @{n = "RequestOutOfPolicy" ; e = { @($MailboxLegacyExchangeDNHash[$_.RequestOutOfPolicy]) -ne '' -join '|' } } ) if (-not $ResourceMailbox) { if ($Filter) { foreach ($CurFilter in $Filter) { Get-Mailbox -filter $CurFilter -RecipientTypeDetails RoomMailbox, EquipmentMailbox -ResultSize Unlimited | Get-CalendarProcessing | Select-Object ($Selectproperties + $CalculatedProps) } } else { Get-Mailbox -RecipientTypeDetails RoomMailbox, EquipmentMailbox -ResultSize Unlimited | Get-CalendarProcessing | Select-Object ($Selectproperties + $CalculatedProps) } } else { foreach ($Resource in $ResourceMailbox) { $CalList = Get-CalendarProcessing -Identity $Resource.Guid.ToString() foreach ($Cal in $CalList) { [PSCustomObject]@{ DisplayName = $Resource.DisplayName Office = $Resource.Office RecipientTypeDetails = $Resource.RecipientTypeDetails Identity = $Resource.Identity PrimarySmtpAddress = $Resource.PrimarySmtpAddress Alias = $Resource.Alias AutomateProcessing = $Cal.AutomateProcessing ResourceDelegates = @($Cal.ResourceDelegates) -ne '' -join '|' AllBookInPolicy = $Cal.AllBookInPolicy AllRequestInPolicy = $Cal.AllRequestInPolicy BookInPolicy = @($Cal.BookInPolicy) -ne '' -join '|' RequestInPolicy = @($Cal.RequestInPolicy) -ne '' -join '|' RequestOutOfPolicy = @($Cal.RequestOutOfPolicy) -ne '' -join '|' AllRequestOutOfPolicy = $Cal.AllRequestOutOfPolicy TotalGB = $Resource.TotalGB MaximumDurationInMinutes = $Cal.MaximumDurationInMinutes BookingWindowInDays = $Cal.BookingWindowInDays ConflictPercentageAllowed = $Cal.ConflictPercentageAllowed MaximumConflictInstances = $Cal.MaximumConflictInstances AdditionalResponse = $Cal.AdditionalResponse AddAdditionalResponse = $Cal.AddAdditionalResponse AddNewRequestsTentatively = $Cal.AddNewRequestsTentatively ForwardRequestsToDelegates = $Cal.ForwardRequestsToDelegates TentativePendingApproval = $Cal.TentativePendingApproval AddOrganizerToSubject = $Cal.AddOrganizerToSubject AllowConflicts = $Cal.AllowConflicts AllowRecurringMeetings = $Cal.AllowRecurringMeetings DeleteAttachments = $Cal.DeleteAttachments DeleteComments = $Cal.DeleteComments DeleteNonCalendarItems = $Cal.DeleteNonCalendarItems DeleteSubject = $Cal.DeleteSubject EnableResponseDetails = $Cal.EnableResponseDetails EnforceSchedulingHorizon = $Cal.EnforceSchedulingHorizon IsValid = $Cal.IsValid OrganizerInfo = $Cal.OrganizerInfo ProcessExternalMeetingMessages = $Cal.ProcessExternalMeetingMessages RemoveForwardedMeetingNotifications = $Cal.RemoveForwardedMeetingNotifications RemoveOldMeetingMessages = $Cal.RemoveOldMeetingMessages RemovePrivateProperty = $Cal.RemovePrivateProperty ScheduleOnlyDuringWorkHours = $Cal.ScheduleOnlyDuringWorkHours ObjectState = $Cal.ObjectState MailboxOwnerId = $Cal.MailboxOwnerId } } } } } } |