An Archive File Collection includes a table named PST_ARCHIVE_FILES, which contains a row for each Archive File in the collection.
PST_ARCHIVE_FILES has the following columns:
| Column Name | Data Type | Description |
|---|---|---|
| ARCHIVE_ID | INTEGER | Archive File ID |
| GUID | CHAR(40) | Archive File GUID |
| ARCHIVE_FILE_NAME | VARCHAR(256) | Archive File name |
| ARCHIVE_DATETIME | TIMESTAMP | Archive File creation date and time |
You can use this table to query context data from the Archive Files in the collection. For example, use the following syntax to find the latest Archive File ID:
SELECT MAX(ARCHIVE_ID) FROM PST_ARCHIVE_FILES