WSUS results to be sent

Dominique DUCHEMIN 831 Reputation points
2021-02-27T00:17:20.2+00:00

Hello,

From this results seen in windows update 72557-2021-02-26-16-04-11-wsus-report.png
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

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,449 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Rita Hu -MSFT 9,626 Reputation points
    2021-03-01T03:17:53.953+00:00

    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.

    0 comments No comments