========================2018-07-17 09:47:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5UAJ13V parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389852A0CDAB017AA sCDKey = 646845474749 sName = DESKTOP-5UAJ13V ========================2018-07-17 09:47:45======================== 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 = '646845474749' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-17 09:47:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gosan3377' ========================2018-07-17 09:47:45======================== SELECT idx FROM macs WHERE mac_addr = '988389852A0CDAB017AA' AND app_code = '039' ========================2018-07-17 09:47:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254605' ========================2018-07-17 09:47:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254605' ========================2018-07-17 09:47:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254605', '988389852A0CDAB017AA', '039', 'DESKTOP-5UAJ13V', '110', '1920', '1080', 'gosan3377', '세원기계[신성민]', '646845474749' ) ========================2018-07-17 10:57:37======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-UU79AI9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C913F9AF61C0A78CED sCDKey = 682778728524 sName = DESKTOP-UU79AI9 ========================2018-07-17 10:57:37======================== 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 = '682778728524' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-17 10:57:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n1001x' ========================2018-07-17 10:57:37======================== SELECT idx FROM macs WHERE mac_addr = '14C913F9AF61C0A78CED' AND app_code = '046' ========================2018-07-17 10:57:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254460' ========================2018-07-17 10:57:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254460' ========================2018-07-17 10:57:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254460', '14C913F9AF61C0A78CED', '046', 'DESKTOP-UU79AI9', '110', '1920', '1080', 'n1001x', '중앙철물건재골재[이용식]', '682778728524' ) ========================2018-07-17 11:27:06======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 637698524487 sName = AHN-PC ========================2018-07-17 11:27: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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-17 11:27:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-07-17 11:27:06======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73F08A9CF6' AND app_code = '050' ========================2018-07-17 11:27:06======================== 값이 없을 경우 ========================2018-07-17 11:27:43======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 637698524487 sName = AHN-PC ========================2018-07-17 11:27:43======================== 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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-17 11:27:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-07-17 11:27:43======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73F08A9CF6' AND app_code = '050' ========================2018-07-17 11:27:43======================== 값이 없을 경우 ========================2018-07-17 11:28:35======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 637698524487 sName = AHN-PC ========================2018-07-17 11:28:35======================== 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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-17 11:28:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-07-17 11:28:35======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73F08A9CF6' AND app_code = '050' ========================2018-07-17 11:28:35======================== 값이 없을 경우 ========================2018-07-17 11:51:11======================== noteurl_start parm_app_code = 046 parm_pc_name = jh-201706121031 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = FCAA149B3A1245AA506 sCDKey = 400094721734 sName = 왼쪽포스 ========================2018-07-17 11:51:11======================== 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 = '400094721734' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-17 11:51:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gktehr' ========================2018-07-17 11:51:11======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA149B3A1245AA506' AND app_code = '046' ========================2018-07-17 11:51:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221192' ========================2018-07-17 11:51:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '221192' ========================2018-07-17 11:51:11======================== UPDATE mac_detail SET pc_name = '왼쪽포스', os_type = '90', user_id = 'gktehr', user_name = '울산핫도그[박수미]', screen_w = '1366', screen_h = '768', cdkey = '400094721734' WHERE mac_idx = '221192' ========================2018-07-17 11:53:27======================== noteurl_start parm_app_code = 046 parm_pc_name = SMJ-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = FCAA149BBB2374E91699 sCDKey = 400094721734 sName = 오른쪽포스 ========================2018-07-17 11:53: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 = '400094721734' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-17 11:53:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gktehr' ========================2018-07-17 11:53:27======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA149BBB2374E91699' AND app_code = '046' ========================2018-07-17 11:53:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '156230' ========================2018-07-17 11:53:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '156230' ========================2018-07-17 11:53:27======================== UPDATE mac_detail SET pc_name = '오른쪽포스', os_type = '90', user_id = 'gktehr', user_name = '울산핫도그[박수미]', screen_w = '1366', screen_h = '768', cdkey = '400094721734' WHERE mac_idx = '156230' ========================2018-07-17 13:11:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5QT6SNR parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74DFBFAE7AFACE39EC10 sCDKey = 448884805486 sName = DESKTOP-5QT6SNR ========================2018-07-17 13:11:14======================== 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 = '448884805486' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-17 13:11:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mak13581' ========================2018-07-17 13:11:14======================== SELECT idx FROM macs WHERE mac_addr = '74DFBFAE7AFACE39EC10' AND app_code = '039' ========================2018-07-17 13:11:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254836' ========================2018-07-17 13:11:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254836' ========================2018-07-17 13:11:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254836', '74DFBFAE7AFACE39EC10', '039', 'DESKTOP-5QT6SNR', '110', '1920', '1080', 'mak13581', '엠에이케이[엠에이케이]', '448884805486' )