PatchType view
The Reporting2.PatchType 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 Reporting.PatchType view.
SELECT [Id]
,[Value]
,[Description]
FROM [SecurityControls].[Reporting2].[PatchType]
| 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 |