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 CASES c
join SAMPLE_UNITS su on c.SAMPLE_UNIT_ID = su.ID
where c.SURVEY_SPECIFIC_ID='myIphone6seM';