Getting Information About Devices and Mirrors

For a report on all SAP ASE devices on your system (user database devices and their mirrors, as well as dump devices), execute sp_helpdevice.

See the Reference Manual: Procedures.