➜  openshift oc -n enmasse-infra rsh infinispan-0 curl 'http://app:test12@infinispan-0:11222/rest/v2/caches/devices?action=search&query=from+io.enmasse.iot.registry.infinispan.data.DeviceInformation+d&max_results=1' 
{
  "total_results" : 38847,
  "hits" : [ {
    "hit" : {
      "_type" : "io.enmasse.iot.registry.infinispan.data.DeviceInformation",
      "tenantId" : "jbtest.iot/2019-11-29T08:52:39Z",
      "deviceId" : "http-inserter-wh5xn103",
      "version" : "992899e8-c557-4a2c-8bc0-db950a803898",
      "registrationInformation" : "{}",
      "credentials" : [ {
        "authId" : "device-103",
        "type" : "hashed-password",
        "secrets" : [ "{\"hash-function\":\"bcrypt\",\"pwd-hash\":\"$2y$12$JELemetlJuc.6ZgQkCn5X..7UEPQm5iQV23lgno7/2sEKY2i.mPmS\"}" ]
      } ]
    }
  } ]
}

➜  openshift oc -n enmasse-infra rsh infinispan-0 curl 'http://app:test12@infinispan-0:11222/rest/v2/caches/devices?action=search&query=select+d.deviceId+from+io.enmasse.iot.registry.infinispan.data.DeviceInformation+d&max_results=1'
{
  "total_results" : 1,
  "hits" : [ {
    "hit" : {
      "deviceId" : "http-inserter-wh5xn103"
    }
  } ]
}