---
title: PatchDeployment view
slug: isec/help/enu/patchdeployment-view
createdAt: 2026-08-05T05:48:31.107Z
---

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\]](docId\:ZZxx7lsyrAOadDWnLY0zu).                                                                                                |
| ResultCode           | int       | X        | The result code from a patch deployment. Common result codes are:<br />- 0: Installed, no reboot required<br />- 3010: Installed, reboot required<br />Other error codes are patch specific. |

### Content

You can run the following query to display DisplayStateID values and descriptions.

```bash
SELECT [Id]
,[Value]
,[Description]
FROM [SecurityControls].[Reporting2].[DeployState]
```
