sys.dm_os_enumerate_fixed_drives

Description

Starting with SQL Server 2017 (14.x) CU 1, volumes mounted to drive letters like For SQL Server 2019 (15.x) and previous versions, requires VIEW SERVER STATE permission on For SQL Server 2022 (16.x) and later versions, requires VIEW SERVER PERFORMANCE STATE Dynamic Management Views and Functions (Transact-SQL) I/O Related Dynamic Management Views and Functions (Transact-SQL)

Syntax

sys.dm_os_enumerate_fixed_drives