========================2019-01-18 09:19:40======================== noteurl_start parm_app_code = 050 parm_pc_name = HJW-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23E60CB96AC8D143 sCDKey = 964152660225 sName = HJW-PC ========================2019-01-18 09:19:40======================== 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 = '964152660225' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-18 09:19:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjw179' ========================2019-01-18 09:19:40======================== SELECT idx FROM macs WHERE mac_addr = '309C23E60CB96AC8D143' AND app_code = '050' ========================2019-01-18 09:19:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259838' ========================2019-01-18 09:19:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '259838' ========================2019-01-18 09:19:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '259838', '309C23E60CB96AC8D143', '050', 'HJW-PC', '109', '1920', '1080', 'hjw179', '엠제이소프트[홍재원]', '964152660225' ) ========================2019-01-18 09:46:55======================== noteurl_start parm_app_code = 050 parm_pc_name = ROK-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1078D24A72D6C80FC73C sCDKey = 037873364154 sName = ROK-PC ========================2019-01-18 09:46:55======================== 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 = '037873364154' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-18 09:47:11======================== noteurl_start parm_app_code = 050 parm_pc_name = ROK-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1078D24A72D6C80FC73C sCDKey = 037873364154 sName = ROK-PC ========================2019-01-18 09:47: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 = '037873364154' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-18 10:18:26======================== noteurl_start parm_app_code = 050 parm_pc_name = ROK-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1078D24A72D6C80FC73C sCDKey = 037873364154 sName = ROK-PC ========================2019-01-18 10:18: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 = '037873364154' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-18 10:18:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'barcodelab' ========================2019-01-18 10:18:26======================== SELECT idx FROM macs WHERE mac_addr = '1078D24A72D6C80FC73C' AND app_code = '050' ========================2019-01-18 10:18:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '225905' ========================2019-01-18 10:18:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '225905' ========================2019-01-18 10:18:26======================== UPDATE mac_detail SET pc_name = 'ROK-PC', os_type = '90', user_id = 'barcodelab', user_name = '바코드랩[신중환]', screen_w = '1680', screen_h = '1050', cdkey = '037873364154' WHERE mac_idx = '225905' ========================2019-01-18 11:45:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5VL8BK7 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 38F9D35FCEF82469FF7 sCDKey = 489985381270 sName = DESKTOP-5VL8BK7 ========================2019-01-18 11:45: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 = '489985381270' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-18 11:45:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'edh0000' ========================2019-01-18 11:45:20======================== SELECT idx FROM macs WHERE mac_addr = '38F9D35FCEF82469FF7' AND app_code = '039' ========================2019-01-18 11:45:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274570' ========================2019-01-18 11:45:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274570' ========================2019-01-18 11:45:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274570', '38F9D35FCEF82469FF7', '039', 'DESKTOP-5VL8BK7', '110', '1280', '800', 'edh0000', '랩에쏘[엄동현]', '489985381270' ) ========================2019-01-18 11:45:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5VL8BK7 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 38F9D35FCEF82469FF7 sCDKey = 489985381270 sName = DESKTOP-5VL8BK7 ========================2019-01-18 11:45: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 = '489985381270' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-18 13:25:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KNSNAC5 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E9918624A1002637C sCDKey = 792302919414 sName = DESKTOP-KNSNAC5 ========================2019-01-18 13:25:33======================== 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 = '792302919414' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-18 13:25:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjih2616' ========================2019-01-18 13:25:33======================== SELECT idx FROM macs WHERE mac_addr = 'B42E9918624A1002637C' AND app_code = '039' ========================2019-01-18 13:25:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274587' ========================2019-01-18 13:25:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274587' ========================2019-01-18 13:25:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274587', 'B42E9918624A1002637C', '039', 'DESKTOP-KNSNAC5', '110', '1920', '1080', 'kjih2616', '명성기공[김진혁]', '792302919414' ) ========================2019-01-18 15:58:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-TQDL393 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0492264CDFDAFCED2024 sCDKey = 428480621063 sName = DESKTOP-TQDL393 ========================2019-01-18 15:58: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 = '428480621063' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-18 15:58:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ckdwls2005' ========================2019-01-18 15:58:31======================== SELECT idx FROM macs WHERE mac_addr = '0492264CDFDAFCED2024' AND app_code = '039' ========================2019-01-18 15:58:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274614' ========================2019-01-18 15:58:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274614' ========================2019-01-18 15:58: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 ( '274614', '0492264CDFDAFCED2024', '039', 'DESKTOP-TQDL393', '110', '1920', '1080', 'ckdwls2005', '창진공업[강동호]', '428480621063' )