List / search files from all shared drives

Lists or searches files across all shared drives the user can access. Set DriveType='allDrives' with SupportsAllDrives and IncludeItemsFromAllDrives. Optionally use Query to filter.

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