Enterprise Recon 2.12.0
Target Match History
The DATA_TARGET_HISTORY table contains historical match count data for all Targets with a maximum granularity of a one day period. If there is more than one scan data point within a 24-hour period, the latest data point captured within that period will be retained.
| Column Number | Key | Column Name | Data Type | Description |
|---|---|---|---|---|
| 1 | Yes | TUID | numeric NOT NULL | Target UID. See DATA_TARGET table for more information. |
| 2 | - | WHEN | timestamp NOT NULL | Timestamp when the data point was recorded. |
| 3 | - | QUANTITY | numeric NOT NULL | Sum of matches with data privacy breaches and matches containing prohibited PCI data; does not include test data matches. |
Sample data:
| TUID | WHEN | QUANTITY |
|---|---|---|
| 6622288671022978211 | 3/9/2020 2:45:16 PM | 7439 |
| 6622288671022978211 | 25/8/2020 2:35:05 PM | 209800 |
| 7372383963774995752 | 3/9/2020 2:40:41 PM | 9458 |
| 7372383963774995752 | 28/8/2020 2:27:31 PM | 18902 |
| 8283249956251157105 | 23/7/2020 7:52:33 PM | 2543586 |
| 8283249956251157105 | 17/7/2020 10:56:20 PM | 3095985 |