Enterprise Recon 2.11.0
Scan Report Summary
The SCANREPORT_SUMMARY table contains scan report information including the match count, matched data types, matched samples, scanned bytes, start time, and other scan-related information for all Targets.
| Column Number | Column Name | Data Type | Description |
|---|---|---|---|
| 1 | TUID | numeric NOT NULL | Target UID. See DATA_TARGET table for more information. |
| 2 | REPORTID | varchar(64) NOT NULL | Report ID. This is the concatenated value of the report timestamp (in Unix time format) and scan ID for the scan. |
| 3 | CUID | numeric NOT NULL | Data type or criteria UID. See DATA_MATCH_TYPES table for more information. |
| 4 | LABEL | varchar(4096) NOT NULL | Scan schedule label. |
| 5 | ROOT | varchar(4096) NOT NULL | Scan root path. See Data Usage Calculation for more information on scan roots. |
| 6 | START | timestamp NOT NULL | Timestamp when the scan started. |
| 7 | END | timestamp NOT NULL | Timestamp when the scan completed. |
| 8 | FAILED | integer NOT NULL | Flag is set to 1 for failed scans. |
| 9 | STOPPED | integer NOT NULL | Flag is set to 1 for if scan was stopped. |
| 10 | LOCATIONS | numeric NOT NULL | Number of locations scanned for the given scan root path. |
| 11 | BYTES | numeric NOT NULL | Number of bytes scanned for the given scan root path. |
| 12 | INACCESSIBLE | numeric NOT NULL | Number of inaccessible locations for the given scan root path. |
| 13 | MATCHES | numeric NOT NULL | Sum of test data matches, matches with data privacy breaches and matches containing prohibited PCI data for the specific data type. |
| 14 | SAMPLES | numeric NOT NULL | Number of test, match and prohibited data samples captured for the specific data type. |
Sample data:
| TUID | REPORTID | CUID | LABEL | ROOT | START | END | FAILED | STOPPED | LOCATIONS | BYTES | INACCESSIBLE | MATCHES | SAMPLES |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6622288671022978211 | 1598337150 | 93 | MY-UBUNTU-MACHINE AUG25-1702 | File path /home/ubuntu-machine/Documents/pii-data.csv | 25/8/2020 5:04:34 PM | 25/8/2020 5:04:34 PM | 0 | 0 | 1 | 81077 | 1 | 30 | 30 |
| 6622288671022978211 | 1598337150 | 165 | MY-UBUNTU-MACHINE AUG25-1702 | File path /home/ubuntu-machine/Documents/pii-data.csv | 25/8/2020 5:04:34 PM | 25/8/2020 5:04:34 PM | 0 | 0 | 1 | 81077 | 1 | 15 | 15 |
| 7372383963774995752 | 1598337296 | 6 | MariaDB-Table-Scan | MariaDB Server MY-MARIADB-SERVER:3308 Catalog employee-db Table employee-info | 20/7/2020 12:26:42 PM | 20/7/2020 12:53:11 PM | 0 | 0 | 1 | 153311 | 0 | 2 | 2 |
| 7372383963774995752 | 1598337296 | 32 | MariaDB-Table-Scan | MariaDB Server MY-MARIADB-SERVER:3308 Catalog employee-db Table employee-info | 20/7/2020 12:26:42 PM | 20/7/2020 12:53:11 PM | 0 | 0 | 1 | 153311 | 0 | 1 | 1 |
| 8283249956251157105 | 1598346228 | 239 | 1598346228 | Dropbox Business ADMIN@EXAMPLE.COM Location file-name.pdf | 10/9/2020 3:42:07 PM | 11/9/2020 8:51:08 AM | 0 | 0 | 1 | 182245 | 1 | 33 | 33 |
| 8283249956251157105 | 1598346228 | 234 | 1598346228 | Dropbox Business ADMIN@EXAMPLE.COM Location file-name.pdf | 10/9/2020 3:42:07 PM | 11/9/2020 8:51:08 AM | 0 | 0 | 1 | 182245 | 1 | 11 | 11 |