---
title: WindowsPatchType view
slug: isec/help/enu/windowspatchtype-view
createdAt: 2026-08-05T05:48:31.620Z
---

The Reporting3.WindowsPatchType view defines windows patch types.

| Column Name | Data Type     | Nullable | Description                                 |
| ----------- | ------------- | -------- | ------------------------------------------- |
| Id          | int           |          | The patch type ID.                          |
| Value       | nvarchar(100) |          | The string value of the ID.                 |
| Description | nvarchar(256) | X        | Provides a simple description of the value. |

## Content

You can run the following query to verify the contents of the Reporting3.WindowsPatchType view.

```sql
SELECT [Id]
,[Value]
,[Description]
FROM [SecurityControls].[Reporting3].[WindowsPatchType]
```

| Id | Value                 | Description                 |
| -- | --------------------- | --------------------------- |
| 0  | Security Patches      | Microsoft Security Patches. |
| 1  | Security Patches      |                             |
| 2  | Software Distribution |                             |
| 3  | Security Tools        |                             |
| 4  | Non-security Patches  |                             |
| 6  | Custom Actions        |                             |
