How to Check Storage Type in Engine Database (OLVM)

This is a small how-to post to check the storage type in Engine Database.

Table storage_server_connections has all connections information. Run below command on OLVM to get the connection information:

$ /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "select connection,iqn,port,storage_type from storage_server_connections;"

connection | iqn | port | storage_type
------------------------------+-----+------+--------------

The field storage_type will give:

• value 1 for NFS
• value 3 for iSCSI
• value 6 for local
• value 7 for gluster