如何用powershell导出AD用户信息到CSV中并发送到本地邮箱中

如何用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 =