Graphing site sign-ups

[ABC]

I would like to graph a cumulative line graph of how many users have signed up for my site (e.g. 0 on day 1, sum of 10 on day 2, sum of 30 on day 3, etc). Where can that kind of information be found in Open edX databases?

[Anh_Vu_Nguy_n (Vu Nguyen)]

Mysql openedx.auth_user

[ABC]

Thanks, that’s exactly what I was looking for.

Just to document the rest of the steps though for anyone else who wanders by, here’s how I got the data on a tutor system:

• docker exec -it tutor_local_mysql_1 mysql -u root --password=password
• mysql> use openedx;
• mysql> SHOW VARIABLES LIKE “secure_file_priv”;
  • It was set to /var/lib/mysql-files/
• mysql> SELECT id, date_joined FROM auth_user order BY date_joined FIELDS ENCLOSED BY ‘"’ TERMINATED BY ‘;’ ESCAPED BY ‘"’ INTO OUTFILE ‘/var/lib/mysql-files/reg_dates.csv’;
• mysql> exit
• docker container ls | grep mysql
  • Result was “3fea56790f15 mysql:latest …”
• docker cp 3fea56790f15:/var/lib/mysql-files/reg_dates.csv data/