select low/16777216 "vdevno", name, phyname from master..sysdevices where status&=2 order by 1

Warning! For vdevno>127 it could generate incorrect results.