前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >计算当前Exchange 2010 数据库的用户使用情况

计算当前Exchange 2010 数据库的用户使用情况

作者头像
孤鸿
发布2022-09-23 17:00:51
3220
发布2022-09-23 17:00:51
举报
文章被收录于专栏:孤鸿

> 今天在微软的galary 中闲逛,发现了一个PS脚本,是导出当前的用户数据大小的值的,和对比一段时间数据库大小的值。我们现在不需要对比,只需要得出当前的用户的几个指标,因此我将这段PS代码修改了下,就不再需要利用EXCEL 做数据大小的计算了,代码如下,大家可以把这段代码COPY 到一个NOTEPAD中,然后保存为PS1即可。

代码语言:javascript
复制
#edit by raymond xu,you can contact me by sending mail wusc@wscon.cn
param
(
 [Switch]$ExportMailboxSize,
 [Switch]$CompareMailboxSize,
 [String]$LogPath="C:\log",
 [String[]]$Identity,
 [DateTime]$StartDate,
 [DateTime]$EndDate
)
#region Export today's Mailbox Size
if ($ExportMailboxSize)
{
 $Counter=0
 $UserMailboxStatistics=@()
 if(-not ( Test-Path -Path $LogPath))
 {
  New-Item -ItemType  directory -Path $LogPath 
 } 
 #Get mailbox identity
 if (-not ($Identity))
 {
  $UserMailboxs=Get-Mailbox -Filter 'RecipientTypeDetails -eq "UserMailbox"' -ResultSize unlimited 
 }
 else
 {
  $UserMailboxs=$Identity|Get-Mailbox -Filter 'RecipientTypeDetails -eq "UserMailbox"' -ResultSize unlimited
 }
 #Get SamAccountName,DisplayName and MailboxTotalItemSize for specific users or all users with mailbox.
 foreach ($UserMailbox in $UserMailboxs)
 {
  $Counter++
  Write-Progress -Activity "Export MailboxStatistic" -Status "Exporting" -CurrentOperation $UserMailbox.DisplayName -PercentComplete ($counter/($UserMailboxs.Count)*100)

  $UserMailboxStatistic = New-Object PSObject
  $UserMailboxSizeB = (Get-MailboxStatistics -Identity $UserMailbox).TotalItemSize.Value.tobytes()
                $UserMailboxItem = (Get-MailboxStatistics -Identity $UserMailbox).itemcount
                $UserMailboxDeleteditem=(Get-MailboxStatistics -Identity $UserMailbox).deleteditemcount
                $UserMailboxDeletesizeB=(Get-MailboxStatistics -Identity $UserMailbox).TotalDeletedItemSize.Value.tobytes()
  $UserMailboxSizeMB = "{0:#.##}" -f ($UserMailboxSizeB/1mb)
                $UserMailboxDeletesizeMB="{0:#.##}" -f ($UserMailboxDeletesizeB/1mb)
                $usermailboxstatus=(Get-MailboxStatistics -Identity $UserMailbox).StorageLimitStatus
  $UserMailboxStatistic | Add-Member -MemberType NoteProperty -Name "SamAccountName" -Value $UserMailbox.SamAccountName
  $UserMailboxStatistic | Add-Member -MemberType NoteProperty -Name "DisplayName" -Value $UserMailbox.DisplayName
  $UserMailboxStatistic | Add-Member -MemberType NoteProperty -Name "UserMailboxSizeMB" -Value $UserMailboxSizeMB
                $UserMailboxStatistic | Add-Member -MemberType NoteProperty -Name "MailboxItemCount" -Value $UserMailboxItem
                $UserMailboxStatistic | Add-Member -MemberType NoteProperty -Name "MailboxDeleteditem" -Value $UserMailboxDeleteditem
                $UserMailboxStatistic | Add-Member -MemberType NoteProperty -Name "MailboxDeletedsize" -Value $UserMailboxDeletesizeMB
                $UserMailboxStatistic | Add-Member -MemberType NoteProperty -Name "Mailboxstatus" -Value $usermailboxstatus
  $UserMailboxStatistics+=$UserMailboxStatistic
 }
 #Output to a CSV file with date format "yyyy-MM-dd" as default name  ,in default path "C:\log". Path can be set by $logpath param.
 $UserMailboxStatistics|Export-Csv -Encoding default -NoTypeInformation -Path "$LogPath\$(get-date -Format "yyyy-MM-dd").csv"
}
#endregion

if (-not $ExportMailboxSize -and -not $CompareMailboxSize)
{
Write-Warning -Message "You did not choose any task. Please choose one."
}
把他保存为后缀为PS1的文件,保存即可。我们将文件保存到服务器上,然后以以下方式运行:
就会生成相应的CSV文件,我们文件内容如下:
然后我们用EXCEL 打开,可以很方便的处理相关的数据了,不再需要通过EXCEL 进行很繁琐的运算:
本文参与 腾讯云自媒体同步曝光计划,分享自作者个人站点/博客。
如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 把他保存为后缀为PS1的文件,保存即可。我们将文件保存到服务器上,然后以以下方式运行:
  • 就会生成相应的CSV文件,我们文件内容如下:
  • 然后我们用EXCEL 打开,可以很方便的处理相关的数据了,不再需要通过EXCEL 进行很繁琐的运算:
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档