Shulou(Shulou.com)06/01 Report--

Editor to share with you how to get AD account and email information in PowerShell, I believe most people don't know much about it, so share this article for your reference. I hope you can learn a lot after reading this article. Let's learn about it together.

Sometimes we need to query many attributes of the account, but we need to obtain them through different commands, which are similar to the multi-table join query in SQL Server, such as querying the ad account description, mailbox name, display name, mailbox address, number of mailboxes, mailbox size, archive mailbox size, and number of archive mailboxes of all accounts.

Ad account description-the description information corresponding to the AD account is obtained through Get-adUser

Mailbox name, display name, email address-corresponding to the user's mailbox information, obtained through get-mailbox

Number of mailboxes, mailbox size-corresponding mailbox information, obtained from the command get-mailbox | Get-MailboxStatistics

Archive mailbox size, number of archived mailboxes-corresponding to archived mailbox information, obtained by command get-mailbox-Archive | Get-MailboxStatistics-Archive

These attributes are connected and queried through the common property SamAccountName, as follows:

- -

Cls

Add-PSSnapin microsoft.exchange*

$mbxinfo=Get-mailbox-ResultSize unlimited |% {$_ .SamAccountName}

$userlist = @ ()

Foreach ($I in $mbxinfo)

{

$Description=Get-adUser $I-Properties * |% {$_ .description}

$user=get-mailbox $I

$userStatistics=get-mailbox $I | Get-MailboxStatistics

$userarchiveStatistics=get-mailbox $I-Archive | Get-MailboxStatistics-Archive

$userobject=New-object psobject

$userobject | Add-Member-membertype noteproperty-Name AD account description-value $Description

$userobject | Add-Member-membertype noteproperty-Name mailbox name-Value $user.Name

$userobject | Add-Member-membertype noteproperty-Name display name-Value $user.DisplayName

$userobject | Add-Member-membertype noteproperty-Name email address-Value $user.PrimarySmtpAddress

$userobject | number of Add-Member-membertype noteproperty-Name mailboxes-Value $userStatistics.ItemCount

$userobject | Add-Member-membertype noteproperty-Name mailbox size-Value $userStatistics.TotalItemSize

$userobject | number of Add-Member-membertype noteproperty-Name archive mailboxes-Value $userarchiveStatistics.ItemCount

$userobject | Add-Member-membertype noteproperty-Name archive mailbox size-Value $userarchiveStatistics.TotalItemSize

$userlist+=$userobject

}

$userlist

$userlist | export-csv-Path c:\ userlist.csv-Encoding utf8-NoTypeInformation

The above is all the contents of the article "how to get AD account and email Information in PowerShell". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.