The engine is the same everywhere; what differs is the tables. The explorer recognises the databases below by their table names and adds a tab that explains them. Dates in the tables are FILETIMEs (100-nanosecond ticks since 1601), stored in Currency, Long long or 8-byte Binary columns; the explorer shows them as dates in the columns that Windows uses for times.
Windows Search: Windows.edb
The search index of Windows Vista and later. SystemIndex_PropertyStore has one row for each indexed item and one column for each property that is indexed (hundreds).
The column names carry the mapping: 4678-System_ThumbnailCacheId is property number 4678, the property System.ThumbnailCacheId; a name that starts with a
number and an F, such as 13F-System_Size, is a column of the same kind with a smaller number. WorkID is the item's number.
SystemIndex_Gthr holds the crawl state of each item (scope, document id, last modified time, flags, file name) and SystemIndex_GthrPth the folder
tree: a scope and its parent.
The thumbnail cache id
The column System_ThumbnailCacheId holds eight bytes for each file whose thumbnail Windows made. Read as a little-endian 64-bit number it is the entry hash of that file's thumbnail in the
thumbnail cache files (and in the index file beside them), so a thumbnail can be traced to its file: the
item's System.ItemPathDisplay, else its System.ItemUrl, names it. The explorer does this when Windows.edb is dropped together with the
thumbcache_*.db files. How Windows computes the number from the file is not documented; the thumbnail cache page says what was tried.
WebCache: WebCacheV01.dat
The cache, cookie, history and download index of Internet Explorer and Edge (EdgeHTML). Containers has a row for each container (Content, Cookies, History, DOMStore and others) with its
directory; the entries of container N are in the table Container_N, with the address (Url), the cache file name, sizes and the times of creation, modification, access and expiry.
SRUM: SRUDB.dat
The System Resource Usage Monitor records resource use per application and per user. Each provider has a table named by its GUID, with a row for each time interval; applications and users in
those rows are numbers that SruDbIdMapTable turns into a path, a service name or, for type 3, a SID. The explorer names these providers: Application Resource Usage
{D10CA2FE-6FCF-4F6D-848E-B2E99266FA89}, Network Data Usage {973F5D5C-1D90-4944-BE8E-24B94231A174}, Network Connectivity Usage
{DD6636C4-8929-4683-974E-22C046A43763}, Energy Usage {FEE4E14F-02A9-4550-B5CE-5FA2DA202E37} (and the long-term table with LT added), App Timeline
{5C8CF1C7-7257-4F13-B223-970EF5939312} and vfuprov {7ACBBAA3-D029-4BE4-9A7A-0885927F1D8F}. Other GUIDs are listed without a name.
Active Directory: NTDS.dit
datatable has one row for each object of the directory, with one column for each attribute, named ATT, a letter and the attribute's number (for example ATTm3);
the letter goes with the column type. link_table holds links between objects, sd_table the shared security descriptors and hiddentable the database's own settings.
Only the X.500 attributes, whose number is the last part of their OID 2.5.4.n, are named by the explorer (n up to 58: 3 is cn, 13 description, 49 distinguishedName);
the other numbers are assigned by the schema stored in the database itself, which the explorer does not decode. Password hashes and keys are encrypted attribute values and appear as bytes.
Others
- Windows Update:
DataStore.edbwithtbUpdates,tbFiles,tbHistoryand others. - Certificate services: a certificate authority's
.edbwithRequests,Certificates,AttributesandCRLs; the certificate itself is the DER bytes of the columnRawCertificate. - Exchange: mailbox and public folder databases are ESE databases with Exchange's own tables, which the explorer shows as plain tables.
Not described
Known, not yet covered
- Viewer: the thumbnail lookup was written from the columns and values of a real
Windows.edband the findings of the thumbnail cache pages; noWindows.edband thumbnail cache from the same machine were available to check it end to end. - Viewer: the names of the SRUM providers not listed above, and the attribute numbers of Active Directory beyond the X.500 ones.
Unknown
- Reference: how Windows 10 and 11 compute a file's thumbnail cache id; see the thumbnail cache page.
Links
Reference
- Extensible Storage Engine (ESE) Database File (EDB) format – the engine under all of these
- Windows Search – Microsoft's documentation of the search index and its properties