How to view Updates Approved date in WSUS server by using powershell RRS feed

  • Question

  • I can able to find the Creation date by using the command GetUpdateApprovals.

    But I approved the "Update123" to Group1 @ 01,Jan'17

    and I approved the same update to Group2 @ 07, Sep'17 

    This command's output showing the same creation date for both groups.

    Current Output:

    Group name       Creation Date


    Group1              07, Sep'17

    Group2              07, Sep'17

    Please guide me to view the exact approval date from Powershell. 

    I need output like below:

    Group name: Group1

    Update name    Approval Date


    Update1              05, Feb'17

    Update2              25, Aug'17



    Update Name: Update1

    Group Name             Approved Date


    Group 1                  06, Feb'17

    Group 2                  07, Aug'17

    • Edited by ArjunanV Thursday, September 7, 2017 3:05 PM Updated the output view
    • Moved by jrv Thursday, September 7, 2017 3:49 PM Better forum.
    Thursday, September 7, 2017 1:37 PM

All replies

  • If you know the KB # you can parse the change.log file

    get-content 'C:\Program Files\Update Services\LogFiles\Change.log' | Where-Object {$_ -match "install" -and $_ -match "KB938759"}

    • Proposed as answer by Mike01234 Thursday, September 7, 2017 2:19 PM
    Thursday, September 7, 2017 2:08 PM
  • Hello,

    As far as I know, there is no such record for approval data in WSUS DB. 

    Therefore, you can't retrieve that either from WSUS console or PowerShell cmdlets.

    As a workaround, you may get the info for approval data from the log file located at 

    C:\Program Files\Update Services\LogFiles\Change.log

    Best regards,

    Andy Liu

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, September 8, 2017 9:25 AM