Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData ODBC Driver for Microsoft SharePoint Views


Name	Description
AllEvents	Presents a comprehensive collection of SharePoint event records, detailing timing, location, attendees, and associated metadata for effective event management.
AllFiles	Retrieves all files and folders across all document libraries on a SharePoint site, including metadata details. Useful for auditing, bulk processing, and data migration.
AllLists	Lists all available SharePoint lists within the domain, including system fields and metadata. Essential for identifying and managing lists across the SharePoint environment.
AllPages	Presents a comprehensive collection of SharePoint site pages, providing details about content, layout, creation information, permissions, and associated metadata for effective page management.
Attachments	Retrieves attachments associated with a specific list item in a SharePoint list. Helps manage and track attached files related to SharePoint items.
Comments	Contains details about comments made on SharePoint items, including authorship, content, replies, and metadata. Useful for monitoring discussions and user interactions.
Files	Retrieves file attachments associated with a specific SharePoint list item. Facilitates file management and ensures access to necessary attachments.
Groups	Retrieves group details from a SharePoint site, including membership, permissions, and ownership settings. Essential for managing access control and security within SharePoint.
Lists	Returns SharePoint lists.
ListItems	Represents all items within SharePoint lists, including standard columns applicable across different lists. Useful for bulk data extraction and reporting.
RoleAssignmentMember	Retrieves details about members assigned to specific roles within SharePoint site permissions. Helps in auditing and managing user access rights.
RoleAssignments	Retrieves role assignments configured on a SharePoint site, including users and groups with access. Useful for reviewing and managing SharePoint security policies.
RoleDefinitionBindings	Lists role definitions bound to specific security groups or users within a SharePoint site. Helps administrators enforce permission policies.
Roles	Provides details about available role definitions, including permission levels within a SharePoint site collection. Essential for setting up and modifying security roles.
Sites	Retrieves a list of all available sites within the SharePoint server, including metadata and site details. Useful for managing and navigating large SharePoint deployments.
Subsites	Lists all subsites under a specified SharePoint site, including hierarchy and metadata. Helps in structuring and organizing content within a SharePoint environment.
Users	Retrieves a list of users and their assigned roles within a SharePoint site or group. Important for managing permissions and user activity tracking.