Try below query.
select id from host where type = 'SecondaryStorageVM';

regards
sadhu
-----Original Message-----
From: Mohd Zainal Abidin Rabani [mailto:zai...@nocser.net] 
Sent: Tuesday, February 2, 2016 9:57 AM
To: users@cloudstack.apache.org
Subject: Secondary Storage not available in mysql

Hi,

I want to change ip address for secondary storage. But when i query select id 
from host where type = 'SecondaryStorage';

It return 0, mean no value. Am i make mistake or data not there?

---------
Regards,
Mohd Zainal Abidin Rabani
Technical Support

ModernOne Data Solutions Sdn. Bhd.(1119382-D) No. 83-2, Jalan TKS 1, Kajang 
Sentral, 43000 Kajang, Selangor.
T : 03-8737 0030 | F : 03-8737 0070
E : zai...@nocser.net
W : www.modern.com.my | www.nocser.net

Reply via email to