select SEC_TO_TIME(SUM(TIME_TO_SEC(k.duration))) as total_duration,g.total_book_count,count(k.series_mstr_token) as number_of_lesson,h.name as sub_subject_name,a.create_date as last_login_date,a.student_name, a.student_id,d.name as class_name,c.name as section_name,g.name as subject_name from student a,class b,section c,all_classes d,series e,subject f,all_subjects g,all_sub_subjects h,sub_subject i, lesson_series_master j,lesson_master k where a.school_token='hwOYOIt' and b.school_token=a.school_token and c.class_token=b.token and d.token=b.class_name and a.school_token=b.school_token and c.school_token=b.school_token and a.class_token=b.token and a.section_token=c.token and c.class_token=b.token and a.status='1' and b.status='1' and c.status='1' and a.firebase_token is not null and e.school_token=a.school_token and e.class_token=b.token and e.status='1' and e.token=f.series_token and a.school_token=f.school_token and a.class_token=f.class_token and f.name=g.token and g.sub_subject_status='Y' and f.token=i.subject_token and i.name=h.token and i.series_token=e.token and a.school_token=i.school_token and i.class_token=a.class_token and g.sub_subject_status='Y' and j.class_tkn_cmn=b.class_name and j.series_tkn_cmn=e.name and j.subject_tkn_cmn=f.name and j.sub_subject_tkn_cmn=i.name and k.series_mstr_token=j.token group by g.name,a.create_date,a.student_name,a.student_id,d.name,c.name,k.series_mstr_token,h.name,g.total_book_count union all select SEC_TO_TIME(SUM(TIME_TO_SEC(k.duration))) as total_duration,g.total_book_count,count(k.series_mstr_token) as number_of_lesson,'NA' as sub_subject_name,a.create_date as last_login_date,a.student_name,a.student_id,d.name as class_name, c.name as section_name,g.name as subject_name from student a,class b,section c,all_classes d,series e,subject f,all_subjects g,lesson_series_master j, lesson_master k where a.school_token='hwOYOIt' and b.school_token=a.school_token and c.class_token=b.token and d.token=b.class_name and a.school_token=b.school_token and c.school_token=b.school_token and a.class_token=b.token and a.section_token=c.token and c.class_token=b.token and a.status='1' and b.status='1' and c.status='1' and a.firebase_token is not null and e.school_token=a.school_token and e.class_token=b.token and e.status='1' and e.token=f.series_token and a.school_token=f.school_token and a.class_token=f.class_token and f.name=g.token and g.sub_subject_status='N' and j.class_tkn_cmn=b.class_name and j.series_tkn_cmn=e.name and j.subject_tkn_cmn=f.name and j.sub_subject_tkn_cmn='NULL' and k.series_mstr_token=j.token group by g.name,a.create_date,a.student_name,a.student_id,d.name,c.name,k.series_mstr_token,g.total_book_count order by subject_name
OLS/OTT APP Utilization Chart(Subject Wise)
| S.No | User Id | Name Of the User | Class & Sec/ Group | Last Login in Date and Time | Subject / Books Wise Details | Watched lesson | Remaining Lesson | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Subject | No. Of Books | No. Of lessons | Total Duration (Video Content) MM:SS | No. Of Lessons | Watched Duration | No. Of Lessons | Total Remaining Duration | Utilized % | |||||||
| Once | Total | Once | Total | ||||||||||||
| 1 | 452393 | Niyati Jain | KG 1/A | 2026-04-04 23:38:31 | English | Course Book | 20 | 158:25:00 | |||||||
| 2 | 101850 | Arjun Rawat | KG 2/A | 2026-03-30 13:56:52 | English | Course Book | 22 | 150:24:00 | |||||||
| 3 | 671808 | Khushi Kurmi | Nursery/A | 2026-03-31 13:45:58 | English | Rhyme Book | 30 | 29:28:00 | |||||||
| 4 | 663037 | shravik Shrivastava | KG 1/A | 2026-04-03 20:07:51 | English | Course Book | 20 | 158:25:00 | |||||||
| 5 | 452393 | Niyati Jain | KG 1/A | 2026-04-04 23:38:31 | English | Rhyme Book | 36 | 38:25:00 | |||||||
| 6 | 101850 | Arjun Rawat | KG 2/A | 2026-03-30 13:56:52 | English | Reader Book | 45 | 164:41:00 | |||||||
| 7 | 855504 | Harshit malaiya | KG 1/A | 2026-03-31 21:47:01 | English | Course Book | 20 | 158:25:00 | |||||||
| 8 | 663037 | shravik Shrivastava | KG 1/A | 2026-04-03 20:07:51 | English | Rhyme Book | 36 | 38:25:00 | |||||||
| 9 | 251414 | Prisha Khandelwal | Nursery/A | 2026-03-30 13:57:46 | English | Course Book | 13 | 74:35:00 | |||||||
| 10 | 855504 | Harshit malaiya | KG 1/A | 2026-03-31 21:47:01 | English | Rhyme Book | 36 | 38:25:00 | |||||||
| 11 | 819650 | Areeb Shekh | Nursery/A | 2026-04-04 12:44:07 | English | Course Book | 13 | 74:35:00 | |||||||
| 12 | 251414 | Prisha Khandelwal | Nursery/A | 2026-03-30 13:57:46 | English | Rhyme Book | 30 | 29:28:00 | |||||||
| 13 | 522992 | suniti vishwakarma | KG 1/A | 2026-04-01 17:34:37 | English | Course Book | 20 | 158:25:00 | |||||||
| 14 | 819650 | Areeb Shekh | Nursery/A | 2026-04-04 12:44:07 | English | Rhyme Book | 30 | 29:28:00 | |||||||
| 15 | 563811 | Dhruvi Pandey | Nursery/A | 2026-03-30 20:04:30 | English | Course Book | 13 | 74:35:00 | |||||||
| 16 | 522992 | suniti vishwakarma | KG 1/A | 2026-04-01 17:34:37 | English | Rhyme Book | 36 | 38:25:00 | |||||||
| 17 | 340284 | Sanidhya Namdeo | Nursery/A | 2026-04-04 14:49:55 | English | Course Book | 13 | 74:35:00 | |||||||
| 18 | 563811 | Dhruvi Pandey | Nursery/A | 2026-03-30 20:04:30 | English | Rhyme Book | 30 | 29:28:00 | |||||||
| 19 | 846966 | Dhanishtha Abidra | KG 1/A | 2026-04-02 10:31:43 | English | Course Book | 20 | 158:25:00 | |||||||
| 20 | 340284 | Sanidhya Namdeo | Nursery/A | 2026-04-04 14:49:55 | English | Rhyme Book | 30 | 29:28:00 | |||||||
| 21 | 648175 | Bhoomi Rajpoot | KG 2/A | 2026-03-31 09:45:39 | English | Course Book | 22 | 150:24:00 | |||||||
| 22 | 846966 | Dhanishtha Abidra | KG 1/A | 2026-04-02 10:31:43 | English | Rhyme Book | 36 | 38:25:00 | |||||||
| 23 | 417427 | Sonam JAIN | KG 1/A | 2026-04-04 17:02:08 | English | Course Book | 20 | 158:25:00 | |||||||
| 24 | 648175 | Bhoomi Rajpoot | KG 2/A | 2026-03-31 09:45:39 | English | Reader Book | 45 | 164:41:00 | |||||||
| 25 | 054745 | anokhi jain | Nursery/A | 2026-04-02 20:04:06 | English | Course Book | 13 | 74:35:00 | |||||||
| 26 | 417427 | Sonam JAIN | KG 1/A | 2026-04-04 17:02:08 | English | Rhyme Book | 36 | 38:25:00 | |||||||
| 27 | 414929 | devarsh soni | KG 1/A | 2026-03-31 12:13:32 | English | Course Book | 20 | 158:25:00 | |||||||
| 28 | 054745 | anokhi jain | Nursery/A | 2026-04-02 20:04:06 | English | Rhyme Book | 30 | 29:28:00 | |||||||
| 29 | 912767 | Pakhi jain | KG 2/A | 2026-04-04 21:46:20 | English | Course Book | 22 | 150:24:00 | |||||||
| 30 | 414929 | devarsh soni | KG 1/A | 2026-03-31 12:13:32 | English | Rhyme Book | 36 | 38:25:00 | |||||||
| 31 | 689739 | dhanvi jain | Nursery/A | 2026-04-03 17:06:28 | English | Course Book | 13 | 74:35:00 | |||||||
| 32 | 912767 | Pakhi jain | KG 2/A | 2026-04-04 21:46:20 | English | Reader Book | 45 | 164:41:00 | |||||||
| 33 | 671808 | Khushi Kurmi | Nursery/A | 2026-03-31 13:45:58 | English | Course Book | 13 | 74:35:00 | |||||||
| 34 | 689739 | dhanvi jain | Nursery/A | 2026-04-03 17:06:28 | English | Rhyme Book | 30 | 29:28:00 | |||||||
| 35 | 846966 | Dhanishtha Abidra | KG 1/A | 2026-04-02 10:31:43 | GK | NA | 16 | 70:12:00 | |||||||
| 36 | 054745 | anokhi jain | Nursery/A | 2026-04-02 20:04:06 | GK | NA | 18 | 82:40:00 | |||||||
| 37 | 689739 | dhanvi jain | Nursery/A | 2026-04-03 17:06:28 | GK | NA | 18 | 82:40:00 | |||||||
| 38 | 101850 | Arjun Rawat | KG 2/A | 2026-03-30 13:56:52 | GK | NA | 18 | 69:34:00 | |||||||
| 39 | 663037 | shravik Shrivastava | KG 1/A | 2026-04-03 20:07:51 | GK | NA | 16 | 70:12:00 | |||||||
| 40 | 251414 | Prisha Khandelwal | Nursery/A | 2026-03-30 13:57:46 | GK | NA | 18 | 82:40:00 | |||||||
| 41 | 819650 | Areeb Shekh | Nursery/A | 2026-04-04 12:44:07 | GK | NA | 18 | 82:40:00 | |||||||
| 42 | 563811 | Dhruvi Pandey | Nursery/A | 2026-03-30 20:04:30 | GK | NA | 18 | 82:40:00 | |||||||
| 43 | 340284 | Sanidhya Namdeo | Nursery/A | 2026-04-04 14:49:55 | GK | NA | 18 | 82:40:00 | |||||||
| 44 | 648175 | Bhoomi Rajpoot | KG 2/A | 2026-03-31 09:45:39 | GK | NA | 18 | 69:34:00 | |||||||
| 45 | 417427 | Sonam JAIN | KG 1/A | 2026-04-04 17:02:08 | GK | NA | 16 | 70:12:00 | |||||||
| 46 | 414929 | devarsh soni | KG 1/A | 2026-03-31 12:13:32 | GK | NA | 16 | 70:12:00 | |||||||
| 47 | 912767 | Pakhi jain | KG 2/A | 2026-04-04 21:46:20 | GK | NA | 18 | 69:34:00 | |||||||
| 48 | 671808 | Khushi Kurmi | Nursery/A | 2026-03-31 13:45:58 | GK | NA | 18 | 82:40:00 | |||||||
| 49 | 452393 | Niyati Jain | KG 1/A | 2026-04-04 23:38:31 | GK | NA | 16 | 70:12:00 | |||||||
| 50 | 855504 | Harshit malaiya | KG 1/A | 2026-03-31 21:47:01 | GK | NA | 16 | 70:12:00 | |||||||
| 51 | 522992 | suniti vishwakarma | KG 1/A | 2026-04-01 17:34:37 | GK | NA | 16 | 70:12:00 | |||||||
| 52 | 452393 | Niyati Jain | KG 1/A | 2026-04-04 23:38:31 | Hindi | Shishu Geet | 40 | 45:04:00 | |||||||
| 53 | 671808 | Khushi Kurmi | Nursery/A | 2026-03-31 13:45:58 | Hindi | Shishu Geet | 38 | 34:43:00 | |||||||
| 54 | 663037 | shravik Shrivastava | KG 1/A | 2026-04-03 20:07:51 | Hindi | Pathya Pustak | 15 | 201:46:00 | |||||||
| 55 | 855504 | Harshit malaiya | KG 1/A | 2026-03-31 21:47:01 | Hindi | Pathya Pustak | 15 | 201:46:00 | |||||||
| 56 | 663037 | shravik Shrivastava | KG 1/A | 2026-04-03 20:07:51 | Hindi | Shishu Geet | 40 | 45:04:00 | |||||||
| 57 | 101850 | Arjun Rawat | KG 2/A | 2026-03-30 13:56:52 | Hindi | Pathya Pustak | 21 | 158:54:00 | |||||||
| 58 | 855504 | Harshit malaiya | KG 1/A | 2026-03-31 21:47:01 | Hindi | Shishu Geet | 40 | 45:04:00 | |||||||
| 59 | 819650 | Areeb Shekh | Nursery/A | 2026-04-04 12:44:07 | Hindi | Pathya Pustak | 8 | 63:32:00 | |||||||
| 60 | 251414 | Prisha Khandelwal | Nursery/A | 2026-03-30 13:57:46 | Hindi | Pathya Pustak | 8 | 63:32:00 | |||||||
| 61 | 522992 | suniti vishwakarma | KG 1/A | 2026-04-01 17:34:37 | Hindi | Pathya Pustak | 15 | 201:46:00 | |||||||
| 62 | 819650 | Areeb Shekh | Nursery/A | 2026-04-04 12:44:07 | Hindi | Shishu Geet | 38 | 34:43:00 | |||||||
| 63 | 251414 | Prisha Khandelwal | Nursery/A | 2026-03-30 13:57:46 | Hindi | Shishu Geet | 38 | 34:43:00 | |||||||
| 64 | 522992 | suniti vishwakarma | KG 1/A | 2026-04-01 17:34:37 | Hindi | Shishu Geet | 40 | 45:04:00 | |||||||
| 65 | 340284 | Sanidhya Namdeo | Nursery/A | 2026-04-04 14:49:55 | Hindi | Pathya Pustak | 8 | 63:32:00 | |||||||
| 66 | 563811 | Dhruvi Pandey | Nursery/A | 2026-03-30 20:04:30 | Hindi | Pathya Pustak | 8 | 63:32:00 | |||||||
| 67 | 846966 | Dhanishtha Abidra | KG 1/A | 2026-04-02 10:31:43 | Hindi | Pathya Pustak | 15 | 201:46:00 | |||||||
| 68 | 340284 | Sanidhya Namdeo | Nursery/A | 2026-04-04 14:49:55 | Hindi | Shishu Geet | 38 | 34:43:00 | |||||||
| 69 | 563811 | Dhruvi Pandey | Nursery/A | 2026-03-30 20:04:30 | Hindi | Shishu Geet | 38 | 34:43:00 | |||||||
| 70 | 846966 | Dhanishtha Abidra | KG 1/A | 2026-04-02 10:31:43 | Hindi | Shishu Geet | 40 | 45:04:00 | |||||||
| 71 | 417427 | Sonam JAIN | KG 1/A | 2026-04-04 17:02:08 | Hindi | Pathya Pustak | 15 | 201:46:00 | |||||||
| 72 | 648175 | Bhoomi Rajpoot | KG 2/A | 2026-03-31 09:45:39 | Hindi | Pathya Pustak | 21 | 158:54:00 | |||||||
| 73 | 054745 | anokhi jain | Nursery/A | 2026-04-02 20:04:06 | Hindi | Pathya Pustak | 8 | 63:32:00 | |||||||
| 74 | 417427 | Sonam JAIN | KG 1/A | 2026-04-04 17:02:08 | Hindi | Shishu Geet | 40 | 45:04:00 | |||||||
| 75 | 414929 | devarsh soni | KG 1/A | 2026-03-31 12:13:32 | Hindi | Pathya Pustak | 15 | 201:46:00 | |||||||
| 76 | 054745 | anokhi jain | Nursery/A | 2026-04-02 20:04:06 | Hindi | Shishu Geet | 38 | 34:43:00 | |||||||
| 77 | 912767 | Pakhi jain | KG 2/A | 2026-04-04 21:46:20 | Hindi | Pathya Pustak | 21 | 158:54:00 | |||||||
| 78 | 414929 | devarsh soni | KG 1/A | 2026-03-31 12:13:32 | Hindi | Shishu Geet | 40 | 45:04:00 | |||||||
| 79 | 689739 | dhanvi jain | Nursery/A | 2026-04-03 17:06:28 | Hindi | Pathya Pustak | 8 | 63:32:00 | |||||||
| 80 | 452393 | Niyati Jain | KG 1/A | 2026-04-04 23:38:31 | Hindi | Pathya Pustak | 15 | 201:46:00 | |||||||
| 81 | 671808 | Khushi Kurmi | Nursery/A | 2026-03-31 13:45:58 | Hindi | Pathya Pustak | 8 | 63:32:00 | |||||||
| 82 | 689739 | dhanvi jain | Nursery/A | 2026-04-03 17:06:28 | Hindi | Shishu Geet | 38 | 34:43:00 | |||||||
| 83 | 563811 | Dhruvi Pandey | Nursery/A | 2026-03-30 20:04:30 | Mathematics | NA | 11 | 96:26:00 | |||||||
| 84 | 417427 | Sonam JAIN | KG 1/A | 2026-04-04 17:02:08 | Mathematics | NA | 16 | 149:10:00 | |||||||
| 85 | 414929 | devarsh soni | KG 1/A | 2026-03-31 12:13:32 | Mathematics | NA | 16 | 149:10:00 | |||||||
| 86 | 452393 | Niyati Jain | KG 1/A | 2026-04-04 23:38:31 | Mathematics | NA | 16 | 149:10:00 | |||||||
| 87 | 671808 | Khushi Kurmi | Nursery/A | 2026-03-31 13:45:58 | Mathematics | NA | 11 | 96:26:00 | |||||||
| 88 | 855504 | Harshit malaiya | KG 1/A | 2026-03-31 21:47:01 | Mathematics | NA | 16 | 149:10:00 | |||||||
| 89 | 522992 | suniti vishwakarma | KG 1/A | 2026-04-01 17:34:37 | Mathematics | NA | 16 | 149:10:00 | |||||||
| 90 | 846966 | Dhanishtha Abidra | KG 1/A | 2026-04-02 10:31:43 | Mathematics | NA | 16 | 149:10:00 | |||||||
| 91 | 054745 | anokhi jain | Nursery/A | 2026-04-02 20:04:06 | Mathematics | NA | 11 | 96:26:00 | |||||||
| 92 | 689739 | dhanvi jain | Nursery/A | 2026-04-03 17:06:28 | Mathematics | NA | 11 | 96:26:00 | |||||||
| 93 | 663037 | shravik Shrivastava | KG 1/A | 2026-04-03 20:07:51 | Mathematics | NA | 16 | 149:10:00 | |||||||
| 94 | 819650 | Areeb Shekh | Nursery/A | 2026-04-04 12:44:07 | Mathematics | NA | 11 | 96:26:00 | |||||||
| 95 | 251414 | Prisha Khandelwal | Nursery/A | 2026-03-30 13:57:46 | Mathematics | NA | 11 | 96:26:00 | |||||||
| 96 | 340284 | Sanidhya Namdeo | Nursery/A | 2026-04-04 14:49:55 | Mathematics | NA | 11 | 96:26:00 | |||||||
| 97 | 663037 | shravik Shrivastava | KG 1/A | 2026-04-03 20:07:51 | Toddler Training | Fun Book | 30 | 66:29:00 | |||||||
| 98 | 101850 | Arjun Rawat | KG 2/A | 2026-03-30 13:56:52 | Toddler Training | Fun Book | 24 | 62:57:00 | |||||||
| 99 | 663037 | shravik Shrivastava | KG 1/A | 2026-04-03 20:07:51 | Toddler Training | Fun Book | 28 | 61:48:00 | |||||||
| 100 | 648175 | Bhoomi Rajpoot | KG 2/A | 2026-03-31 09:45:39 | Toddler Training | Fun Book | 24 | 62:57:00 | |||||||
| 101 | 417427 | Sonam JAIN | KG 1/A | 2026-04-04 17:02:08 | Toddler Training | Fun Book | 30 | 66:29:00 | |||||||
| 102 | 414929 | devarsh soni | KG 1/A | 2026-03-31 12:13:32 | Toddler Training | Fun Book | 30 | 66:29:00 | |||||||
| 103 | 417427 | Sonam JAIN | KG 1/A | 2026-04-04 17:02:08 | Toddler Training | Fun Book | 28 | 61:48:00 | |||||||
| 104 | 414929 | devarsh soni | KG 1/A | 2026-03-31 12:13:32 | Toddler Training | Fun Book | 28 | 61:48:00 | |||||||
| 105 | 912767 | Pakhi jain | KG 2/A | 2026-04-04 21:46:20 | Toddler Training | Fun Book | 24 | 62:57:00 | |||||||
| 106 | 855504 | Harshit malaiya | KG 1/A | 2026-03-31 21:47:01 | Toddler Training | Fun Book | 30 | 66:29:00 | |||||||
| 107 | 452393 | Niyati Jain | KG 1/A | 2026-04-04 23:38:31 | Toddler Training | Fun Book | 30 | 66:29:00 | |||||||
| 108 | 855504 | Harshit malaiya | KG 1/A | 2026-03-31 21:47:01 | Toddler Training | Fun Book | 28 | 61:48:00 | |||||||
| 109 | 452393 | Niyati Jain | KG 1/A | 2026-04-04 23:38:31 | Toddler Training | Fun Book | 28 | 61:48:00 | |||||||
| 110 | 522992 | suniti vishwakarma | KG 1/A | 2026-04-01 17:34:37 | Toddler Training | Fun Book | 30 | 66:29:00 | |||||||
| 111 | 522992 | suniti vishwakarma | KG 1/A | 2026-04-01 17:34:37 | Toddler Training | Fun Book | 28 | 61:48:00 | |||||||
| 112 | 846966 | Dhanishtha Abidra | KG 1/A | 2026-04-02 10:31:43 | Toddler Training | Fun Book | 30 | 66:29:00 | |||||||
| 113 | 846966 | Dhanishtha Abidra | KG 1/A | 2026-04-02 10:31:43 | Toddler Training | Fun Book | 28 | 61:48:00 | |||||||
| User Total | |||||||||||||||
| Class & Sec Total | |||||||||||||||
| Grand Total | |||||||||||||||