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