Any valid, relevant SQL query can be used to examine Query Server information; provided are some sample queries as an example of the types of queries you may want to run.
| Query | Description |
|---|---|
| SELECT * FROM Imsi2Dn WHERE dn=18000000000 | Find the specified record in a given table |
| SELECT dn,service FROM exhr.Service JOIN exhr.Dn ON (exhr.Dn.serviceID=exhr.Service.id) WHERE dn=19194602167 | Find E.164 of HLR serving a given DN |
| SELECT imsi,service FROM exhr.Service JOIN exhr.Imsi ON (exhr.Imsi.serviceID=exhr.Service.id) WHERE imsi=18008888888 | Find E.164 of HLR serving a given IMSI |
| SELECT imsi FROM exhr.Dn2Imsi WHERE dn=19194602164 | Find IMSI associated with a DN |
| SELECT dn FROM exhr.Imsi2Dn WHERE imsi=18008888888 | Find DN associated with a IMSI |
| SELECT exhr.Dn.dn,imsi,service FROM exhr.Service JOIN exhr.Dn JOIN exhr.Dn2Imsi ON (exhr.Dn.serviceID=exhr.Service.id AND exhr.Dn.dn=exhr.Dn2Imsi.dn) WHERE exhr.Dn.dn=19194602164 | Find IMSI and HLR for given Dn |
| SELECT exhr.Imsi.imsi,dn,service FROM exhr.Service JOIN exhr.Imsi JOIN exhr.Imsi2Dn ON (exhr.Imsi.serviceID=exhr.Service.id AND exhr.Imsi.imsi=exhr.Imsi2Dn.imsi) WHERE exhr.Imsi.imsi=18008888888 | Find DNs and HLR for given IMSI |