Enterprise Recon 2.6.1

Scan Report Metadata

The SCANREPORT_META table contains the reported location metadata information for each scan across 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 START timestamp NOT NULL Timestamp when the scan started.
4 END timestamp NOT NULL Timestamp when the scan completed.
5 LOCATION varchar(4096) NOT NULL Full path for the match location.
6 CUID integer NOT NULL Data type or criteria UID. See DATA_MATCH_TYPES table for more information.
7 METAID integer NOT NULL ID for the reported metadata type. See DATA_META table for more information.
8 VALUE varchar(128) NOT NULL Metadata value for the specific data type and reported metadata ID.

Sample data:

TUID REPORTID START END LOCATION CUID METAID VALUE
8283249956251157105 1594997719 10/7/2020 8:07:13 PM 10/7/2020 11:48:48 PM File path D:\MyDataFile.txt 44 19 BUILTIN\Administrators
8283249956251157105 1594997719 10/7/2020 8:07:13 PM 10/7/2020 11:48:48 PM File path D:\MyDataFile.txt 24 18 Jun, 24 2018 12:57
7372383963774995752 1598512019 27/8/2020 3:06:54 PM 27/8/2020 3:07:00 PM File path /home/ubuntu-machine/Documents/pii-data-zipfile.zip->pii-data-1.xlsx->worksheets/sheet1 1 11 axlsx