Lees hier de laatste IGA-ontwikkelingen

PowerShell: Exchange 2007 mailbox database details V3

[array]$MailboxDatabaseTable = @() $dbs = Get-MailboxDatabase -status foreach ($db in $dbs) { if ($db.Mounted -eq "True") {

Lees meer

PowerShell: SQL queries, tables and output

$SQLSERVER = "myServer" $DATABASE = "myDatabase" $ID = 12345 $SqlQuery = "select colum1, " $SqlQuery = $SqlQuery + "column2 " $SqlQuery = $SqlQuery + "from tblSomething " $SqlQuery = $SqlQuery + "where ID = " + $ID

Lees meer

PowerShell: list mailbox database statistics (quota, mailbox count and size) - version 2

This script now includes reading the quota settings per mailbox database. There is no need to specify the input, as it automatically iterates through all mailbox databases in the organization (as long as your user account has sufficient permissions to see them). Then it starts building up a table object and filling rows with the results. This works pretty well, since you can use the table for sorting, displaying and usage in other scripts.

Lees meer