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