========================2018-09-19 09:14:09======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 2048 parm_screen_h = 1152 parm_user_mac = 6C626DC04D0E180CE261 sCDKey = 262624543364 sName = 건아2 ========================2018-09-19 09:14:09======================== 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 = '262624543364' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-19 09:14:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lsj4223' ========================2018-09-19 09:14:09======================== SELECT idx FROM macs WHERE mac_addr = '6C626DC04D0E180CE261' AND app_code = '039' ========================2018-09-19 09:14:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '178011' ========================2018-09-19 09:14:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '178011' ========================2018-09-19 09:14:09======================== UPDATE mac_detail SET pc_name = '건아2', os_type = '90', user_id = 'lsj4223', user_name = '건아[이석재]', screen_w = '2048', screen_h = '1152', cdkey = '262624543364' WHERE mac_idx = '178011' ========================2018-09-19 09:50:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-F5JR3GN parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 1062E5112FD6BE2D1CDA sCDKey = 615248701701 sName = DESKTOP-F5JR3GN ========================2018-09-19 09:50:42======================== 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 = '615248701701' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-19 09:50:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhs1859' ========================2018-09-19 09:50:42======================== SELECT idx FROM macs WHERE mac_addr = '1062E5112FD6BE2D1CDA' AND app_code = '039' ========================2018-09-19 09:50:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260406' ========================2018-09-19 09:50:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260406' ========================2018-09-19 09:50:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260406', '1062E5112FD6BE2D1CDA', '039', 'DESKTOP-F5JR3GN', '110', '1600', '900', 'jhs1859', '보임텍[심재혁]', '615248701701' ) ========================2018-09-19 10:24:30======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-K24RS2V parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23D4D6E8CA34E6F sCDKey = 116617546847 sName = DESKTOP-K24RS2V ========================2018-09-19 10:24:30======================== 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 = '116617546847' AND r.app_code = '046' AND r.app_block = 0 ========================2018-09-19 10:24:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wooritools' ========================2018-09-19 10:24:30======================== SELECT idx FROM macs WHERE mac_addr = '309C23D4D6E8CA34E6F' AND app_code = '046' ========================2018-09-19 10:24:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260404' ========================2018-09-19 10:24:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260404' ========================2018-09-19 10:24:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260404', '309C23D4D6E8CA34E6F', '046', 'DESKTOP-K24RS2V', '110', '1920', '1080', 'wooritools', '우리종합공구[김민재]', '116617546847' ) ========================2018-09-19 13:18:49======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245491FA7E880831F2 sCDKey = 232910431890 sName = MSDN-SPECIAL ========================2018-09-19 13:18:49======================== 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 = '232910431890' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-19 13:18:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ykc1072' ========================2018-09-19 13:18:49======================== SELECT idx FROM macs WHERE mac_addr = '00245491FA7E880831F2' AND app_code = '039' ========================2018-09-19 13:18:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260430' ========================2018-09-19 13:18:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260430' ========================2018-09-19 13:18:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260430', '00245491FA7E880831F2', '039', 'MSDN-SPECIAL', '90', '1920', '1080', 'ykc1072', '백제의료기기[양경철]', '232910431890' ) ========================2018-09-19 14:01:38======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A497E5919CB sCDKey = 851095746023 sName = SEOWL17H15185 ========================2018-09-19 14:01:38======================== 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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2018-09-19 14:50:32======================== noteurl_start parm_app_code = 046 parm_pc_name = 5775-경태 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 74C63BA2AADDF8EB58DC sCDKey = 343408108095 sName = 5775-경태 ========================2018-09-19 14:50: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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2018-09-19 14:51:48======================== noteurl_start parm_app_code = 046 parm_pc_name = 5775-경태 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 74C63BA2AADDF8EB58DC sCDKey = 343408108095 sName = 5775-경태 ========================2018-09-19 14:51:48======================== 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 = '343408108095' AND r.app_code = '046' AND r.app_block = 0 ========================2018-09-19 14:51:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rain1479' ========================2018-09-19 14:51:48======================== SELECT idx FROM macs WHERE mac_addr = '74C63BA2AADDF8EB58DC' AND app_code = '046' ========================2018-09-19 14:51:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260444' ========================2018-09-19 14:51:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260444' ========================2018-09-19 14:51:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260444', '74C63BA2AADDF8EB58DC', '046', '5775-경태', '110', '2560', '1080', 'rain1479', '한영사[고경태]', '343408108095' ) ========================2018-09-19 15:38:09======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04C97BE4634627EBF sCDKey = 756635870096 sName = POS-PC ========================2018-09-19 15:38:09======================== 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 = '756635870096' AND r.app_code = '046' AND r.app_block = 0 ========================2018-09-19 15:38:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wonmusic0' ========================2018-09-19 15:38:09======================== SELECT idx FROM macs WHERE mac_addr = '00E04C97BE4634627EBF' AND app_code = '046' ========================2018-09-19 15:38:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260451' ========================2018-09-19 15:38:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260451' ========================2018-09-19 15:38:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260451', '00E04C97BE4634627EBF', '046', 'POS-PC', '90', '1024', '768', 'wonmusic0', '주)원뮤직악기사[함영옥]', '756635870096' ) ========================2018-09-19 16:01:36======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D435951D7A90B006E6 sCDKey = 926109316951 sName = WIN7-PC ========================2018-09-19 16:01: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 = '926109316951' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-19 16:01:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'js5388' ========================2018-09-19 16:01:36======================== SELECT idx FROM macs WHERE mac_addr = '74D435951D7A90B006E6' AND app_code = '039' ========================2018-09-19 16:01:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260450' ========================2018-09-19 16:01:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260450' ========================2018-09-19 16:01: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 ( '260450', '74D435951D7A90B006E6', '039', 'WIN7-PC', '90', '1920', '1080', 'js5388', '(유)지산물류[조균호]', '926109316951' )