What is Quick access?
Quick access makes it simple to find your frequently used storage locations, including recently used shared libraries, channels, and folders.1
With offline mode enabled, it is possible to reconstruct this interface using locally stored data.Microsoft.FileUsageSync.db
Microsoft.FileUsageSync.db contains the data used to populate the Quick Access interface. This file is located at:
%LOCALAPPDATA%\Microsoft\OneDrive\ListSync\Business<1-9>\settings
.
Three tables within this database are of particular interest:
- quick_access
- quick_access_formatted
- quick_access_metadata
Together, these tables store information such as pin states, site acronyms, and associated site icons.
quick_access table
The quick_access table provides foundational metadata for each entry in the Quick Access list. It contains the following fields:- ListId
- WebId
- SiteId
- LastAccessDateTime
- PinnedOrder
The purpose of the PinnedOrder
value remains unclear, though it likely determines display order for pinned items.
quick_access_formatted table
The quick_access_formatted table holds the majority of the structured data required to rebuild the Quick Access interface. It includes:- ListId
- WebId
- SiteId
- Format
- QuickAccessRecent
- PinnedItem
- QuickAccessPinned
- FormattedValue
Each Format
type corresponds to a specific category of item behavior:
- QuickAccessRecent - recently accessed items
- PinnedItem - generated when an item is pinned
- QuickAccessPinned - created or removed when the Quick Access endpoint is updated
The FormattedValue
field contains a JSON structure that varies by format type. This structure includes key attributes such as access URLs, titles, colors, icons, and metadata necessary for UI reconstruction.
FormattedValue Header | PinnedItem | QuickAccessRecent | QuickAccessPinned |
---|---|---|---|
accessUrl | X | X | |
containerTitle | X | X | |
contentClass | X | X | |
color | X | ||
favoritesOrder | X | ||
icon | X | ||
isDefaultDocumentLibrary | X | X | |
isDocLib | X | ||
isTeamsChannelSite | X | X | |
isTeamsConnectedSite | X | X | |
lastAccessDateTime | X | X | |
lastPolled | X | ||
listId | X | X | X |
listItemId | X | X | |
listUrl | X | ||
order | X | ||
operation | X | X | |
pinOrder | X | ||
siteAcronym | X | X | |
siteColor | X | X | |
siteIconUrl | X | ||
siteId | X | X | X |
siteTitle | X | ||
siteUrl | X | ||
spoId | X | X | |
title | X | X | X |
uniqueId | X | X | |
webId | X | X | X |
webTemplateConfiguration | X | ||
webUrl | X | X |
quick_access_metadata table
The quick_access_metadata table tracks synchronization details that define the operational state of Quick Access. Its fields include:- SyncEndpoint
- QuickAccessEndpoint
- PinnedItemsEndpoint
- InitialSyncComplete
- ResyncRequired
- SyncedVersion
- LastSyncTime
*Note: If QuickAccessEndpoint is older than PinnedItemsEndpoint, QuickAccessPinned is out of sync. It takes roughly two minutes to sync when a pin state changes
Reconstructing the Quick Access Interface
Below is an example 'FormattedValue' from the quick_access_formatted table:
{ "title": "IT Security", "siteAcronym": "IS", "siteColor": "#1C4259", "siteIconUrl": "https://contoso.sharepoint.com/sites/IT%20Security/_layouts/15/images/siteicon.png", "siteUrl": "https://contoso.sharepoint.com/sites/IT%20Security", "accessUrl": "https://contoso.sharepoint.com/sites/IT%20Security/Shared%20Documents", "isDefaultDocumentLibrary": 1, "isTeamsConnectedSite": 1, "listId": "a51d76a5-7b26-4b33-8d55-4cfbc656038a", "webId": "c5e85660-c9b0-4268-ad8b-23e1f862dd1c", "siteId": "e34301fe-78ae-4a23-9984-bf7edfc744f7", "lastAccessDateTime": "2025-09-29T14:38:00Z" }
JSON Field | UI Element or Behavior |
---|---|
title | Main display text on the card |
siteAcronym | Initials displayed inside the colored tile |
siteColor | Tile background color |
siteIconUrl | Optional site icon (overrides acronym if present) |
siteUrl | Base site link (used for hover or metadata) |
accessUrl | Clickable target for user navigation |
Format (table column) | Determines grouping (Recent, Pinned, etc.) |
PinnedOrder (from quick_access) | Determines on-screen position |
Visual Breakdown
SQL query to extract data from quick_access and quick_access_formatted
SELECT qf.Format, qa.PinnedOrder, json_extract(qf.FormattedValue, '$.pinOrder') AS pinOrder, json_extract(qf.FormattedValue, '$.order') AS "order", json_extract(qf.FormattedValue, '$.favoritesOrder') AS favoritesOrder, json_extract(qf.FormattedValue, '$.spoId') AS spoId, json_extract(qf.FormattedValue, '$.siteId') AS siteId, json_extract(qf.FormattedValue, '$.webId') AS webId, json_extract(qf.FormattedValue, '$.listId') AS listId, json_extract(qf.FormattedValue, '$.uniqueId') AS uniqueId, json_extract(qf.FormattedValue, '$.lastPolled') AS lastPolled, json_extract(qf.FormattedValue, '$.lastAccessDateTime') AS lastAccessDateTime, json_extract(qf.FormattedValue, '$.title') AS title, json_extract(qf.FormattedValue, '$.siteTitle') AS siteTitle, json_extract(qf.FormattedValue, '$.containerTitle') AS containerTitle, json_extract(qf.FormattedValue, '$.accessUrl') AS accessUrl, json_extract(qf.FormattedValue, '$.listUrl') AS listUrl, json_extract(qf.FormattedValue, '$.webUrl') AS webUrl, json_extract(qf.FormattedValue, '$.siteUrl') AS siteUrl, json_extract(qf.FormattedValue, '$.operation') AS operation, json_extract(qf.FormattedValue, '$.contentClass') AS contentClass, json_extract(qf.FormattedValue, '$.listItemId') AS listItemId, json_extract(qf.FormattedValue, '$.isDocLib') AS isDocLib, json_extract(qf.FormattedValue, '$.isDefaultDocumentLibrary') AS isDefaultDocumentLibrary, json_extract(qf.FormattedValue, '$.isTeamsConnectedSite') AS isTeamsConnectedSite, json_extract(qf.FormattedValue, '$.isTeamsChannelSite') AS isTeamsChannelSite, json_extract(qf.FormattedValue, '$.siteAcronym') AS siteAcronym, json_extract(qf.FormattedValue, '$.color') AS color, json_extract(qf.FormattedValue, '$.siteColor') AS siteColor, json_extract(qf.FormattedValue, '$.icon') AS icon, json_extract(qf.FormattedValue, '$.siteIconUrl') AS siteIconUrl, json_extract(qf.FormattedValue, '$.siteLogoUrl') AS siteLogoUrl, json_extract(qf.FormattedValue, '$.webTemplateConfiguration') AS webTemplateConfiguration FROM quick_access AS qa JOIN quick_access_formatted AS qf ON qa.ListId = qf.ListId AND qa.WebId = qf.WebId AND qa.SiteId = qf.SiteId;
Referecnces
-
https://support.microsoft.com/en-us/office/getting-started-with-quick-access-eb533c0a-7ee9-40d4-8d29-0a88cc9e0231↩