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;

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';
```sql
3 To delete credentials for a deviceId so that we can set password again:

update eq_accesses set password=null, salt=null, security_question_answer=null, answer_salt=null where id=(select id from cases where survey_specific_id='myIphone6seM');

4 To check what credentials are set for a deviceId:
```sql
select sac.*, EQ_INITIAL_DATA from CASES c
join SAMPLE_UNITS su on c.SAMPLE_UNIT_ID = su.ID
join EQ_ACCESSES sac on c.ID = sac.CASE_ID
where c.SURVEY_SPECIFIC_ID='myIphone6seM';