========================2018-05-30 09:06:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KTE3COG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6E260B4C69D7D2 sCDKey = 604081264526 sName = DESKTOP-KTE3COG ========================2018-05-30 09:06:31======================== 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 = '604081264526' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-30 09:06:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bruce1211' ========================2018-05-30 09:06:31======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6E260B4C69D7D2' AND app_code = '039' ========================2018-05-30 09:06:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250851' ========================2018-05-30 09:06:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250851' ========================2018-05-30 09:06:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250851', 'E8039A6E260B4C69D7D2', '039', 'DESKTOP-KTE3COG', '110', '1920', '1080', 'bruce1211', '카피어랜드 경기북부영업소[이찬행]', '604081264526' ) ========================2018-05-30 09:55:05======================== noteurl_start parm_app_code = 050 parm_pc_name = 오영근-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = B870F48FB2F1B23936C7 sCDKey = 678905519571 sName = 오영근-PC ========================2018-05-30 09:55: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 = '678905519571' AND r.app_code = '050' AND r.app_block = 0 ========================2018-05-30 09:55:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'solbar' ========================2018-05-30 09:55:05======================== SELECT idx FROM macs WHERE mac_addr = 'B870F48FB2F1B23936C7' AND app_code = '050' ========================2018-05-30 09:55:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250858' ========================2018-05-30 09:55:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250858' ========================2018-05-30 09:55: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 ( '250858', 'B870F48FB2F1B23936C7', '050', '오영근-PC', '90', '1366', '768', 'solbar', '(주)솔바텍[오영근]', '678905519571' ) ========================2018-05-30 11:20:03======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = E0D55E56FC682A13174D sCDKey = 126313433568 sName = USER-PC ========================2018-05-30 11:20:03======================== 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 = '126313433568' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-30 11:20:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nawoo2650' ========================2018-05-30 11:20:03======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E56FC682A13174D' AND app_code = '046' ========================2018-05-30 11:20:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250871' ========================2018-05-30 11:20:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250871' ========================2018-05-30 11:20:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250871', 'E0D55E56FC682A13174D', '046', 'USER-PC', '90', '1024', '768', 'nawoo2650', '중앙농약농자재센타[서상원]', '126313433568' ) ========================2018-05-30 14:48:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-57VB7Q9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30AD8E0AB01F0CD1 sCDKey = 965645130527 sName = DESKTOP-57VB7Q9 ========================2018-05-30 14:48: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 = '965645130527' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-30 14:48:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhs177' ========================2018-05-30 14:48:06======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30AD8E0AB01F0CD1' AND app_code = '039' ========================2018-05-30 14:48:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250898' ========================2018-05-30 14:48:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250898' ========================2018-05-30 14:48:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250898', 'F44D30AD8E0AB01F0CD1', '039', 'DESKTOP-57VB7Q9', '110', '1920', '1080', 'jhs177', '푸른교육사[진희성]', '965645130527' ) ========================2018-05-30 14:48:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-57VB7Q9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30AD8E0AB01F0CD1 sCDKey = 965645130527 sName = DESKTOP-57VB7Q9 ========================2018-05-30 14:48:13======================== 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 = '965645130527' AND r.app_code = '039' AND r.app_block = 0