In an effort to help our SAN team admins, Windows Servers admins, and DBA's, I am trying to build a web page that will allow them to correlate what SAN attached server disks are being used by what applications. I have a way of quering the SAN which gives me a list of disks presented to the server. Included in this output is a "PHYSICALDISK_n" where n represents a number corresponding to a disk number (0, 1, 2, .... n). This number directly correlates to the "disk number" one sees if they look at disk manager on a windows server.

From the Windows side I need to be able to query the disks seen by the bios including the disk_number, and label. Other than using the disk manager gui, I have not been able to find any way to query this data from the command line.

Any help or suggestions would be greatly appreciated.