========================2019-08-02 14:43:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-ICA2FOL parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = BCD6205241533E51BFFC sCDKey = 513019903755 sName = DESKTOP-ICA2FOL ========================2019-08-02 14:43:17======================== 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 = '513019903755' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-02 14:43:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ghddang292' ========================2019-08-02 14:43:17======================== SELECT idx FROM macs WHERE mac_addr = 'BCD6205241533E51BFFC' AND app_code = '039' ========================2019-08-02 14:43:17======================== 값이 없을 경우 ========================2019-08-02 14:49:51======================== noteurl_start parm_app_code = 051 parm_pc_name = RICHCOM parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = ECA86BFB2C204081CEC4 sCDKey = 000013578077 sName = RICHCOM ========================2019-08-02 14:49:51======================== 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 = '000013578077' AND r.app_code = '051' AND r.app_block = 0 ========================2019-08-02 14:49:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2007' ========================2019-08-02 14:49:51======================== SELECT idx FROM macs WHERE mac_addr = 'ECA86BFB2C204081CEC4' AND app_code = '051' ========================2019-08-02 14:49:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292288' ========================2019-08-02 14:49:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292288' ========================2019-08-02 14:49:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292288', 'ECA86BFB2C204081CEC4', '051', 'RICHCOM', '90', '1920', '1200', 'blc2007', '주식회사 브레인콘텐츠[주식회사 브레인콘텐츠]', '000013578077' ) ========================2019-08-02 14:49:56======================== noteurl_start parm_app_code = 051 parm_pc_name = RICHCOM parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = ECA86BFB2C204081CEC4 sCDKey = 000013578077 sName = RICHCOM ========================2019-08-02 14:49:56======================== 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 = '000013578077' AND r.app_code = '051' AND r.app_block = 0 ========================2019-08-02 14:49:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2007' ========================2019-08-02 14:49:56======================== SELECT idx FROM macs WHERE mac_addr = 'ECA86BFB2C204081CEC4' AND app_code = '051' ========================2019-08-02 14:49:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292288' ========================2019-08-02 14:49:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292288' ========================2019-08-02 14:49:56======================== UPDATE mac_detail SET pc_name = 'RICHCOM', os_type = '90', user_id = 'blc2007', user_name = '주식회사 브레인콘텐츠[주식회사 브레인콘텐츠]', screen_w = '1920', screen_h = '1200', cdkey = '000013578077' WHERE mac_idx = '292288' ========================2019-08-02 15:00:26======================== noteurl_start parm_app_code = 046 parm_pc_name = OWNER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E0CA94A4C354893C86A sCDKey = 716825890343 sName = OWNER-PC ========================2019-08-02 15:00:26======================== 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 = '716825890343' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-02 15:00:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ecofarm89' ========================2019-08-02 15:00:26======================== SELECT idx FROM macs WHERE mac_addr = 'E0CA94A4C354893C86A' AND app_code = '046' ========================2019-08-02 15:00:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291806' ========================2019-08-02 15:00:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291806' ========================2019-08-02 15:00:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291806', 'E0CA94A4C354893C86A', '046', 'OWNER-PC', '90', '1366', '768', 'ecofarm89', '에코팜[석지훈]', '716825890343' ) ========================2019-08-02 16:50:30======================== noteurl_start parm_app_code = 039 parm_pc_name = ANC-20181005ZSD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0604205241539E21F266 sCDKey = 720550620617 sName = ANC-20181005ZSD ========================2019-08-02 16:50: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 = '720550620617' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-02 16:50:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wjadyd6350' ========================2019-08-02 16:50:30======================== SELECT idx FROM macs WHERE mac_addr = '0604205241539E21F266' AND app_code = '039' ========================2019-08-02 16:50:30======================== 값이 없을 경우 ========================2019-08-02 16:50:46======================== noteurl_start parm_app_code = 039 parm_pc_name = ANC-20181005ZSD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0604205241539E21F266 sCDKey = 720550620617 sName = ANC-20181005ZSD ========================2019-08-02 16:50:46======================== 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 = '720550620617' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-02 16:50:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wjadyd6350' ========================2019-08-02 16:50:46======================== SELECT idx FROM macs WHERE mac_addr = '0604205241539E21F266' AND app_code = '039' ========================2019-08-02 16:50:46======================== 값이 없을 경우 ========================2019-08-02 16:51:41======================== noteurl_start parm_app_code = 039 parm_pc_name = ANC-20181005ZSD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0604205241539E21F266 sCDKey = 720550620617 sName = ANC-20181005ZSD ========================2019-08-02 16:51: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 = '720550620617' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-02 16:51:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wjadyd6350' ========================2019-08-02 16:51:41======================== SELECT idx FROM macs WHERE mac_addr = '0604205241539E21F266' AND app_code = '039' ========================2019-08-02 16:51:41======================== 값이 없을 경우 ========================2019-08-02 16:53:20======================== noteurl_start parm_app_code = 039 parm_pc_name = ANC-20181005ZSD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0604205241539E21F266 sCDKey = 720550620617 sName = ANC-20181005ZSD ========================2019-08-02 16:53:20======================== 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 = '720550620617' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-02 16:53:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wjadyd6350' ========================2019-08-02 16:53:20======================== SELECT idx FROM macs WHERE mac_addr = '0604205241539E21F266' AND app_code = '039' ========================2019-08-02 16:53:20======================== 값이 없을 경우 ========================2019-08-02 16:58:59======================== noteurl_start parm_app_code = 039 parm_pc_name = KTJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 644547527760 sName = KTJ ========================2019-08-02 16:58:59======================== 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 = '644547527760' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-02 16:58:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeong4023' ========================2019-08-02 16:58:59======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '039' ========================2019-08-02 16:58:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269693' ========================2019-08-02 16:58:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269693' ========================2019-08-02 16:58:59======================== UPDATE mac_detail SET pc_name = 'KTJ', os_type = '110', user_id = 'jeong4023', user_name = '[김태정]', screen_w = '1920', screen_h = '1080', cdkey = '644547527760' WHERE mac_idx = '269693' ========================2019-08-02 17:16:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VH6GLU9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00D86157CE9166068864 sCDKey = 760147720564 sName = DESKTOP-VH6GLU9 ========================2019-08-02 17:16:18======================== 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 = '760147720564' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-02 17:16:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dudco7730' ========================2019-08-02 17:16:18======================== SELECT idx FROM macs WHERE mac_addr = '00D86157CE9166068864' AND app_code = '039' ========================2019-08-02 17:16:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292297' ========================2019-08-02 17:16:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292297' ========================2019-08-02 17:16:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292297', '00D86157CE9166068864', '039', 'DESKTOP-VH6GLU9', '110', '1920', '1080', 'dudco7730', '한일자동펌프[임영채]', '760147720564' ) ========================2019-08-02 17:16:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VH6GLU9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00D86157CE9166068864 sCDKey = 760147720564 sName = DESKTOP-VH6GLU9 ========================2019-08-02 17:16: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 = '760147720564' AND r.app_code = '039' AND r.app_block = 0