Welcome to the forums. Though its not a direct-SQL question, but still valid that its related to SQL Management so here is your answer: There are few ways to find the information about the hardware, thru Control Panel or registry or WMI etc. On that server goto Control Panel --> Administrative Tools --> Computer Management ---> Disk management. Also from command prompt and type "net use" to get a list of drive letters and mappings. These could be NAS, SAN etc but all other drives not listed should be local. See this KBA http://support.microsoft.com/kb/300415 too.
