WindowsPatchType view

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.

Copy
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