PatchDeployment view
The Reporting2.PatchDeployment view displays Windows patch deployment information.
Column Name | Data Type | Nullable | Description |
|---|---|---|---|
DeployId | int |
| Identifies the deployment associated with this patch. |
DetectedPatchStateId | int |
| The detected patch state id. See {Reporting2].[DetectedPatchState]. |
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 |
| The deployment status Id. See [Reporting2].[DeployState]. |
ResultCode | int | X | The result code from a patch deployment. Common result codes are:
Other error codes are patch specific. |
Content
You can run the following query to display DisplayStateID values and descriptions.
SELECT [Id]
,[Value]
,[Description]
FROM [SecurityControls].[Reporting2].[DeployState]