WSUS results to be sent

Question

Hello,

From this results seen in windows update
is it possible to get a report or an email or a text with the same information?

I am asking this as I have a team which is working on application and during the patching they have various task to do...

Updated plan:

Manual tasks...
Move BITEDWDBVSQL to BITEDWDB01 8:00pm
Move AG from BITEDWDB03 to BITEDWDBVSQL 8:00pm
Notify Server team via teams, emails, text... that the servers are ready for patching

Automatic tasks on schedule...
BITEDWDB02 Thursday 25, 2021 9 PM patching starts
BITEDWDB03 Thursday 25, 2021 9 PM patching starts

Confirm by receiving teams, email, text... the servers names and the list of patches applied with their status successful, failed, waiting reboot etc... that the 02 and 03 servers are done with patching

Manual tasks...
Move AG from BITEDWDBVSQL to BITEDWDB03 12:00am
Move BITEDWDBVSQL to BITEDWDB02 12:00am
Notify Server team via teams, emails, text that the 01 server is ready for patching.

Automatic tasks on schedule...
BITEDWDB01 Friday 26, 2021 1 AM patching starts

Confirm by receiving teams, email, text... the server name and the list of patches applied with their status successful, failed, waiting reboot etc... that the 01 server is done with patching

Thanks,
Dom

Answer

Hi Dominique DUCHEMIN,

Please refer to the below script by the PowerShell to see whether this issue will be resolve or not:

# Get OS info  
$OsInfo = Get-CimInstance -ClassName Win32_OperatingSystem  
  
Get-Hotfix | # Get HotFixes  
Sort-Object -Property InstalledOnfunction | # Sort them  
Select-Object -Property @( # Select required fields  
  
    # Add Caption property from $OsInfo variable  
    @{  
        Name = 'Caption'  
        Expression = {$OsInfo.Caption}  
    }  
  
    # Add CSDVersion property from $OsInfo variable  
    @{  
        Name = 'CSDVersion'  
        Expression = {$OsInfo.CSDVersion}  
    }  
  
    # Add ServicePackMajorVersion property from $OsInfo variable  
    @{  
        Name = 'ServicePackMajorVersion'  
        Expression = {$OsInfo.ServicePackMajorVersion}  
    }  
  
    # Add BuildNumber property from $OsInfo variable  
    @{  
        Name = 'BuildNumber'  
        Expression = {$OsInfo.BuildNumber}  
    }  
  
    # Add other properties from original HotFix object  
    'CSName'  
    'HotfixID'  
    'Description'  
    'InstalledBy'  
    'InstalledOn'  
  
) | Export-Csv -NoTypeInformation -Path 'c:\Windows\Temp\win-patch.csv'

Reference link:
https://stackoverflow.com/questions/48488767/save-the-powershells-output-in-a-csv-file

Hope the above will be helpful. Please keep us in touch if there are any updates of the case.

Regards,
Rita

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

WSUS results to be sent

1 answer