WindowsPatchDeployment view

The Reporting3.WindowsPatchDeployment view displays windows patch deployment information.

Column Name

Data Type

Nullable

Description

DeployId

Int

 

The unique identifier of the deployment.

DetectedPatchStateId

Int

 

The detected patch state id. See WindowsDetectedPatchState view.

DeployScheduledOn

datetime

X

The date the patch was scheduled for deployment (local time).

DeployStartedOn

Datetime

X

The date the patch installation started (GMT).

DeployEndOn

Datetime

X

The date the patch installation ended (GMT).

DeployStateId

Int

X

The deployment status Id. See WindowsDeployState view.

ResultCode

Int

X

The result code from a patch deployment. Common results codes are:

0: Installed, no reboot required

3010: Installed, reboot required

Other error codes are patch specific.