[08/Nov/2020:02:00:02] (OfflineReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='offline' order by accountID [08/Nov/2020:02:00:02] (OfflineReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:02:00:02] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:02:00:02] (OfflineReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:02:00:02] (OfflineReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:02:00:02] (OfflineReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:02:00:02] (OfflineReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:00:02] (OfflineReportSentToMail) Return Group List [08/Nov/2020:02:00:02] (OfflineReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:00:02] (OfflineReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:02:00:08] (OfflineReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:02:00:08] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:02:00:08] (OfflineReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:02:00:08] (OfflineReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:02:00:08] (OfflineReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:02:00:08] (OfflineReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:00:08] (OfflineReportSentToMail) Return Group List [08/Nov/2020:02:00:08] (OfflineReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:00:08] (OfflineReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:02:00:14] (OfflineReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:02:00:14] (OfflineReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:02:00:14] (OfflineReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:02:00:14] (OfflineReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:02:00:14] (OfflineReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:02:00:14] (OfflineReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:00:14] (OfflineReportSentToMail) Return Group List [08/Nov/2020:02:00:14] (OfflineReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:00:15] (OfflineReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:02:30:03] (IgnitionOnOffReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='ignitiononoff' order by accountID [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='powercut' order by accountID [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='currentstatus' order by accountID [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) Return Group List [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:40:02] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:02:40:02] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) Return Group List [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:40:08] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) Return Group List [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:40:19] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) Return Group List [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:02:40:30] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) Get Groups For :tnemri administrator [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='administrator' [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) Get Account String For :tnemri [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) Return Group List [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:02:40:40] (CurrentStatusReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='administrator' and tripStatus='open' [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='powercut' order by accountID [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:02:55:03] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='overspeed' order by accountID [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) Get Groups For :tn1962 admin [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) Return Group List [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:03:00:01] (OverSpeedReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) Get Groups For :tn1962 admin [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) Return Group List [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:03:01:34] (OverSpeedReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) Get Groups For :tn1962 admin [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) Return Group List [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:03:01:40] (OverSpeedReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) Return Group List [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:03:01:43] (OverSpeedReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='powercut' order by accountID [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:10:05] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='powercut' order by accountID [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:25:08] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:27:47] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:27:49] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:03:30:04] (GeozoneReportSentToMail) SELECT accountID,emailaddress,groupID,reportSchedule,reporttype,userID FROM email where reportSchedule='daily' and description='geozone' order by accountID [08/Nov/2020:03:33:41] (PowerCutReportSentToMail) Get Groups For :tnemri admin [08/Nov/2020:03:33:42] (PowerCutReportSentToMail) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:03:33:42] (PowerCutReportSentToMail) Get Account Settings For :tnemri [08/Nov/2020:03:33:42] (PowerCutReportSentToMail) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:03:33:42] (PowerCutReportSentToMail) Get Account String For :tnemri [08/Nov/2020:03:33:42] (PowerCutReportSentToMail) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:33:42] (PowerCutReportSentToMail) Return Group List [08/Nov/2020:03:33:42] (PowerCutReportSentToMail) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:03:33:42] (PowerCutReportSentToMail) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/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 [08/Nov/2020:10:00:05] (DistanceReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:10:00:05] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:10:00:05] (DistanceReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:10:00:05] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:10:00:05] (DistanceReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:10:00:05] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:05] (DistanceReportSentToMail) Return Group List [08/Nov/2020:10:00:05] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:05] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:00:05] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:06] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:07] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:07] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:07] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:07] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:07] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:07] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:08] (DistanceReportSentToMail) Get Groups For :tn1962 admin [08/Nov/2020:10:00:08] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [08/Nov/2020:10:00:08] (DistanceReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:10:00:08] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:10:00:08] (DistanceReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:10:00:08] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:08] (DistanceReportSentToMail) Return Group List [08/Nov/2020:10:00:08] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:08] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [08/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 1604687400 AND 1604773799 [08/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='tn09g2885' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2874' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2868' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2882' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2831' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2892' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn21bc2263' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2880' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2883' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2858' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn58am1644' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2901' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn88b9628' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn58am1660' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn45bk2513' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2914' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn88b9644' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2869' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2842' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn49bh8591' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2891' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn21bc2274' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2840' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2912' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn45bk2516' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2824' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2839' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2902' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2900' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2894' and timestamp BETWEEN 1604687400 AND 1604773799 [08/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='tn09g2893' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (DistanceReportSentToMail) Get Groups For :tn1962 admin [08/Nov/2020:10:00:15] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [08/Nov/2020:10:00:15] (DistanceReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:10:00:15] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:10:00:15] (DistanceReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:10:00:15] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:15] (DistanceReportSentToMail) Return Group List [08/Nov/2020:10:00:15] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:15] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:15] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:16] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:26] (DistanceReportSentToMail) Get Groups For :tn1962 admin [08/Nov/2020:10:00:26] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [08/Nov/2020:10:00:26] (DistanceReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:10:00:26] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:10:00:26] (DistanceReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:10:00:26] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:26] (DistanceReportSentToMail) Return Group List [08/Nov/2020:10:00:26] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:26] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:28] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:34] (DistanceReportSentToMail) Get Groups For :tn1962 admin [08/Nov/2020:10:00:34] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [08/Nov/2020:10:00:34] (DistanceReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:10:00:34] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:10:00:34] (DistanceReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:10:00:34] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:34] (DistanceReportSentToMail) Return Group List [08/Nov/2020:10:00:34] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:34] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00: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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:35] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:51] (DistanceReportSentToMail) Get Groups For :tn1962 admin [08/Nov/2020:10:00:51] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='admin' [08/Nov/2020:10:00:51] (DistanceReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:10:00:51] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:10:00:51] (DistanceReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:10:00:51] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:51] (DistanceReportSentToMail) Return Group List [08/Nov/2020:10:00:51] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:00:51] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='admin' and tripStatus='open' [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:00:52] (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 1604687400 AND 1604773799 [08/Nov/2020:10:01:07] (DistanceReportSentToMail) Get Groups For :tn1962 administrator [08/Nov/2020:10:01:07] (DistanceReportSentToMail) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:10:01:07] (DistanceReportSentToMail) Get Account Settings For :tn1962 [08/Nov/2020:10:01:07] (DistanceReportSentToMail) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:10:01:07] (DistanceReportSentToMail) Get Account String For :tn1962 [08/Nov/2020:10:01:07] (DistanceReportSentToMail) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:01:07] (DistanceReportSentToMail) Return Group List [08/Nov/2020:10:01:07] (DistanceReportSentToMail) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:01:07] (DistanceReportSentToMail) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:01: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 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2885' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2874' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2868' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2882' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2831' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2892' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn21bc2263' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2880' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2883' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2858' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn58am1644' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2901' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn88b9628' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn58am1660' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn45bk2513' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2914' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn88b9644' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2869' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2842' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn49bh8591' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2891' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn21bc2274' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2840' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2912' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn45bk2516' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2824' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2839' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2902' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2900' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2894' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:01: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='tn09g2893' and timestamp BETWEEN 1604687400 AND 1604773799 [08/Nov/2020:10:52:19] (login) Get Groups For :tn1962 administrator [08/Nov/2020:10:52:19] (login) select * from AccountUserSettings where accountID='tn1962' and userID='administrator' [08/Nov/2020:10:52:19] (login) Get Account Settings For :tn1962 [08/Nov/2020:10:52:19] (login) select * from AccountSetup where accountID='tn1962' [08/Nov/2020:10:52:19] (login) Get Account String For :tn1962 [08/Nov/2020:10:52:19] (login) select * from AccountString where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:19] (login) Return Group List [08/Nov/2020:10:52:20] (index) SELECT * from Geozone where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:21] (index) select groupID,description from DeviceGroup where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:21] (index) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:21] (index) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:22] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:22] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:22] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tn1962','administrator','mapmyindia','map','1604812942','103.67.153.154') [08/Nov/2020:10:52:23] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:23] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:23] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:23] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:23] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:23] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:32] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:32] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:32] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:32] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:42] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:42] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:42] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:42] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:52] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:52] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:52:53] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:52:53] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:53:02] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:53:02] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:53:02] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:53:02] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:53:12] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:53:12] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:53:12] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:53:12] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:53:16] (index) select a.routeID,a.routeName from schoolrootmanagementtest.RouteInfo a,schoolrootmanagementtest.RouteSchedule b where a.accountID=b.accountID and a.routeID=b.routeID and a.accountID='tn1962' and b.vehicleID='tn09g2885' [08/Nov/2020:10:53:16] (index) select scheduleID,routePath from schoolrootmanagementtest.RouteSchedule where accountID='tn1962' and routeID='' order by routeID limit 1 [08/Nov/2020:10:53:16] (index) select groupID,description from DeviceGroup where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:53:17] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tn1962','administrator','mapmyindia','map','1604812997','103.67.153.154') [08/Nov/2020:10:55:36] (index) select a.routeID,a.routeName from schoolrootmanagementtest.RouteInfo a,schoolrootmanagementtest.RouteSchedule b where a.accountID=b.accountID and a.routeID=b.routeID and a.accountID='tn1962' and b.vehicleID='tn09g2885' [08/Nov/2020:10:55:36] (index) select scheduleID,routePath from schoolrootmanagementtest.RouteSchedule where accountID='tn1962' and vehicleID='tn09g2885' order by routeID limit 1 [08/Nov/2020:10:55:36] (index) select groupID,description from DeviceGroup where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:55:37] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tn1962','administrator','mapmyindia','map','1604813137','103.67.153.154') [08/Nov/2020:10:55:57] (index) select a.routeID,a.routeName from schoolrootmanagementtest.RouteInfo a,schoolrootmanagementtest.RouteSchedule b where a.accountID=b.accountID and a.routeID=b.routeID and a.accountID='tn1962' and b.vehicleID='tn09g2885' [08/Nov/2020:10:55:57] (index) select scheduleID,routePath from schoolrootmanagementtest.RouteSchedule where accountID='tn1962' and routeID='' order by routeID limit 1 [08/Nov/2020:10:55:57] (index) select groupID,description from DeviceGroup where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:55:58] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tn1962','administrator','mapmyindia','map','1604813158','103.67.153.154') [08/Nov/2020:10:55:58] (index) SELECT * from Geozone where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:55:58] (index) select groupID,description from DeviceGroup where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:55:58] (index) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:55:58] (index) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:55:58] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:55:58] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:55:58] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tn1962','administrator','mapmyindia','map','1604813158','103.67.153.154') [08/Nov/2020:10:56:00] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:00] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:00] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:00] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:00] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:00] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:08] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:08] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:09] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:09] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:19] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:20] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:20] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:20] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:28] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:28] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:29] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:29] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:39] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:39] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:39] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:39] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:48] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:48] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:48] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:48] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:58] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:58] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:56:58] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:56:58] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:00] (index) SELECT * from Geozone where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:00] (index) select groupID,description from DeviceGroup where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:00] (index) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:01] (index) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:01] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:01] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tn1962','administrator','mapmyindia','map','1604813221','103.67.153.154') [08/Nov/2020:10:57:02] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:02] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:02] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:03] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:03] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:03] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:03] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:11] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:11] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:11] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:11] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:21] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:21] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:22] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:22] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:31] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:31] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:31] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:31] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:41] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:41] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:41] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:41] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:51] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:51] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:57:52] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:57:52] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:01] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:01] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:02] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:02] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:11] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:21] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:21] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:22] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:22] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:29] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:29] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:31] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:31] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:31] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:31] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:41] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:41] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:41] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:41] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:50] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:50] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:51] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:51] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:58:52] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:58:52] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:01] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:01] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:01] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:01] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:11] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:11] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:12] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:12] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:21] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:21] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:21] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:21] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:23] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:23] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:31] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:31] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:10:59:31] (dashboardStats) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:10:59:31] (dashboardStats) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:11:00:05] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:11:00:05] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:11:00:13] (GetNotification) SELECT * from Driver where accountID='tn1962' and ln_id='en' [08/Nov/2020:11:00:13] (GetNotification) select * from tripschedule where accountID='tn1962' and userID='administrator' and tripStatus='open' [08/Nov/2020:23:23:31] (login) Get Groups For :tnemri admin [08/Nov/2020:23:23:31] (login) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:23:23:31] (login) Get Account Settings For :tnemri [08/Nov/2020:23:23:31] (login) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:23:23:31] (login) Get Account String For :tnemri [08/Nov/2020:23:23:31] (login) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:23:31] (login) Return Group List [08/Nov/2020:23:23:33] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:23:33] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:23:33] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:23:33] (index) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:24:10] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:24:11] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:24:11] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','admin','mapmyindia','map','1604858051','27.60.231.107') [08/Nov/2020:23:24:15] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:24:25] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:24:26] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:29] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:29] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:29] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:29] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:29] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:29] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:29] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:29] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:29] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:29] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:29] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:29] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:29] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:29] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:38] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:38] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:38] (index) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:33:51] (MapHitsTrack) insert into MapHitsTrack(accountID,userID,mapType,serviceType,hitTime,IP) values('tnemri','admin','mapmyindia','map','1604858631','27.60.231.107') [08/Nov/2020:23:33:51] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:33:51] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:34:08] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:08] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:08] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:34:20] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:20] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:21] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:34:25] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:25] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:34:35] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:35] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:35] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:34:39] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:39] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:34:50] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:34:52] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:07] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:07] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:08] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:23] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:23] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:23] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:24] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:24] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:33] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:33] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:33] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:41] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:41] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:44] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:44] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:51] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:51] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:55] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:55] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:35:57] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:57] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:35:57] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:08] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:08] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:16] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:16] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:16] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:28] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:28] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:28] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:28] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:39] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:39] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:39] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:47] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:47] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:47] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:47] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:51] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:51] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:57] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:57] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:59] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:36:59] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:59] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:36:59] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:10] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:10] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:21] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:21] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:21] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:21] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:21] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:30] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:30] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:31] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:32] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:36] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:36] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:36] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:41] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:41] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:41] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:51] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:37:59] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:59] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:37:59] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:08] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:08] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:13] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:13] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:17] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:17] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:17] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:22] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:25] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:25] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:32] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:32] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:33] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:41] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:42] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:45] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:45] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:46] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:38:55] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:38:55] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:05] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:05] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:14] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:14] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:14] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:15] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:15] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:22] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:22] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:22] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:22] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:24] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:24] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:31] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:31] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:31] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:39] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:39] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:46] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:46] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:46] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:51] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:51] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:39:55] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:39:55] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:02] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:02] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:02] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:14] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:14] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:21] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:21] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:21] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:21] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:21] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:29] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:30] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:37] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:37] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:37] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:44] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:44] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:50] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:50] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:50] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:53] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:53] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:40:58] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:40:58] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:05] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:05] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:05] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:15] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:15] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:22] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:24] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:24] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:24] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:32] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:32] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:41] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:41] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:41] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:51] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:53] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:53] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:41:58] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:58] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:41:58] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:42:12] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:12] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:42:13] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:13] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:42:14] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:14] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:42:20] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:20] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:20] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:42:21] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:21] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:21] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:42:21] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:21] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:21] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:42:44] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:44] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:42:49] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:49] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:42:49] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:43:32] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:32] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:43:45] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:45] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:43:46] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:46] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:43:47] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:47] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:43:54] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:54] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:54] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:43:55] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:56] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:56] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:43:56] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:43:56] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:01] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:01] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:01] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:20] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:20] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:30] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:30] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:35] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:35] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:35] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:35] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:35] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:35] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:37] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:37] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:37] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:40] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:40] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:40] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:42] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:42] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:42] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:44] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:44] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:51] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:51] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:53] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:53] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:57] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:57] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:57] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:44:59] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:59] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:44:59] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:04] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:04] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:04] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:04] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:09] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:09] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:11] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:11] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:11] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:16] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:16] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:16] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:22] (GetNotification) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:22] (GetNotification) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:25] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:25] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:34] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:34] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:34] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:44] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:47] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:47] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:45:52] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:54] (dashboardStats) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:54] (dashboardStats) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:45:54] (dashboardStats) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:46:47] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:46:47] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:46:47] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:46:47] (index) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:47:16] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:47:16] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:47:16] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:47:16] (index) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open' [08/Nov/2020:23:52:27] (login) Get Groups For :tnemri admin [08/Nov/2020:23:52:27] (login) select * from AccountUserSettings where accountID='tnemri' and userID='admin' [08/Nov/2020:23:52:27] (login) Get Account Settings For :tnemri [08/Nov/2020:23:52:27] (login) select * from AccountSetup where accountID='tnemri' [08/Nov/2020:23:52:27] (login) Get Account String For :tnemri [08/Nov/2020:23:52:27] (login) select * from AccountString where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:52:27] (login) Return Group List [08/Nov/2020:23:52:31] (index) SELECT * from Geozone where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:52:31] (index) select groupID,description from DeviceGroup where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:52:31] (index) SELECT * from Driver where accountID='tnemri' and ln_id='en' [08/Nov/2020:23:52:31] (index) select * from tripschedule where accountID='tnemri' and userID='admin' and tripStatus='open'