none
WSUS Approval date RRS feed

  • Question

  • I need to find the DATE that an update is approved and/or declined using powershell on a wsus server.

    I beleive this is stored within wsus but cannot find the appropriate command to reteive it using powershell.

    Any assistance appriciated

    Robert

    Tuesday, September 5, 2017 5:43 AM

Answers

  • This is the approval view:

    PUBLIC_VIEWS.vUpdateApproval

    Returns one row with approval information for each update and computer group if the update is approved to that computer group. The values of UpdateApprovalId are unique. In addition, the values of the combination UpdateId/ComputerTargetGroupId are unique.

                           
      

    Column name

      
      

    Data type

      
      

    Description

      
      

    Matching API property

      

    UpdateApprovalId

    uniqueidentifier

    Identifier that   uniquely identifies the update approval.

    Id

    UpdateId

    uniqueidentifier

    Update identifier   from PUBLIC_VIEWS.vUpdate.

    UpdateId

    ComputerTargetGroupId

    uniqueidentifier

    Computer group   identifier from PUBLIC_VIEWS.vComputerGroup.

    ComputerTargetGroupId

    Action

    nvarchar(11)

    Action that the   client performs when applying the update.

    Action

    Deadline

    datetime

    Date and time in   UTC by when a computer will be forced to apply the update.

    Deadline

    CreationDate

    datetime

    Date and time in UTC an administrator approved the   update

    CreationDate

    AdministratorName

    nvarchar(385)

    Name of the   administrator who approved the update

    AdministratorName

    IsOptional

    bit

    Specifies whether   an update is optional to a computer receiving this approval.

    IsOptional

    IsStale

    bit

    Specifies whether   this approval is for an older revision of the update.

    n/a


    \_(ツ)_/

    Tuesday, September 5, 2017 6:58 AM

All replies