[15/Nov/2020:02:00:05] (OfflineReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='offline' order by accountID 
[15/Nov/2020:02:00:05] (OfflineReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:02:00:05] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:02:00:05] (OfflineReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:02:00:06] (OfflineReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:02:00:06] (OfflineReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:02:00:07] (OfflineReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:00:07] (OfflineReportSentToMail) Return Group List 
[15/Nov/2020:02:00:07] (OfflineReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:00:07] (OfflineReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:02:00:27] (OfflineReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:02:00:28] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:02:00:28] (OfflineReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:02:00:28] (OfflineReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:02:00:28] (OfflineReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:02:00:28] (OfflineReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:00:28] (OfflineReportSentToMail) Return Group List 
[15/Nov/2020:02:00:28] (OfflineReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:00:28] (OfflineReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) Return Group List 
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:00:47] (OfflineReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:02:30:04] (IgnitionOnOffReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='ignitiononoff' order by accountID 
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='currentstatus' order by accountID 
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) Return Group List 
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='powercut' order by accountID 
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) Return Group List 
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:02:40:35] (CurrentStatusReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:02:40:35] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:02:40:35] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:02:40:35] (CurrentStatusReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:02:40:35] (CurrentStatusReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:02:40:36] (CurrentStatusReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:40:36] (CurrentStatusReportSentToMail) Return Group List 
[15/Nov/2020:02:40:36] (CurrentStatusReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:40:37] (CurrentStatusReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) Return Group List 
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:02:40:57] (CurrentStatusReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:02:41:14] (CurrentStatusReportSentToMail) Get Groups For :tnemri  administrator
[15/Nov/2020:02:41:14] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='administrator'
[15/Nov/2020:02:41:14] (CurrentStatusReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:02:41:14] (CurrentStatusReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:02:41:14] (CurrentStatusReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:02:41:14] (CurrentStatusReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:02:41:14] (CurrentStatusReportSentToMail) Return Group List 
[15/Nov/2020:02:41:14] (CurrentStatusReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:02:41:15] (CurrentStatusReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='administrator' and tripStatus='open'
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='powercut' order by accountID 
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:02:55:16] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='overspeed' order by accountID 
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) Get Groups For :tn1962  admin
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) Return Group List 
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:03:00:02] (OverSpeedReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) Get Groups For :tn1962  admin
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) Return Group List 
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:03:01:11] (OverSpeedReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) Get Groups For :tn1962  admin
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) Return Group List 
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:03:01:29] (OverSpeedReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) Return Group List 
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:03:01:50] (OverSpeedReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='powercut' order by accountID 
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:03:10:08] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:10:10] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='powercut' order by accountID 
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:25:14] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:30:04] (GeozoneReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email  where  reportSchedule='daily' and description='geozone' order by accountID 
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:03:38:55] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:38:56] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:38:57] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:03:43:48] (PowerCutReportSentToMail) Get Groups For :tnemri  admin
[15/Nov/2020:03:43:48] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin'
[15/Nov/2020:03:43:48] (PowerCutReportSentToMail) Get Account Settings For :tnemri
[15/Nov/2020:03:43:48] (PowerCutReportSentToMail) select * from  AccountSetup where accountID='tnemri'
[15/Nov/2020:03:43:48] (PowerCutReportSentToMail) Get Account String For :tnemri
[15/Nov/2020:03:43:48] (PowerCutReportSentToMail) select * from  AccountString where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:43:48] (PowerCutReportSentToMail) Return Group List 
[15/Nov/2020:03:43:48] (PowerCutReportSentToMail) SELECT *  from Driver where accountID='tnemri' and ln_id='en'
[15/Nov/2020:03:43:49] (PowerCutReportSentToMail) select * from tripschedule  where accountID='tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) SELECT a.accountID,a.emailaddress,a.groupID,a.reportSchedule,a.reporttype,a.userID FROM email a,AccountSetup b where a.accountID=b.accountID and b.distanceidlereportcron=1 and a.reportSchedule='daily' and a.description='distanceidlereport' order by a.accountID 
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) Return Group List 
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:00:05] (DistanceReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:10:00:08] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8596' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:09] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2885' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:09] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2874' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:09] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2868' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2882' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2831' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2892' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2263' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2880' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2883' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2858' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2901' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9628' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1660' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2513' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2914' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2869' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2842' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8591' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2891' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2274' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2840' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2912' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2516' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2824' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2839' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2902' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2900' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2894' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:10] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2893' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) Get Groups For :tn1962  admin
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) Return Group List 
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:00:28] (DistanceReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8596' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2885' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2874' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2868' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2882' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2831' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2892' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2263' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2880' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2883' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2858' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2901' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9628' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1660' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2513' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2914' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2869' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2842' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8591' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2891' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2274' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2840' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2912' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2516' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2824' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2839' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2902' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2900' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2894' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:29] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2893' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) Get Groups For :tn1962  admin
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) Return Group List 
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8596' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2885' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2874' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2868' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2882' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2831' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2892' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2263' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2880' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2883' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2858' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2901' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9628' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:44] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1660' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2513' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2914' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2869' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2842' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8591' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2891' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2274' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2840' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2912' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2516' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2824' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2839' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2902' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2900' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2894' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:00:46] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2893' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) Get Groups For :tn1962  admin
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) Return Group List 
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8596' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2885' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2874' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2868' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2882' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2831' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2892' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2263' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2880' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2883' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2858' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2901' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9628' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1660' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2513' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2914' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2869' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2842' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8591' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2891' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2274' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2840' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2912' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2516' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2824' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2839' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2902' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2900' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2894' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:02] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2893' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) Get Groups For :tn1962  admin
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) Return Group List 
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8596' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2885' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2874' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2868' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2882' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2831' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2892' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2263' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2880' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2883' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2858' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2901' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9628' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1660' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2513' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2914' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2869' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2842' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8591' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2891' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2274' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2840' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2912' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2516' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2824' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2839' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2902' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2900' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2894' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:18] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2893' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) Get Groups For :tn1962  admin
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin'
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) Return Group List 
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='admin' and tripStatus='open'
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8596' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2885' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2874' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2868' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2882' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2831' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2892' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2263' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2880' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2883' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2858' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2901' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9628' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1660' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2513' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2914' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2869' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2842' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8591' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2891' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2274' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2840' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2912' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2516' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2824' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2839' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2902' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2900' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2894' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:34] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2893' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) Get Groups For :tn1962  administrator
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator'
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) Get Account Settings For :tn1962
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select * from  AccountSetup where accountID='tn1962'
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) Get Account String For :tn1962
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select * from  AccountString where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) Return Group List 
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) SELECT *  from Driver where accountID='tn1962' and ln_id='en'
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select * from tripschedule  where accountID='tn1962' and userID='administrator' and tripStatus='open'
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8596' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2885' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2874' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2868' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2882' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2831' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2892' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2263' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2880' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2883' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2858' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2901' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9628' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn58am1660' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2513' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2914' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn88b9644' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2869' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2842' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn49bh8591' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2891' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn21bc2274' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2840' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2912' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn45bk2516' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2824' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2839' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2902' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2900' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2894' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:10:01:50] (DistanceReportSentToMail) select odoDistance,accountID, deviceID, groupID, baseLocation, crewNumber, idleLocations, idleTime, startTime, startLocation, travelledDistance, timeStamp, endTime, endLocation, route,District,uniqueID from distanceIdleReport where accountID='tn1962' and deviceID='tn09g2893' and timestamp BETWEEN 1605292200 AND 1605378599
[15/Nov/2020:20:46:49] (login) Get Groups For :Tnemri  admin
[15/Nov/2020:20:46:49] (login) select * from AccountUserSettings where accountID='Tnemri' and userID='admin'
[15/Nov/2020:20:46:49] (login) Get Account Settings For :Tnemri
[15/Nov/2020:20:46:49] (login) select * from  AccountSetup where accountID='Tnemri'
[15/Nov/2020:20:46:49] (login) Get Account String For :Tnemri
[15/Nov/2020:20:46:49] (login) select * from  AccountString where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:46:49] (login) Return Group List 
[15/Nov/2020:20:46:51] (index) SELECT * from Geozone where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:46:52] (index) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:46:52] (index) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:46:52] (index) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:47:57] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:47:58] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:47:59] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('Tnemri','admin','mapmyindia','map','1605453478','223.238.68.210')
[15/Nov/2020:20:48:15] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:48:15] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:48:18] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:48:18] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:48:29] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:48:29] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:48:31] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:48:31] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:48:40] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:48:40] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:48:44] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:48:44] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:48:58] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:48:58] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:49:03] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:49:04] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:49:20] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:49:20] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:49:32] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:49:33] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:49:54] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:49:54] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:51:31] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:51:31] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:51:31] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:51:31] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:51:47] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:51:47] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:51:47] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:51:47] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:52:42] (index) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:52:42] (index) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:52:43] (index) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:53:13] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:53:14] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:53:28] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:53:28] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:53:38] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('Tnemri','admin','mapmyindia','map','1605453818','223.238.68.210')
[15/Nov/2020:20:53:38] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:53:38] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:53:39] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:53:53] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:53:54] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:53:55] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:54:25] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:54:25] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:54:25] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:54:49] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:54:49] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:54:50] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:55:00] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:55:01] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:55:02] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:55:25] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:55:25] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:55:25] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:55:46] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:55:47] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:55:47] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:55:58] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:55:58] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:55:58] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:25] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:25] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:26] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:56:43] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:57:09] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:57:09] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:57:09] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:57:44] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:57:45] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:57:45] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:57:45] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:57:45] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:57:56] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:57:56] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:59:04] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:59:04] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:59:05] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:59:39] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:59:39] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:59:39] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:59:39] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:59:39] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:20:59:59] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:59:59] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:20:59:59] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:02:29] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:02:29] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:02:30] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:02:30] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:02:30] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:04:27] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:04:28] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:04:29] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:05:29] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:05:29] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:05:30] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:05:30] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:05:30] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:05:57] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:05:57] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:05:57] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:07:08] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:07:08] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:07:10] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:07:10] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:07:10] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:07:27] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:07:28] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:07:28] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:07:44] (dashboardStats) select groupID,description from DeviceGroup where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:07:44] (dashboardStats) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:07:46] (dashboardStats) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'
[15/Nov/2020:21:07:46] (GetNotification) SELECT *  from Driver where accountID='Tnemri' and ln_id='en'
[15/Nov/2020:21:07:46] (GetNotification) select * from tripschedule  where accountID='Tnemri' and userID='admin' and tripStatus='open'