I've checked several Hitachi storages in our lab and in SNIA lab and find out that all of them support CQL (CIM Query Language - DMTF DSP0202).
Supported communication mechanism can be obtained from HITACHI_CIMXMLCommunicationMechanism instance
FunctionalProfileDescriptions : Basic Read, Basic Write, Instance Manipulation, Association Traversal, Query Execution,
But only "Basic Query" feature is suppored. CIM_QueryCapabilities instance:
InstanceID : 10.6.153.41.QueryCapabilities
ElementName : Query Capabilities
CQLFeatures : 2,
Caption : Query Capabilities
Description : Query Capabilities
XPathFeatures : 0
Generation : 0
I tried to execute several queries - some of them works , others don't. Even samples from DMTF DSP0202 don't work.
SELECT * FROM HITACHI_ThinProvisioningPool - works
SELECT * FROM CIM_StoragePool - doesn't, CIM_ERR_INVALID_QUERY
SELECT * FROM HITACHI_ThinProvisioningPool WHERE PoolID = 'ThinProvisioningPool.0' - doesn't, CIM_ERR_INVALID_QUERY
Why this queries returns CIM_ERR_INVALID_QUERY, Hitachi SMI-S provider doesn't implement "CIM Query Language" correctly?