Getting mountpoint info is a bit harder in older versions of SQL Server. I used to get the info by using XP_CMDSHELL and WMIC. I changed the output of WMIC from CSV to fixed length because Windows 2k8R2 didn't support the CSV output anymore. The result is inserted in a temporary table so it's easier to remove unwanted rows and format the final output.

CREATE TABLE #dir (result varchar(1000))

--request drive info (result in fixed length)

SET @cmd = 'c:\windows\system32\wbem\wmic volume list brief'

INSERT INTO #dir (result)

EXEC master..xp_cmdshell @cmd

SELECT * FROM #dir