Get information about a shared drive

Returns details for a shared drive, typically filtered by search query (e.g. name).

SELECT * FROM SharedDrives WITH(Query='name = "HR"')