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


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