Queries to CMP

On the cloud machine itself, it is possible to query the CMP database by logging into the database console at http://localhost:8082/. There is no password.

1. To query the list of User-Agent collected so far:

select distinct(user_agent) from case_attempts order by db_created_date desc;

2 To query the graphdata corresponding to a particula deviceId

select (eq_initial_data) from