========================2018-10-19 10:14:05======================== noteurl_start parm_app_code = 046 parm_pc_name = LSH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245433345AC80F3AF1 sCDKey = 402985231609 sName = LSH-PC ========================2018-10-19 10:14:05======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '402985231609' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 10:14:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoonmin1121' ========================2018-10-19 10:14:05======================== SELECT idx FROM macs WHERE mac_addr = '00245433345AC80F3AF1' AND app_code = '046' ========================2018-10-19 10:14:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260309' ========================2018-10-19 10:14:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260309' ========================2018-10-19 10:14:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260309', '00245433345AC80F3AF1', '046', 'LSH-PC', '110', '1920', '1080', 'yoonmin1121', '[이수현]', '402985231609' ) ========================2018-10-19 15:13:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-NFJVLKO parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02F675B61F6419ED6 sCDKey = 916970945314 sName = DESKTOP-NFJVLKO ========================2018-10-19 15:13:36======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 15:13:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2018-10-19 15:13:36======================== SELECT idx FROM macs WHERE mac_addr = '40F02F675B61F6419ED6' AND app_code = '046' ========================2018-10-19 15:13:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '264107' ========================2018-10-19 15:13:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '264107' ========================2018-10-19 15:13:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '264107', '40F02F675B61F6419ED6', '046', 'DESKTOP-NFJVLKO', '110', '1366', '768', 'danjinail', '단지네네일가게[임재완]', '916970945314' ) ========================2018-10-19 15:14:27======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-NFJVLKO parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02F675B61F6419ED6 sCDKey = 916970945314 sName = danjinetbook ========================2018-10-19 15:14:27======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 15:15:00======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-NFJVLKO parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02F675B61F6419ED6 sCDKey = 916970945314 sName = danjinetbook ========================2018-10-19 15:15:00======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 15:15:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2018-10-19 15:15:00======================== SELECT idx FROM macs WHERE mac_addr = '40F02F675B61F6419ED6' AND app_code = '046' ========================2018-10-19 15:15:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '264107' ========================2018-10-19 15:15:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '264107' ========================2018-10-19 15:15:00======================== UPDATE mac_detail SET pc_name = 'danjinetbook', os_type = '110', user_id = 'danjinail', user_name = '단지네네일가게[임재완]', screen_w = '1366', screen_h = '768', cdkey = '916970945314' WHERE mac_idx = '264107' ========================2018-10-19 15:30:24======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-47776JR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838986C652D87CAEF4 sCDKey = 574885599852 sName = DESKTOP-47776JR ========================2018-10-19 15:30:24======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '574885599852' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-19 15:30:52======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-47776JR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838986C652D87CAEF4 sCDKey = 287165871405 sName = DESKTOP-47776JR ========================2018-10-19 15:30:52======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '287165871405' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-19 15:31:23======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-47776JR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838986C652D87CAEF4 sCDKey = 408941491113 sName = DESKTOP-47776JR ========================2018-10-19 15:31:23======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '408941491113' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-19 15:31:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wonjingonggu' ========================2018-10-19 15:31:23======================== SELECT idx FROM macs WHERE mac_addr = '98838986C652D87CAEF4' AND app_code = '047' ========================2018-10-19 15:31:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '264119' ========================2018-10-19 15:31:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '264119' ========================2018-10-19 15:31:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '264119', '98838986C652D87CAEF4', '047', 'DESKTOP-47776JR', '�쐢�룄�슦 10', '0', '0', 'wonjingonggu', '원진공구[김영란]', '408941491113' ) ========================2018-10-19 16:36:32======================== noteurl_start parm_app_code = 046 parm_pc_name = LSH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245433345AC80F3AF1 sCDKey = 054551955434 sName = LSH-PC ========================2018-10-19 16:36:32======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '054551955434' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 16:36:44======================== noteurl_start parm_app_code = 046 parm_pc_name = jh-201810191533 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = D050999ADE7CACEBF2A8 sCDKey = 262318519570 sName = jh-201810191533 ========================2018-10-19 16:36:44======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '262318519570' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 16:36:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssjj0099' ========================2018-10-19 16:36:44======================== SELECT idx FROM macs WHERE mac_addr = 'D050999ADE7CACEBF2A8' AND app_code = '046' ========================2018-10-19 16:36:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '264144' ========================2018-10-19 16:36:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '264144' ========================2018-10-19 16:36:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '264144', 'D050999ADE7CACEBF2A8', '046', 'jh-201810191533', '90', '1366', '768', 'ssjj0099', '승진펫유통[이승진]', '262318519570' ) ========================2018-10-19 16:36:47======================== noteurl_start parm_app_code = 046 parm_pc_name = LSH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245433345AC80F3AF1 sCDKey = 054551955434 sName = LSH-PC ========================2018-10-19 16:36:47======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '054551955434' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 16:37:06======================== noteurl_start parm_app_code = 046 parm_pc_name = jh-201810191533 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = D050999ADE7CACEBF2A8 sCDKey = 262318519570 sName = jh-201810191533 ========================2018-10-19 16:37:06======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '262318519570' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 16:37:41======================== noteurl_start parm_app_code = 046 parm_pc_name = LSH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245433345AC80F3AF1 sCDKey = 054551955434 sName = LSH-PC ========================2018-10-19 16:37:41======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '054551955434' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 16:38:58======================== noteurl_start parm_app_code = 046 parm_pc_name = LSH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245433345AC80F3AF1 sCDKey = 493708911115 sName = LSH-PC ========================2018-10-19 16:38:58======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '493708911115' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-19 16:38:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoonmin1121' ========================2018-10-19 16:38:58======================== SELECT idx FROM macs WHERE mac_addr = '00245433345AC80F3AF1' AND app_code = '046' ========================2018-10-19 16:38:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260309' ========================2018-10-19 16:38:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260309' ========================2018-10-19 16:38:58======================== UPDATE mac_detail SET pc_name = 'LSH-PC', os_type = '110', user_id = 'yoonmin1121', user_name = '[이수현]', screen_w = '1920', screen_h = '1080', cdkey = '493708911115' WHERE mac_idx = '260309'