We have been working on a WSUS project , and its coming to a close. The client required information on which servers required rebooting to complete a patch.<\/p>\n
We came up with this script<\/p>\n
<\/p>\n
$csvfile=’drive WSUS Scriptsrebootpending.csv’
\nTry{
\n[void][reflection.assembly]::LoadWithPartialName(‘Microsoft.UpdateServices.Administration’)
\n$wsus=[Microsoft.UpdateServices.Administration.AdminProxy]::GetUpdateServer()
\n$computerScope = new-object Microsoft.UpdateServices.Administration.ComputerTargetScope
\n$computerScope.IncludedInstallationStates = [Microsoft.UpdateServices.Administration.UpdateInstallationStates]::InstalledPendingReboot
\n$wsus.GetComputerTargets($computerScope) |
\nSelect FullDomainName,IPAddress,RequestedTargetGroupName |
\nExport-Csv $csvfile -NoType<\/p>\n
}
\ncatch{
\nthrow
\n}<\/p>\n
$smtpServer = “your smtp server”
\n$msg = new-object Net.Mail.MailMessage
\n$att = new-object Net.Mail.Attachment($csvfile)
\n$smtp = new-object Net.Mail.SmtpClient($smtpServer)
\n$msg.From = “your address”
\n$msg.To.Add(“your address”)
\n$msg.Subject = “pending reboots”
\n$msg.Body = “Check attachment:”,$messagebody
\n#”Here is todays copy for ”
\n$msg.Attachments.Add($att)
\n$smtp.Send($msg)
\n#$att.Dispose()<\/p>\n","protected":false},"excerpt":{"rendered":"
We have been working on a WSUS project , and its coming to a close. The client required information on which servers required rebooting to complete a patch. We came up with this script $csvfile=’drive WSUS Scriptsrebootpending.csv’ Try{ [void][reflection.assembly]::LoadWithPartialName(‘Microsoft.UpdateServices.Administration’) $wsus=[Microsoft.UpdateServices.Administration.AdminProxy]::GetUpdateServer() $computerScope = new-object Microsoft.UpdateServices.Administration.ComputerTargetScope $computerScope.IncludedInstallationStates = [Microsoft.UpdateServices.Administration.UpdateInstallationStates]::InstalledPendingReboot $wsus.GetComputerTargets($computerScope) | Select FullDomainName,IPAddress,RequestedTargetGroupName | Export-Csv $csvfile … <\/p>\n