首页 > 解决方案 > 在任务计划程序中执行的 Powershell 问题

问题描述

我有下面的脚本,在他们的工作开始时将用户添加到 o365 组,如下所示:

$DateMaxTime = (Get-date).AddDays(0)
$DateMaxTimeNew = (Get-date).AddDays(-30)

$usersRO = Get-ADUser -Filter * -Properties * -SearchBase "OU=Users,OU=Resources,OU=Romania,OU=DataManagement,DC=USA"|where {$_.Description -like "*TEMP*" -or $_.Description -like "*PERM*" } |select samaccountname,description,name
$groupsRO = '#O365-EXTERNALACCESS'


$FinalResultRO = New-object System.Collections.ArrayList

ForEach($groupRO in $groupsRO){
$membersRO = Get-ADGroupMember -Identity $groupRO -Recursive | Select -ExpandProperty samaccountname
Foreach ($userRO in $usersRO){
$AcountNameRO = $userRO.samaccountname
$DatePartRONew = get-aduser -identity $AcountNameRO -Properties * | Select-Object whenCreated
$DatePartSubsRONew = $DatePartRONew.whenCreated
$DataPartROdesc=$userRO.description
$expressionRO = ([regex]'(\d{2}/\d{2}/\d{4})').Match($DataPartROdesc).Groups[0].Value
$DatePartRO= $expressionRO
$FinalDateRO = [datetime]::ParseExact($DatePartRO,'dd/MM/yyyy',$null)
    If ($DatePartSubsRONew -lt $DateMaxTimeNew){
    Write-Host "$AcountNameRO ouf of date scope"}
    else {Write-Host "$AcountNameRO in scope"
        If ((get-date $FinalDateRO.Date) -eq (get-date $DateMaxTime.Date)){
            Write-Host "$AcountNameRO is a today Starter"
            If ($membersRO -notcontains $AcountNameRO ) {
            Write-Host "Adding external group $groupRO for: $AcountNameRO"
            Add-ADGroupMember -Identity "#O365-EXTERNALACCESS" -Members $AcountNameRO 
            $FinalResultRO.Add((New-Object psobject -Property @{User=$AcountNameRO}))
             } 
            Else {Write-Host "$AcountNameRO  exists in  group $groupRO"}
        }Else {Write-Host "$AcountNameRO is not a Starter"}
        }
    }
}

$listRO = [array]$FinalResultRO |Select User |Out-String
$listRO.gettype()

if [string]::IsNullOrEmpty($listRO){
Write-Host "nothing to send"
}
Else {
Write-Host "Mail sent"
Send-MailMessage -From "mail1@donut.com" -To "mail2@donut.com" -Subject "Following users have been granted external access rights" -smtpServer "donut" -body "$($listRO)"
}

我每天在具有最高权限的任务调度程序中运行此脚本。

由于某些原因,有时在执行脚本时,告诉我用户已添加到组中,但在 Active DIrectory 中没有更改。只有当我第二次运行脚本时(手动在 powershell 上,而不是使用任务调度程序)。

这可能是什么原因?

标签: scheduled-taskspowershell-5.0

解决方案


我会检查这条线

 Add-ADGroupMember -Identity "#O365-EXTERNALACCESS" -Members $AcountNameRO 

即使您的代码由于某种原因遇到一些错误,它也会运行。我会添加一个 try catch 语句来找出问题所在(可能是 DNS、网络、$AcountNameRO 变量的一些问题......)。

try {Add-ADGroupMember -Identity "#O365-EXTERNALACCESS" -Members $AcountNameRO}
catch{

write-host "something went wrong in Add-ADGroupMember"
Send-MailMessage -From "mail1@donut.com" -To "mail2@donut.com" - 
Subject "please check Add-ADGroupMember"
write-host $_
}

当然,在运行计划任务时 write-host 不是一个好主意,因为您看不到输出。所以我会将输出转储到文件或事件日志中或写一封电子邮件。Bill 写了一篇关于日志记录可以做的很好的总结。 https://adamtheautomator.com/powershell-logging/


推荐阅读