Please answer the question I posed.

SQL will show local drives on the node it is on I believe. I believe it will not show drives that are in another resource group even if that resource group in currently owned by that node. It will show disks that are in the resource group with SQL.

CEWII