(Item) 0x80004005

Tue 07.29.08: Department Script

We needed a way to list all of the users in a mailstore and what department they belong to. We have our mail store membership based on department, so we need to audit it and verify mail store membership. (Just in case someone changes from one department to another department).



Here is the script.

$a= get-mailboxdatabase -server ex01 | Sort-Object Name


foreach ($mailstore in $a) {
$b= get-mailbox -SortBy Name | where {$_.Database -eq $mailstore.Identity}
write-host $mailstore.Identity -foregroundcolor red -backgroundcolor green
write-host "**********************************"
foreach ($username in $b) {
$c = get-user $username.Name
write-host $c.WindowsEmailAddress -nonewline
write-host "," -nonewline
write-host $c.Department
}
}

---

Item Rating Information....

Please rate this item:

012345