{"id":957,"date":"2020-02-18T12:44:27","date_gmt":"2020-02-18T12:44:27","guid":{"rendered":"http:\/\/ihni.uk\/?p=957"},"modified":"2020-02-18T12:44:27","modified_gmt":"2020-02-18T12:44:27","slug":"getting-exchange-2016-db-transaction-log-sizes","status":"publish","type":"post","link":"https:\/\/ihni.uk\/?p=957","title":{"rendered":"Getting Exchange 2016 DB\/Transaction Log Sizes"},"content":{"rendered":"

Logs can be the bain of any Exchange Environment when things aren\u2019t going well\u2026<\/span><\/p>\n

I needed to keep track of one I was looking after so\u00a0after seeing the following post and it not working for me:<\/p>\n

http:\/\/practicalkungfu.net\/2012\/12\/22\/get-exchange-2010-transaction-log-folder-sizes-with-powershell\/<\/p>\n

 <\/p>\n

I created my own version to get them from an environment where all DBs where held in mount points.<\/p>\n

\n
\n
[CC lang=\u2019powershell\u2019]<\/div>\n<\/div>\n
\n

# Get DB\/Transaction Log Sizes for Exchange 2016.<\/p>\n

if\u00a0(!(Get-PSSnapin\u00a0| where {$_.Name\u00a0-eq\u00a0“Microsoft.Exchange.Management.PowerShell.E2010”}))
\n{
\nAdd-PSSnapin\u00a0Microsoft.Exchange.Management.PowerShell.E2010\u00a0-ErrorAction\u00a0SilentlyContinue
\n}<\/p>\n

Write-Progress\u00a0-Activity\u00a0“Exchange Servers”\u00a0-status\u00a0“Collecting Exchange Servers info”
\n$ExchangeServers\u00a0=\u00a0Get-ExchangeServer\u00a0-ErrorAction\u00a0SilentlyContinue<\/p>\n

Write-Progress\u00a0-Activity\u00a0“Databases”\u00a0-status\u00a0“Collecting Databases info”
\n$Databases\u00a0=\u00a0Get-mailboxdatabase\u00a0| Select Name,LogFolderPath,ServerNAme |\u00a0Sort-Object\u00a0Name<\/p>\n

$trupath\u00a0= @()
\n$databases\u00a0|\u00a0ForEach-ObJect{
\n$logpath\u00a0=\u00a0$_.LogFolderPath.ToString()
\n$logserver\u00a0=\u00a0$_.Servername.ToString()
\n$trupath\u00a0+=\u00a0$logpath\u00a0-replace\u00a0“C:\\\\”,\u00a0“\\\\$logserver\\c$\\”
\n}<\/p>\n

ForEach($pat\u00a0in\u00a0$trupath){
\n$size\u00a0=\u00a0“{0:N2} MB”\u00a0-f\u00a0((GCI\u00a0$pat\u00a0-recurse\u00a0|Measure-Object\u00a0-Property\u00a0Length\u00a0-Sum\u00a0-ErrorAction\u00a0Stop).Sum \/ 1MB)
\nWrite-Host\u00a0“$Pat`t $size”
\n}<\/p>\n<\/div>\n

[\/CC]<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Logs can be the bain of any Exchange Environment when things aren\u2019t going well\u2026<\/p>\n","protected":false},"author":1,"featured_media":988,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,19,11],"tags":[],"class_list":["post-957","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-exchange","category-powershell","category-scripts"],"jetpack_featured_media_url":"https:\/\/ihni.uk\/wp-content\/uploads\/2020\/02\/Powershell.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=957"}],"version-history":[{"count":0,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/957\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/media\/988"}],"wp:attachment":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}