========================2019-08-06 13:10:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VKPU7IC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B42E9965591B8E86AB69 sCDKey = 057096428680 sName = DESKTOP-VKPU7IC ========================2019-08-06 13:10: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 = '057096428680' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-06 13:10:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youngji1226' ========================2019-08-06 13:10:03======================== SELECT idx FROM macs WHERE mac_addr = 'B42E9965591B8E86AB69' AND app_code = '039' ========================2019-08-06 13:10:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292528' ========================2019-08-06 13:10:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292528' ========================2019-08-06 13:10: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 ( '292528', 'B42E9965591B8E86AB69', '039', 'DESKTOP-VKPU7IC', '110', '1536', '864', 'youngji1226', '(주)영지테크[(주)영지테크]', '057096428680' ) ========================2019-08-06 13:45:41======================== noteurl_start parm_app_code = 046 parm_pc_name = DALLAITI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE5B65174258B30 sCDKey = 892232246788 sName = DALLAITI ========================2019-08-06 13:45: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 = '892232246788' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-06 13:45:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kumnam' ========================2019-08-06 13:45:41======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE5B65174258B30' AND app_code = '046' ========================2019-08-06 13:45:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '160264' ========================2019-08-06 13:45:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '160264' ========================2019-08-06 13:45:41======================== UPDATE mac_detail SET pc_name = 'DALLAITI', os_type = '110', user_id = 'kumnam', user_name = '(주)금남[한진용]', screen_w = '1920', screen_h = '1080', cdkey = '892232246788' WHERE mac_idx = '160264' ========================2019-08-06 14:17:32======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BFMLV8Q parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 909F33EBE3339C787701 sCDKey = 460028709655 sName = DESKTOP-BFMLV8Q ========================2019-08-06 14:17: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 = '460028709655' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-06 14:17:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jm7337' ========================2019-08-06 14:17:32======================== SELECT idx FROM macs WHERE mac_addr = '909F33EBE3339C787701' AND app_code = '046' ========================2019-08-06 14:17:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288582' ========================2019-08-06 14:17:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288582' ========================2019-08-06 14:17:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '288582', '909F33EBE3339C787701', '046', 'DESKTOP-BFMLV8Q', '110', '1280', '1024', 'jm7337', 'jm[권서연]', '460028709655' ) ========================2019-08-06 14:17:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BFMLV8Q parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 909F33EBE3339C787701 sCDKey = 460028709655 sName = DESKTOP-BFMLV8Q ========================2019-08-06 14:17: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 = '460028709655' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-06 14:46:36======================== noteurl_start parm_app_code = 039 parm_pc_name = F-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF4DA02318ECE7AA9 sCDKey = 379382963814 sName = F-PC ========================2019-08-06 14:46: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 = '379382963814' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-06 14:46:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'slaisjiny' ========================2019-08-06 14:46:36======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DA02318ECE7AA9' AND app_code = '039' ========================2019-08-06 14:46:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '207309' ========================2019-08-06 14:46:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '207309' ========================2019-08-06 14:46:36======================== UPDATE mac_detail SET pc_name = 'F-PC', os_type = '90', user_id = 'slaisjiny', user_name = '영운상사[김진희]', screen_w = '1920', screen_h = '1080', cdkey = '379382963814' WHERE mac_idx = '207309' ========================2019-08-06 15:48:07======================== noteurl_start parm_app_code = 051 parm_pc_name = 배미숙 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389DD672770B59AC3 sCDKey = 670894355181 sName = 배미숙 ========================2019-08-06 15:48:07======================== 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 = '670894355181' AND r.app_code = '051' AND r.app_block = 0 ========================2019-08-06 15:48:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'across' ========================2019-08-06 15:48:07======================== SELECT idx FROM macs WHERE mac_addr = '988389DD672770B59AC3' AND app_code = '051' ========================2019-08-06 15:48:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290111' ========================2019-08-06 15:48:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290111' ========================2019-08-06 15:48:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290111', '988389DD672770B59AC3', '051', '배미숙', '109', '1920', '1080', 'across', '아크로스[김현철]', '670894355181' )