locked
To get list of Updates approved for the group with approved date RRS feed

  • Question

  • I approved the "Update1" to Group1 @ 05,Feb'17 and I approved the same update to Group2 @ 07, Sep'17

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

    If I run this command "GetUpdateApprovals" for the Group1, the output is like below: But actual approval date is 05,Feb'17 

    Current Output:

    Group name: group 1
    
    Update name                   Creation Date
    --------------------------------------------------------------
    Update 1                         07,Sep'17
    

    Please guide me to get (output like below) the exact approved date by using Powershell.

    Expected Output:

    Group name: group 1 Update name Approved Date -------------------------------------------------------------- Update 1 05,Feb'17 Update 2 09,Feb'17

    Or is it possible to get this details from "SUSDB" using SQL query.

    Friday, September 8, 2017 3:10 PM

All replies

  • Hi Sir,

    I'm afraid this information won't be recorded into WSUS database .

    As a workaround you may check the log file "Change.log" under path "C:\Program Files\Update Services\LogFiles":

    Hope it is useful to you .

    Best Regards,

    Elton


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

    • Proposed as answer by Elton_Ji Thursday, September 28, 2017 9:31 AM
    Monday, September 11, 2017 8:30 AM
  • Hi Sir,

    Is there any update ?

    Best Regards,

    Elton


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

    Tuesday, October 17, 2017 9:21 AM