[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='currentstatus' order by accountID 
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) Get Groups For :gvk-up-102  admin
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='gvk-up-102' and userID='admin'
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) Get Account Settings For :gvk-up-102
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) select * from  AccountSetup where accountID='gvk-up-102'
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) Get Account String For :gvk-up-102
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) select * from  AccountString where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) Return Group List 
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:02:00:02] (CurrentStatusReportSentToMail) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:12:45] (login) Get Groups For :gvk-up-102  admin
[21/Jul/2023:13:12:45] (login) select * from AccountUserSettings where accountID='gvk-up-102' and userID='admin'
[21/Jul/2023:13:12:45] (login) Get Account Settings For :gvk-up-102
[21/Jul/2023:13:12:45] (login) select * from  AccountSetup where accountID='gvk-up-102'
[21/Jul/2023:13:12:45] (login) Get Account String For :gvk-up-102
[21/Jul/2023:13:12:45] (login) select * from  AccountString where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:45] (login) Return Group List 
[21/Jul/2023:13:12:45] (index) SELECT * from Geozone where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:45] (index) select groupID,description from DeviceGroup where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:45] (index) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:46] (index) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:12:48] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:48] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:12:48] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('gvk-up-102','admin','mapmyindia','map','1689925368','183.82.110.22')
[21/Jul/2023:13:12:48] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:48] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:12:49] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:49] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:12:50] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:50] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:12:51] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:12:51] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:03] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:03] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:03] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:03] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:05] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:05] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:20] (index) SELECT * from Geozone where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:20] (index) select groupID,description from DeviceGroup where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:20] (index) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:20] (index) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:32] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:32] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:32] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('gvk-up-102','admin','mapmyindia','map','1689925472','183.82.110.22')
[21/Jul/2023:13:14:32] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:32] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:33] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:33] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:35] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:35] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:36] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:36] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:14:59] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:14:59] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:15:00] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:15:00] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:15:20] (index) select * from email where accountID='gvk-up-102'
[21/Jul/2023:13:15:20] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:15:20] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:15:20] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:15:20] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:15:21] (dashboardStats) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:15:21] (dashboardStats) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:15:21] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:15:21] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:15:49] (MailOparetions) select * from email where accountID='gvk-up-102' and groupID='selectall' and reportSchedule='daily' and emailaddress='pavan@glovision.co' and reporttype='summary' and description='currentstatus'
[21/Jul/2023:13:15:49] (MailOparetions) insert into email (accountID,emailaddress,groupID,time,reportSchedule,reporttype,description,userID) values('gvk-up-102','pavan@glovision.co','selectall','1689925549','daily','summary','currentstatus','admin')
[21/Jul/2023:13:15:49] (index) select * from email where accountID='gvk-up-102'
[21/Jul/2023:13:15:50] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:15:50] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:16:20] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:16:20] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:16:50] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:16:50] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:17:20] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:17:20] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:17:50] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:17:50] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:19:18] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:19:18] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:20:19] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:20:19] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:21:18] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:21:18] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:22:19] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:22:19] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:23:18] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:23:18] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:24:18] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:24:18] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:25:18] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:25:18] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:26:18] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:26:18] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:27:18] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:27:18] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'
[21/Jul/2023:13:28:09] (GetNotification) SELECT *  from Driver where accountID='gvk-up-102' and ln_id='en'
[21/Jul/2023:13:28:09] (GetNotification) select * from tripschedule  where accountID='gvk-up-102' and userID='admin' and tripStatus='open'