PatchScan view

The Reporting2.PatchScan view displays assessment information.

Column Name

Data Type

Nullable

Description

Id

int

 

The unique identifier.

ConsoleName

nvarchar(100)

 

The console name where this patch was performed.

DefinitionDate

datetime

X

The assessment data definition date.

DefinitionVersion

nvarchar(23)

X

The assessment data definition version.

EndedOn

datetime

 

The date the assessment ended.

IsScanComlete

int

 

Determines if the scan is complete:

0: The scan is not complete.

1: The scan is complete.

Name

nvarchar(255)

X

The scan name.

StartedOn

datetime

X

The date the scan started.

ScanTemplateName

nvarchar(255)

X

The scan template name.

User

nvarchar(256)

X

The name of the user that performed the scan.

SourceTypeId

tinyint

 

The source type id. See Reporting3.SourceType.

ScanTypeId

tinyint

 

The scan type id. See Reporting3.ScanType.