List / search files from a single shared drive

Lists or searches files in one shared drive. Supply DriveId and set DriveType='drive', SupportsAllDrives='true', and IncludeItemsFromAllDrives='true'. Optionally use Query to filter.

SELECT * FROM Files
WITH(
	--Query='name contains "ZappySys*.*"',
	DriveId='0AFWIggplk2z6Uk9PVA',
	DriveType='drive',
	SupportsAllDrives='true',
	IncludeItemsFromAllDrives='true'
)