如何用powershell导出AD用户信息到CSV中并发送到本地邮箱中
文中各个文件的命名可自己按需要更改,脚本基于powershell2.0
<#
Monthly AD User report
Writen by SanilInHighway
Updated on 17/08/2015 prototype
Updated on 18/08/2015 details improve
Updated on 01/12/2015 add send email code
Updated on 18/05/2016 format date output
Updated on 1/06/2015 update output of $PasswordExpirationDate & $PasswordLastSet
#>
$start = Get-Date
$array = @()
$DC='RAINBOW.domain.internal'
Clear-Content .\MonthReport_user.csv #清除原有数据
$AllUsers = get-aduser -Server $DC -Filter * #获取AD域中的所有用户
# $AllUsers = Get-Content .\UserID.txt
# $AllUsers = get-aduser -Server $DC -Filter * -Searchbase "OU=Support,OU=Accounts,OU=Customer,OU=Administration,DC=domain,DC=internal" #获取AD域指定OU目录下的用户
foreach ($user in $AllUsers ) {
#获取用户所有属性,针对用户的各个属性进行筛选赋值,方便格式化输出到csv中
$userinfo = Get-ADUser -Server $DC -Identity $user -Properties *
if ( $userinfo.Mail -eq $null){
$mail = "No EA Email"}
else{
$mail =$userinfo.Mail }
if($userinfo.Department -eq $null){
$Department = "Not Provided"}
else{
$Department =$userinfo.Department}
if($userinfo.Company -eq $null){
$Company =