FileVersions
Lists all available versions of a document stored in SharePoint, including version history details. Useful for tracking changes and restoring previous document versions.
View Specific Information
To return results from this view, you must specify both the Library and File columns.
Sample Query
The following query retrieves all versions of the file MyExcelFile.xlsx located in the Documents/testd library:
SELECT * FROM FileVersions WHERE Library = 'Documents/testd' AND File = 'MyExcelFile.xlsx';
Columns
| Name | Type | Description |
| ID [KEY] | String | A unique identifier for the file version. Useful for tracking and managing version history. |
| Comments | String | User-provided comments about the particular file version. Helps document changes or provide context for modifications. |
| CreateBy | String | The username of the SharePoint user who modified this version of the file. Useful for tracking authorship and accountability. |
| Date | Datetime | The date and time when this version of the file was created. Helps monitor file updates and changes over time. |
| Size | String | The size of this specific version of the file. Useful for storage management and version comparison. |
| Url | String | The URL path to access this specific version of the file. Helps users retrieve or download older versions. |
| Library | String | The name of the SharePoint document library where the file is stored. A library must be specified to retrieve file versions.
The default value is Shared Documents. |
| File | String | The name of the file for which versions are being listed. A file must be specified to retrieve its version history. |