sql - Powershell 脚本 - 向所有输出的用户发送电子邮件

Question

这是我下面的代码 - 我是 Powershell 的新手，所以我正在寻找一种方法来向所有输出的用户发送电子邮件，并使用输出的 CSV 文件向自己发送电子邮件？

get-module azuread
$Credential = Get-Credential
Connect-AzureAD -Credential $Credential
 $dt = (Get-Date).AddDays(-90)
$Users = Get-AzureADUser -Top 100000 | Where {$_.UserPrincipalName -like "*gmail.com"} | Select UserPrincipalName,ObjectId
$Users | ForEach-Object {
Get-AzureADDevice -All:$true | Where {$_.ApproximateLastLogonTimeStamp -le $dt} 
$user = $_
Get-AzureADUserRegisteredDevice -ObjectId $user.ObjectId | ForEach-Object {
$Result += New-Object PSObject -property @{ 
DeviceOwner = $user.UserPrincipalName
DeviceName = $_.DisplayName
DeviceOSType = $_.DeviceOSType
ApproximateLastLogonTimeStamp = $_.ApproximateLastLogonTimeStamp 
IsCompliant = $_.IsCompliant
}
}
}

谢谢你

标签： sqlpowershellemailsend