{"userId":"574","date":"2023-01-04 10:08:50","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.40', '2023-01-04 10:08:50')"}
{"userId":"574","date":"2023-01-04 10:13:05","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr Janki', 'Bartwal', 'jankibartwal@yahoo.in', '9760708040', '', '', '25d55ad283aa400af464c76d713c07ad', '4', '110.235.232.40', '574', '2023-01-04 10:13:05')"}
{"userId":"574","date":"2023-01-04 10:13:05","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('628', '101', '39', '601', '3', '5287', '110.235.232.40', '574', '2023-01-04 10:13:05')"}
{"userId":"574","date":"2023-01-04 10:43:09","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('Dr. Shailendra', 'Singh Chaudhary', 'drshailen321@yahoo.co.in', '9458429778', 'Professor, SPM', 'SN Medical College, UP', '25d55ad283aa400af464c76d713c07ad', '5', '110.235.232.40', '574', '2023-01-04 10:43:09')"}
{"userId":"574","date":"2023-01-04 10:43:09","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('629', '101', '38', '607', '3', '4536', '110.235.232.40', '574', '2023-01-04 10:43:09')"}
{"userId":"574","date":"2023-01-04 10:48:12","query":"INSERT INTO usermst (firstname, lastname, email, mobilenum, designation, organization, password, roleid, ipaddress, createdby, createddate) VALUES ('dr Sanjeev', 'Dave', 'sanjeevdavey333@gmail.com', '7817074399', 'Professor and HOD Community Medicine', 'Soban Singh Jeena Government Institute of Medical Science, Pandeykhola, Almora Uttarakhand ( India)', '25d55ad283aa400af464c76d713c07ad', '4', '110.235.232.40', '574', '2023-01-04 10:48:12')"}
{"userId":"574","date":"2023-01-04 10:48:12","query":"INSERT INTO userlocation (userid, countryid, stateid, districtid, riid, cityid, ipaddress, createdby, createddate) VALUES ('630', '101', '39', '594', '3', '5219', '110.235.232.40', '574', '2023-01-04 10:48:12')"}
{"userId":"511","date":"2023-01-04 11:03:25","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('511', '192.168.2.214', '2023-01-04 11:03:25')"}
{"userId":"511","date":"2023-01-04 11:06:14","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('183', '2023-01-04', '511', '192.168.2.214', '511', '2023-01-04 11:06:14')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO sitesupervision (siteid, plansiteid, userid, samplecollectionstartdate, isfunctional, ipaddress, createdby, createddate, startlatitude, startlongitude) VALUES ('183', '2846', '511', '2023-01-04', '1', '192.168.2.214', '511', '2023-01-04 11:06:31', '', '')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2431', '0', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2431', '1', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2431', '2', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2431', '3', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO supvissteps (ssid, stepnum, ipaddress, createdby, createddate) VALUES ('2431', '4', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2431', '', '', 'Array', '', 'Array', '', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2431', '', '', 'Array', '', 'Array', '', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2431', '', '', 'Array', '', 'Array', '', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO onsitestaffs (ssid, staffname, staffdesigid, isavailable, exphss, istrained, remarks, ipaddress, createdby, createddate) VALUES ('2431', '', '', 'Array', '', 'Array', '', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('1', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('10', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('12', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('13', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('14', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('15', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('16', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('17', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('18', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('19', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('20', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('21', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('22', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('23', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('24', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('25', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('26', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('27', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('28', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('29', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('30', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('31', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('32', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('33', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('34', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('35', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('36', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('37', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('38', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('39', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('40', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('41', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('42', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('43', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('44', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('45', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('46', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('47', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('48', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('49', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('50', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('51', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('52', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('53', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('54', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('55', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('56', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('57', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('58', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('59', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('60', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('61', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('62', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('63', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('64', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('65', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('66', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('67', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('68', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('69', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('70', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('71', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('72', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('73', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('74', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('75', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('76', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('77', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('78', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('79', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('278', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO quesanstransaction (quesid, ssid, ipaddress, createdby, createddate) VALUES ('279', '2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:06:31","query":"INSERT INTO visitfeedback (ssid, ipaddress, createdby, createddate) VALUES ('2431', '192.168.2.214', '511', '2023-01-04 11:06:31')"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE sitesupervision SET `siteid` = '183', `userid` = '511', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2431'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Kavita', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE onssid = '10052'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Shalini', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE onssid = '10053'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Vivek Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE onssid = '10054'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Artesh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE onssid = '10055'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225470 then '' when ansid=225471 then '' when ansid=225472 then '' when ansid=225473 then '' when ansid=225474 then ''  when ansid=225475 then ''   when ansid=225476 then ''  when ansid=225576 then '' when ansid=225577 then '' when ansid=225519 then '' when ansid=225521 then '' when ansid=225523 then '' when ansid=225525 then '' when ansid=225527 then '' when ansid=225529 then '' when ansid=225530 then '' when ansid=225531 then '' when ansid=225532 then ''  when ansid=225533 then ''   when ansid=225534 then ''  when ansid=225535 then ''  when ansid=225536 then ''   when ansid=225537 then ''   when ansid=225538 then ''   when ansid=225539 then ''  when ansid=225540 then '' when ansid=225541 then '' when ansid=225542 then ''  when ansid=225543 then ''   when ansid=225544 then ''   when ansid=225545 then ''   when ansid=225546 then ''  when ansid=225547 then ''  when ansid=225548 then ''   when ansid=225549 then ''  when ansid=225550 then '' when ansid=225551 then '' when ansid=225552 then '' when ansid=225553 then '' when ansid=225554 then '' when ansid=225555 then '' when ansid=225556 then '' when ansid=225557 then '' when ansid=225558 then ''  when ansid=225559 then ''   when ansid=225560 then ''   when ansid=225561 then ''   when ansid=225562 then ''  when ansid=225563 then '' when ansid=225564 then ''  when ansid=225565 then ''   when ansid=225566 then ''  when ansid=225567 then '' when ansid=225568 then '' when ansid=225569 then '' when ansid=225570 then '' when ansid=225571 then '' when ansid=225572 then '' when ansid=225573 then '' when ansid=225574 then '' when ansid=225575 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '192.168.2.214',\r\n\t\t\t\t\t\t\t\tmodifiedby =511,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-04 11:26:19'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225470','225471','225472','225473','225474','225475','225476','225576','225577','225519','225521','225523','225525','225527','225529','225530','225531','225532','225533','225534','225535','225536','225537','225538','225539','225540','225541','225542','225543','225544','225545','225546','225547','225548','225549','225550','225551','225552','225553','225554','225555','225556','225557','225558','225559','225560','225561','225562','225563','225564','225565','225566','225567','225568','225569','225570','225571','225572','225573','225574','225575')"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE supvisstepid = '12025'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE visitfeedbackid = '11931'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE visitfeedbackid = '11932'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE visitfeedbackid = '11933'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE visitfeedbackid = '11934'"}
{"userId":"511","date":"2023-01-04 11:26:19","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:26:19' WHERE visitfeedbackid = '11935'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE sitesupervision SET `siteid` = '183', `userid` = '511', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2431'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Kavita', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE onssid = '10052'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Shalini', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE onssid = '10053'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Vivek Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE onssid = '10054'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Artesh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE onssid = '10055'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225470 then '1' when ansid=225471 then '1' when ansid=225472 then '1' when ansid=225473 then '' when ansid=225474 then ''  when ansid=225475 then '739'   when ansid=225476 then '1'  when ansid=225576 then '1' when ansid=225577 then '1' when ansid=225519 then '' when ansid=225521 then '' when ansid=225523 then '' when ansid=225525 then '' when ansid=225527 then '' when ansid=225529 then '' when ansid=225530 then '' when ansid=225531 then '' when ansid=225532 then ''  when ansid=225533 then ''   when ansid=225534 then ''  when ansid=225535 then ''  when ansid=225536 then ''   when ansid=225537 then ''   when ansid=225538 then ''   when ansid=225539 then ''  when ansid=225540 then '' when ansid=225541 then '' when ansid=225542 then ''  when ansid=225543 then ''   when ansid=225544 then ''   when ansid=225545 then ''   when ansid=225546 then ''  when ansid=225547 then ''  when ansid=225548 then ''   when ansid=225549 then ''  when ansid=225550 then '' when ansid=225551 then '' when ansid=225552 then '' when ansid=225553 then '' when ansid=225554 then '' when ansid=225555 then '' when ansid=225556 then '' when ansid=225557 then '' when ansid=225558 then ''  when ansid=225559 then ''   when ansid=225560 then ''   when ansid=225561 then ''   when ansid=225562 then ''  when ansid=225563 then '' when ansid=225564 then ''  when ansid=225565 then ''   when ansid=225566 then ''  when ansid=225567 then '' when ansid=225568 then '' when ansid=225569 then '' when ansid=225570 then '' when ansid=225571 then '' when ansid=225572 then '' when ansid=225573 then '' when ansid=225574 then '' when ansid=225575 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '192.168.2.214',\r\n\t\t\t\t\t\t\t\tmodifiedby =511,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-04 11:27:08'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225470','225471','225472','225473','225474','225475','225476','225576','225577','225519','225521','225523','225525','225527','225529','225530','225531','225532','225533','225534','225535','225536','225537','225538','225539','225540','225541','225542','225543','225544','225545','225546','225547','225548','225549','225550','225551','225552','225553','225554','225555','225556','225557','225558','225559','225560','225561','225562','225563','225564','225565','225566','225567','225568','225569','225570','225571','225572','225573','225574','225575')"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE supvisstepid = '12026'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE visitfeedbackid = '11931'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE visitfeedbackid = '11932'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE visitfeedbackid = '11933'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE visitfeedbackid = '11934'"}
{"userId":"511","date":"2023-01-04 11:27:08","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:27:08' WHERE visitfeedbackid = '11935'"}
{"userId":"628","date":"2023-01-04 11:30:17","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('628', '223.227.88.89', '2023-01-04 11:30:17')"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE sitesupervision SET `siteid` = '183', `userid` = '511', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2431'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Kavita', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE onssid = '10052'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Shalini', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE onssid = '10053'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Vivek Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE onssid = '10054'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Artesh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE onssid = '10055'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225470 then '1' when ansid=225471 then '1' when ansid=225472 then '1' when ansid=225473 then '' when ansid=225474 then ''  when ansid=225475 then '739'   when ansid=225476 then '1'  when ansid=225576 then '1' when ansid=225577 then '1' when ansid=225519 then '1' when ansid=225521 then '1' when ansid=225523 then '1' when ansid=225525 then '100' when ansid=225527 then '0' when ansid=225529 then '' when ansid=225530 then '' when ansid=225531 then '' when ansid=225532 then ''  when ansid=225533 then ''   when ansid=225534 then ''  when ansid=225535 then ''  when ansid=225536 then ''   when ansid=225537 then ''   when ansid=225538 then ''   when ansid=225539 then ''  when ansid=225540 then '' when ansid=225541 then '' when ansid=225542 then ''  when ansid=225543 then ''   when ansid=225544 then ''   when ansid=225545 then ''   when ansid=225546 then ''  when ansid=225547 then ''  when ansid=225548 then ''   when ansid=225549 then ''  when ansid=225550 then '' when ansid=225551 then '' when ansid=225552 then '' when ansid=225553 then '' when ansid=225554 then '' when ansid=225555 then '' when ansid=225556 then '' when ansid=225557 then '' when ansid=225558 then ''  when ansid=225559 then ''   when ansid=225560 then ''   when ansid=225561 then ''   when ansid=225562 then ''  when ansid=225563 then '' when ansid=225564 then ''  when ansid=225565 then ''   when ansid=225566 then ''  when ansid=225567 then '' when ansid=225568 then '' when ansid=225569 then '' when ansid=225570 then '' when ansid=225571 then '' when ansid=225572 then '' when ansid=225573 then '' when ansid=225574 then '' when ansid=225575 then '' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '192.168.2.214',\r\n\t\t\t\t\t\t\t\tmodifiedby =511,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-04 11:31:05'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225470','225471','225472','225473','225474','225475','225476','225576','225577','225519','225521','225523','225525','225527','225529','225530','225531','225532','225533','225534','225535','225536','225537','225538','225539','225540','225541','225542','225543','225544','225545','225546','225547','225548','225549','225550','225551','225552','225553','225554','225555','225556','225557','225558','225559','225560','225561','225562','225563','225564','225565','225566','225567','225568','225569','225570','225571','225572','225573','225574','225575')"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE supvisstepid = '12027'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE visitfeedbackid = '11931'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE visitfeedbackid = '11932'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE visitfeedbackid = '11933'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE visitfeedbackid = '11934'"}
{"userId":"511","date":"2023-01-04 11:31:05","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:31:05' WHERE visitfeedbackid = '11935'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE sitesupervision SET `siteid` = '183', `userid` = '511', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '' WHERE ssid = '2431'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Kavita', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE onssid = '10052'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Shalini', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE onssid = '10053'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Vivek Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE onssid = '10054'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Artesh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE onssid = '10055'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225470 then '1' when ansid=225471 then '1' when ansid=225472 then '1' when ansid=225473 then '' when ansid=225474 then ''  when ansid=225475 then '739'   when ansid=225476 then '1'  when ansid=225576 then '1' when ansid=225577 then '1' when ansid=225519 then '1' when ansid=225521 then '1' when ansid=225523 then '1' when ansid=225525 then '100' when ansid=225527 then '0' when ansid=225529 then '2' when ansid=225530 then '2' when ansid=225531 then '250' when ansid=225532 then '250'  when ansid=225533 then ''   when ansid=225534 then '1'  when ansid=225535 then '1'  when ansid=225536 then ''   when ansid=225537 then '1'   when ansid=225538 then ''   when ansid=225539 then '1'  when ansid=225540 then '10' when ansid=225541 then '1' when ansid=225542 then '1'  when ansid=225543 then ''   when ansid=225544 then '1'   when ansid=225545 then ''   when ansid=225546 then '1'  when ansid=225547 then '1'  when ansid=225548 then ''   when ansid=225549 then '1'  when ansid=225550 then '4' when ansid=225551 then '1' when ansid=225552 then '1' when ansid=225553 then '1' when ansid=225554 then '2' when ansid=225555 then '3' when ansid=225556 then '1' when ansid=225557 then '1' when ansid=225558 then '1'  when ansid=225559 then ''   when ansid=225560 then '3'   when ansid=225561 then ''   when ansid=225562 then '1'  when ansid=225563 then '1' when ansid=225564 then '2'  when ansid=225565 then ''   when ansid=225566 then '1'  when ansid=225567 then '1' when ansid=225568 then '3' when ansid=225569 then '3' when ansid=225570 then '1' when ansid=225571 then '0' when ansid=225572 then '1. The size of the sample vials have changed for this round (as reported). The Lab Technician carried the samples each day to Microbiology department and the samples are stored there. As the size of the vials have changed they are non fitting in the transportation box. 2. The stickers with site information were not received by the site personnels.' when ansid=225573 then 'No' when ansid=225574 then 'the recruitment discussed with the site staffs on the day of visit was as per protocol' when ansid=225575 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '192.168.2.214',\r\n\t\t\t\t\t\t\t\tmodifiedby =511,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-04 11:43:30'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225470','225471','225472','225473','225474','225475','225476','225576','225577','225519','225521','225523','225525','225527','225529','225530','225531','225532','225533','225534','225535','225536','225537','225538','225539','225540','225541','225542','225543','225544','225545','225546','225547','225548','225549','225550','225551','225552','225553','225554','225555','225556','225557','225558','225559','225560','225561','225562','225563','225564','225565','225566','225567','225568','225569','225570','225571','225572','225573','225574','225575')"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE supvisstepid = '12028'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE visitfeedbackid = '11931'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE visitfeedbackid = '11932'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE visitfeedbackid = '11933'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE visitfeedbackid = '11934'"}
{"userId":"511","date":"2023-01-04 11:43:30","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:43:30' WHERE visitfeedbackid = '11935'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE sitesupervision SET `siteid` = '183', `userid` = '511', `ancservicedays` = '0', `samplecollectiondays` = '0', `samplecollectionstartdate` = '2023-01-02', `numofsamplecollected` = '30', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01', `locationtype` = '1', `establishmentyear` = '2023', `recruitmentdays` = '', `prisontype` = '', `prisontypetext` = '', `convictedprisoners` = '', `undertrialprisoners` = '', `iscompleted` = '1', `endlatitude` = '', `endlongitude` = '' WHERE ssid = '2431'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE onsitestaffs SET `staffname` = 'Dr Kavita', `staffdesigid` = '7', `isavailable` = '1', `exphss` = '1', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE onssid = '10052'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Shalini', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE onssid = '10053'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE onsitestaffs SET `staffname` = 'Mr Vivek Kumar', `staffdesigid` = '8', `isavailable` = '1', `exphss` = '3', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE onssid = '10054'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE onsitestaffs SET `staffname` = 'Ms Artesh Sharma', `staffdesigid` = '9', `isavailable` = '1', `exphss` = '6', `istrained` = '1', `remarks` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE onssid = '10055'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE quesanstransaction\r\n\t\t\t\t\t\t\tSET queansvalue = (case  when ansid=225470 then '1' when ansid=225471 then '1' when ansid=225472 then '1' when ansid=225473 then '' when ansid=225474 then ''  when ansid=225475 then '739'   when ansid=225476 then '1'  when ansid=225576 then '1' when ansid=225577 then '1' when ansid=225519 then '1' when ansid=225521 then '1' when ansid=225523 then '1' when ansid=225525 then '100' when ansid=225527 then '0' when ansid=225529 then '2' when ansid=225530 then '2' when ansid=225531 then '250' when ansid=225532 then '250'  when ansid=225533 then ''   when ansid=225534 then '1'  when ansid=225535 then '1'  when ansid=225536 then ''   when ansid=225537 then '1'   when ansid=225538 then ''   when ansid=225539 then '1'  when ansid=225540 then '10' when ansid=225541 then '1' when ansid=225542 then '1'  when ansid=225543 then ''   when ansid=225544 then '1'   when ansid=225545 then ''   when ansid=225546 then '1'  when ansid=225547 then '1'  when ansid=225548 then ''   when ansid=225549 then '1'  when ansid=225550 then '4' when ansid=225551 then '1' when ansid=225552 then '1' when ansid=225553 then '1' when ansid=225554 then '2' when ansid=225555 then '3' when ansid=225556 then '1' when ansid=225557 then '1' when ansid=225558 then '1'  when ansid=225559 then ''   when ansid=225560 then '3'   when ansid=225561 then ''   when ansid=225562 then '1'  when ansid=225563 then '1' when ansid=225564 then '2'  when ansid=225565 then ''   when ansid=225566 then '1'  when ansid=225567 then '1' when ansid=225568 then '3' when ansid=225569 then '3' when ansid=225570 then '1' when ansid=225571 then '0' when ansid=225572 then '1. The size of the sample vials have changed for this round (as reported). The Lab Technician carried the samples each day to Microbiology department and the samples are stored there. As the size of the vials have changed they are non fitting in the transportation box. 2. The stickers with site information were not received by the site personnels.' when ansid=225573 then 'No' when ansid=225574 then 'the recruitment discussed with the site staffs on the day of visit was as per protocol' when ansid=225575 then '2' end),\r\n\t\t\t\t\t\t\t\t ipaddress = '192.168.2.214',\r\n\t\t\t\t\t\t\t\tmodifiedby =511,\r\n\t\t\t\t\t\t\t\tmodifieddate = '2023-01-04 11:44:01'\r\n\t\t\t\t\t\t\tWHERE ansid in ('225470','225471','225472','225473','225474','225475','225476','225576','225577','225519','225521','225523','225525','225527','225529','225530','225531','225532','225533','225534','225535','225536','225537','225538','225539','225540','225541','225542','225543','225544','225545','225546','225547','225548','225549','225550','225551','225552','225553','225554','225555','225556','225557','225558','225559','225560','225561','225562','225563','225564','225565','225566','225567','225568','225569','225570','225571','225572','225573','225574','225575')"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE supvissteps SET `iscompleted` = '1', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE supvisstepid = '12029'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE visitfeedbackid = '11931'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE visitfeedbackid = '11932'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE visitfeedbackid = '11933'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE visitfeedbackid = '11934'"}
{"userId":"511","date":"2023-01-04 11:44:01","query":"UPDATE visitfeedback SET `feedback` = '', `recommendation` = '', `ipaddress` = '192.168.2.214', `modifiedby` = '511', `modifieddate` = '2023-01-04 11:44:01' WHERE visitfeedbackid = '11935'"}
{"userId":"628","date":"2023-01-04 11:53:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('628', '103.52.209.68', '2023-01-04 11:53:18')"}
{"userId":"574","date":"2023-01-04 11:59:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.40', '2023-01-04 11:59:12')"}
{"userId":"574","date":"2023-01-04 11:59:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.40', '2023-01-04 11:59:42')"}
{"userId":"574","date":"2023-01-04 12:01:24","query":"UPDATE sitemst SET `ipaddress` = '110.235.232.40', `modifiedby` = '574', `modifieddate` = '2023-01-04 12:01:24', `isdeleted` = '1' WHERE siteid = '324'"}
{"userId":"574","date":"2023-01-04 12:02:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.40', '2023-01-04 12:02:21')"}
{"userId":"574","date":"2023-01-04 12:03:54","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Sadar Hospital Bokaro (New 2023)', '1', '16', '3', '235', '20349012', '0', '400', '110.235.232.40', '574', '2023-01-04 12:03:54')"}
{"userId":"629","date":"2023-01-04 12:04:18","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('629', '49.42.32.210', '2023-01-04 12:04:18')"}
{"userId":"574","date":"2023-01-04 12:04:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.40', '2023-01-04 12:04:42')"}
{"userId":"574","date":"2023-01-04 12:07:43","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('District Hospital, Pauri', '1', '39', '3', '601', '05050012', '1', '200', '110.235.232.40', '574', '2023-01-04 12:07:43')"}
{"userId":"574","date":"2023-01-04 12:09:36","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('Base Hospital, Srinagar', '1', '39', '3', '601', '05050012', '2', '200', '110.235.232.40', '574', '2023-01-04 12:09:36')"}
{"userId":"574","date":"2023-01-04 12:10:48","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('CHC, Khatima', '1', '39', '3', '605', '05056012', '1', '200', '110.235.232.40', '574', '2023-01-04 12:10:48')"}
{"userId":"574","date":"2023-01-04 12:11:53","query":"INSERT INTO sitemst (sitename, sitetype, stateid, regionid, districtid, sitecode, subsitecode, samplesize, ipaddress, createdby, createddate) VALUES ('CHC, JASPUR', '1', '39', '3', '605', '05056012', '2', '200', '110.235.232.40', '574', '2023-01-04 12:11:53')"}
{"userId":"628","date":"2023-01-04 12:12:37","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1853', '2023-01-06', '628', '103.52.209.68', '628', '2023-01-04 12:12:37')"}
{"userId":"628","date":"2023-01-04 12:14:01","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1854', '2023-01-07', '628', '103.52.209.68', '628', '2023-01-04 12:14:01')"}
{"userId":"628","date":"2023-01-04 12:14:19","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('312', '2023-01-09', '628', '103.52.209.68', '628', '2023-01-04 12:14:19')"}
{"userId":"628","date":"2023-01-04 12:14:39","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('311', '2023-01-10', '628', '103.52.209.68', '628', '2023-01-04 12:14:39')"}
{"userId":"628","date":"2023-01-04 12:14:51","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('316', '2023-01-11', '628', '103.52.209.68', '628', '2023-01-04 12:14:51')"}
{"userId":"628","date":"2023-01-04 12:14:57","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('317', '2023-01-12', '628', '103.52.209.68', '628', '2023-01-04 12:14:57')"}
{"userId":"628","date":"2023-01-04 12:15:08","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('309', '2023-01-13', '628', '103.52.209.68', '628', '2023-01-04 12:15:08')"}
{"userId":"628","date":"2023-01-04 12:16:06","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('628', '103.52.209.68', '2023-01-04 12:16:06')"}
{"userId":"628","date":"2023-01-04 12:16:44","query":"UPDATE usermst SET `password` = 'a3daf2aa2ed2ddb8cdd29cec96b203ac', `modifiedby` = '628', `modifieddate` = '2023-01-04 12:16:44', `ipaddress` = '103.52.209.68' WHERE userid = '628'"}
{"userId":"380","date":"2023-01-04 12:53:45","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('380', '110.235.232.40', '2023-01-04 12:53:45')"}
{"userId":"254","date":"2023-01-04 14:56:47","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('254', '14.139.125.18', '2023-01-04 14:56:47')"}
{"userId":"252","date":"2023-01-04 14:57:12","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('252', '14.139.125.18', '2023-01-04 14:57:12')"}
{"userId":"255","date":"2023-01-04 14:57:27","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('255', '14.139.125.18', '2023-01-04 14:57:27')"}
{"userId":"256","date":"2023-01-04 14:57:42","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('256', '14.139.125.18', '2023-01-04 14:57:42')"}
{"userId":"258","date":"2023-01-04 14:57:57","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('258', '14.139.125.18', '2023-01-04 14:57:57')"}
{"userId":"236","date":"2023-01-04 15:16:48","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('236', '117.214.141.142', '2023-01-04 15:16:48')"}
{"userId":"236","date":"2023-01-04 15:24:22","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('1', '2023-01-05', '236', '117.214.141.142', '236', '2023-01-04 15:24:22')"}
{"userId":"236","date":"2023-01-04 15:28:07","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('236', '117.214.141.142', '2023-01-04 15:28:07')"}
{"userId":"236","date":"2023-01-04 15:31:08","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('36', '2023-01-05', '236', '117.214.141.142', '236', '2023-01-04 15:31:08')"}
{"userId":"236","date":"2023-01-04 15:31:21","query":"UPDATE plannedsites SET `isdeleted` = '1', `ipaddress` = '117.214.141.142', `modifiedby` = '236', `modifieddate` = '2023-01-04 15:31:21' WHERE plansiteid = '2855'"}
{"userId":"236","date":"2023-01-04 15:31:21","query":"UPDATE sitesupervision SET `isdeleted` = '1', `ipaddress` = '117.214.141.142', `modifiedby` = '236', `modifieddate` = '2023-01-04 15:31:21' WHERE ssid = ''"}
{"userId":"574","date":"2023-01-04 16:29:34","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('574', '110.235.232.40', '2023-01-04 16:29:34')"}
{"userId":"630","date":"2023-01-04 17:12:31","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('630', '157.38.74.121', '2023-01-04 17:12:31')"}
{"userId":"630","date":"2023-01-04 17:13:21","query":"INSERT INTO logmst (userId, IP, logIn) VALUES ('630', '157.38.74.121', '2023-01-04 17:13:21')"}
{"userId":"630","date":"2023-01-04 17:15:18","query":"INSERT INTO plannedsites (siteid, visitdate, userid, ipaddress, createdby, createddate) VALUES ('296', '2023-01-11', '630', '157.38.74.121', '630', '2023-01-04 17:15:18')"}
{"userId":null,"date":"2023-01-04 19:59:10","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('378', '491555', '0', '103.96.220.130', '', '2023-01-04 19:59:10')"}
{"userId":null,"date":"2023-01-04 20:00:18","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('378', '421142', '0', '103.96.220.130', '', '2023-01-04 20:00:18')"}
{"userId":null,"date":"2023-01-04 20:01:02","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('378', '257230', '0', '103.96.220.130', '', '2023-01-04 20:01:02')"}
{"userId":null,"date":"2023-01-04 20:04:47","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('378', '341930', '0', '103.96.220.130', '', '2023-01-04 20:04:47')"}
{"userId":null,"date":"2023-01-04 20:29:24","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('378', '653858', '0', '103.96.220.130', '', '2023-01-04 20:29:24')"}
{"userId":null,"date":"2023-01-04 20:44:26","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('378', '839578', '0', '103.96.220.130', '', '2023-01-04 20:44:26')"}
{"userId":null,"date":"2023-01-04 20:47:15","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('36', '800347', '0', '42.108.4.107', '', '2023-01-04 20:47:15')"}
{"userId":null,"date":"2023-01-04 20:47:18","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('378', '991937', '0', '103.96.220.130', '', '2023-01-04 20:47:18')"}
{"userId":null,"date":"2023-01-04 20:51:53","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('378', '677999', '0', '103.96.220.130', '', '2023-01-04 20:51:53')"}
{"userId":null,"date":"2023-01-04 21:21:38","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('20', '378374', '0', '122.163.154.248', '', '2023-01-04 21:21:38')"}
{"userId":null,"date":"2023-01-04 21:23:01","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('20', '433959', '0', '122.163.154.248', '', '2023-01-04 21:23:01')"}
{"userId":null,"date":"2023-01-04 21:23:15","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('20', '272584', '0', '122.163.154.248', '', '2023-01-04 21:23:15')"}
{"userId":null,"date":"2023-01-04 21:24:06","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('36', '747084', '0', '117.222.201.248', '', '2023-01-04 21:24:06')"}
{"userId":null,"date":"2023-01-04 21:24:29","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('36', '223798', '0', '117.222.201.248', '', '2023-01-04 21:24:29')"}
{"userId":null,"date":"2023-01-04 21:26:12","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('36', '425738', '0', '117.222.201.248', '', '2023-01-04 21:26:12')"}
{"userId":null,"date":"2023-01-04 21:28:27","query":"INSERT INTO otplog (userid, otp, isdeleted, ipaddress, createdby, createddate) VALUES ('36', '939891', '0', '117.222.201.248', '', '2023-01-04 21:28:27')"}