โครงการ

ทั่วๆ ไป

Profile

Defect #616 » log table.txt

Anonymous, 21/09/2021 15:14

 
1
SELECT * FROM CBTRLOG010 WHERE createDte between '2021-09-17 15:00:00.000' and '2021-09-17 16:00:00.000' 
2
AND RequestBody LIKE '%540582%'
3
AND PathURL = '/api/Customer/SaveCustomer'
4
Order By createDte
5

    
6
25700569	1E1A629E-971C-4C9E-9CD5-45A5BA2381FD	Information	10.254.18.98	capapi.ibank.co.th:6988	10.254.18.98	MainThread	RequestLoggingMiddleware	https://capapp.ibank.co.th:8888	POST	/api/Customer/SaveCustomer	[CLIENT]	Request	{"applno":"AP10004-210914-00046","custCde":"CS00089-210916-00002","brnCde":"10022","movmntID":"e89d0ae0-ce4b-4713-b750-bb41fab869c8","custTypFlg":"0","cusRelat":null,"idTypCde":"01","idno":"1960800105958","titleCde":"001","fstNamTH":"ระฮ์มัต","surNamTH":"อูมา","fstNamEN":"RAHMAT","surNamEN":"U-MA","birthDte":"1996-08-08T00:00:00","expDte":"2027-08-07T00:00:00","gender":"M","nationCde":"TH","originCde":"TH","religionCde":"C","COUNTRY":"TH","issuBy":null,"educatCde":"07","maritalStsCde":"S","cusTyp":"01","consentDte":"2021-09-09","halah":null,"email":null,"evtCde":"","createBy":"540582","updateBy":"540582","activity":"","kycLevel":1,"isUpdate":true}	NULL	NULL	NULL	NULL	NULL	2021-09-17 15:15:54.120
7
25700571	1E1A629E-971C-4C9E-9CD5-45A5BA2381FD	Information	10.254.18.98	capapi.ibank.co.th:6988	10.254.18.98	MainThread	RequestLoggingMiddleware	https://capapp.ibank.co.th:8888	POST	/api/Customer/SaveCustomer	[CLIENT]	Request	{"applno":"AP10004-210914-00046","custCde":"CS00089-210916-00002","brnCde":"10022","movmntID":"e89d0ae0-ce4b-4713-b750-bb41fab869c8","custTypFlg":"0","cusRelat":null,"idTypCde":"01","idno":"1960800105958","titleCde":"001","fstNamTH":"ระฮ์มัต","surNamTH":"อูมา","fstNamEN":"RAHMAT","surNamEN":"U-MA","birthDte":"1996-08-08T00:00:00","expDte":"2027-08-07T00:00:00","gender":"M","nationCde":"TH","originCde":"TH","religionCde":"C","COUNTRY":"TH","issuBy":null,"educatCde":"07","maritalStsCde":"S","cusTyp":"01","consentDte":"2021-09-09","halah":null,"email":null,"evtCde":"","createBy":"540582","updateBy":"540582","activity":"","kycLevel":1,"isUpdate":true}	NULL	NULL	15:15:54	0.7717708	NULL	2021-09-17 15:15:54.840
8
25701917	7F0505DA-B7A2-44F6-A781-42354D35F2AD	Information	10.254.18.98	capapi.ibank.co.th:6988	10.254.18.98	MainThread	RequestLoggingMiddleware	https://capapp.ibank.co.th:8888	POST	/api/Customer/SaveCustomer	[CLIENT]	Request	{"applno":"AP10004-210914-00046","custCde":"CS00089-210916-00002","brnCde":"10022","movmntID":"e89d0ae0-ce4b-4713-b750-bb41fab869c8","custTypFlg":"0","cusRelat":null,"idTypCde":"01","idno":"1960800105958","titleCde":"001","fstNamTH":"ระฮ์มัต","surNamTH":"อูมา","fstNamEN":"RAHMAT","surNamEN":"U-MA","birthDte":"1996-08-08T00:00:00","expDte":"2027-08-07T00:00:00","gender":"M","nationCde":"TH","originCde":"TH","religionCde":"C","COUNTRY":"TH","issuBy":null,"educatCde":"07","maritalStsCde":"S","cusTyp":"01","consentDte":"2021-09-16","halah":null,"email":null,"evtCde":"","createBy":"540582","updateBy":"540582","activity":"","kycLevel":1,"isUpdate":true}	NULL	NULL	NULL	NULL	NULL	2021-09-17 15:16:26.133
9
25701919	7F0505DA-B7A2-44F6-A781-42354D35F2AD	Information	10.254.18.98	capapi.ibank.co.th:6988	10.254.18.98	MainThread	RequestLoggingMiddleware	https://capapp.ibank.co.th:8888	POST	/api/Customer/SaveCustomer	[CLIENT]	Request	{"applno":"AP10004-210914-00046","custCde":"CS00089-210916-00002","brnCde":"10022","movmntID":"e89d0ae0-ce4b-4713-b750-bb41fab869c8","custTypFlg":"0","cusRelat":null,"idTypCde":"01","idno":"1960800105958","titleCde":"001","fstNamTH":"ระฮ์มัต","surNamTH":"อูมา","fstNamEN":"RAHMAT","surNamEN":"U-MA","birthDte":"1996-08-08T00:00:00","expDte":"2027-08-07T00:00:00","gender":"M","nationCde":"TH","originCde":"TH","religionCde":"C","COUNTRY":"TH","issuBy":null,"educatCde":"07","maritalStsCde":"S","cusTyp":"01","consentDte":"2021-09-16","halah":null,"email":null,"evtCde":"","createBy":"540582","updateBy":"540582","activity":"","kycLevel":1,"isUpdate":true}	NULL	NULL	15:16:26	0.0479354	NULL	2021-09-17 15:16:26.170
(2-2/5)