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

In the use of Exchange in an enterprise, in case of turnover, the usual practice is to disable the AD account and select the option of the mailbox [do not appear in the Exchange address list] in the Exchange. In Powershell, the value HiddenFromAddressListsEnabled that controls this option is changed from the default False to True. The figure below is as follows

Here is the actual operation:

Find mailboxes that are not shown in the address list

Get-Mailbox-ResultSize Unlimited | where {$_ .HiddenFromAddressListsEnabled-eq "$true"}

Statistical quantity

Method one: [PS] D:\ > (Get-Mailbox-ResultSize unlimited | where {$_ .HiddenFromAddressListsEnabled-eq "$true"}) .count2639 method two: [PS] D:\ > Get-Mailbox-ResultSize unlimited | where {$_ .HiddenFromAddressListsEnabled-eq "$true"} | Measure-ObjectCount: 2639Average: Sum: Maximum: Minimum: Property: [PS] D:\ >

Obtain account-related information and export it to csv

Get-Mailbox-ResultSize Unlimited | where {$_ .HiddenFromAddressListsEnabled-eq "$true"} | Get-Mailboxstatistics | select DisplayName,TotalItemSize,LastLogonTime | Export-Csv f:\ HiddenAddress.csv-Encoding utf8

In a production environment, it is more accurate to export a table from AD and Exchange to compare disabled accounts.

AD Export disabled account Get-ADUser-Filter {Enabled-eq "false"}-Properties * | select DisplayName,UserPrincipalName,LastLogonDate | sort LastLogonDate-Descending | Export-Csv d:\ disable01.csv-Encoding utf8

The following is a comparison in the Excel table using the DisplayName columns in the two tables

The formula is: = IF (COUNTIF (AJA _ D _ 1) = 1, "repeat", "")

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.