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
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
- 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
- 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
- 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↩