---
title: PatchScan view
slug: isec/help/enu/patchscan-view
createdAt: 2026-08-05T05:48:31.522Z
---

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:<br />`0`: The scan is not complete.<br />`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.                                                              |   |
