This article applies as of PRTG 22

Monitoring more Exchange database values using a PowerShell script

The Exchange Database (PowerShell) sensor can monitor the size of a database and can show if it is valid and mounted. If you need more or other data of your Exchange database, you can set up your individual PowerShell script and monitor it with an EXE/Script Advanced sensor.

This is also what one of our customers did who needed the following data per mailbox database:

• Size of database
• Size of whitespace (free space within the database that is used before the edb itself grows)
• Size of search index

We are happy that this customer shared the respective PowerShell script (see below) with us. Thank you!

How to use the PowerShell script

1. Open a text editor.
2. Copy the source code from below and paste it into the editor.
3. Adjust the connection URI at the beginning of the script so that it fits your Exchange server.
4. Save the file with the extension .ps1, for example, ExchangeDBstat.ps1.
5. Copy this file to your PRTG program directory, subfolder \Custom Sensors\EXEXML, on the probe system that monitors your Exchange server.
6. In PRTG, add an EXE/Script Advanced sensor to the Exchange database device.
   1. Select the file you created (here: ExchangeDBstat.ps1) from the list of scripts.
   2. In the section Security Context, select the option Use Windows credentials of parent device.
   3. You can leave the other settings unchanged.
   4. Click Create to add the sensor. The sensor will start to show you mailbox database size, whitespace size, and search index size after a few moments.

Note: We do not offer support for custom sensors provided by customers. Of course, you are free to adjust the script according to your needs.

Script

#-----Please adjust to your Exchange server:
$CURI="http://exchangeserver.domain.tld/PowerShell/"
#--------------

Function SizeInBytes ($itemSizeString)
{
    $posOpenParen = $itemSizeString.IndexOf("(") + 1
    $numCharsInSize = $itemSizeString.IndexOf(" bytes") - $posOpenParen 
    $SizeInBytes = $itemSizeString.SubString($posOpenParen,$numCharsInSize).Replace(",","")
	return $SizeInBytes 
}

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri $CURI -Authentication Kerberos
Import-PSSession $Session -DisableNameChecking

$dbs = Get-MailboxDatabase -Status

$result= "<?xml version=`"1.0`" encoding=`"Windows-1252`" ?>`r`n"
$result+="<prtg>`r`n"

foreach($db in $dbs)
{
	$dbname=$db.name
	$dbsize=SizeInBytes($db.DatabaseSize)
	$whitespace=SizeInBytes($db.availablenewmailboxspace)

	$edbFilePath = ("\\"+$db.ServerName+"\"+ $db.EdbFilePath.tostring().replace(":","$"))
	$i = $edbFilePath.LastIndexOf('\')
	$edbFilePath = $edbFilePath.Remove($i+1)
	$guid = $db.Guid.ToString()
	$dir = (get-childitem $edbFilePath | where { $_.Name.Contains($guid) })
	$idxdir=$edbFilePath+$dir
	$idxsize=(Get-ChildItem $idxdir | Measure-Object -Property Length -Sum).Sum

	$result+="   <result>`r`n"
	$result+="       <channel>DB-Size "+$dbname+"</channel>`r`n"
	$result+="       <unit>BytesFile</unit>`r`n"
	$result+="       <value>"+$dbsize+"</value>`r`n"
	$result+="   </result>`r`n"
	$result+="   <result>`r`n"
	$result+="       <channel>Whitespace "+$dbname+"</channel>`r`n"
	$result+="       <unit>BytesFile</unit>`r`n"
	$result+="       <value>"+$whitespace+"</value>`r`n"
	$result+="   </result>`r`n"
	$result+="   <result>`r`n"
	$result+="       <channel>Size Index "+$dbname+"</channel>`r`n"
	$result+="       <unit>BytesFile</unit>`r`n"
	$result+="       <value>"+$idxsize+"</value>`r`n"
	$result+="   </result>`r`n"
}		
$result+="   <text>OK</text>`r`n"
$result+="</prtg>`r`n"
$result
remove-pssession -session $Session
Exit 0

More

• My PowerShell sensor returns an error message. What can I do?