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]