========================2019-11-29 10:42:14======================== noteurl_start parm_app_code = 046 parm_pc_name = ANNA-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067BAEBDFB2760122 sCDKey = 755061866111 sName = ANNA-PC ========================2019-11-29 10:42:14======================== 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 = '755061866111' AND r.app_code = '046' AND r.app_block = 0 ========================2019-11-29 10:42:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyein1127' ========================2019-11-29 10:42:14======================== SELECT idx FROM macs WHERE mac_addr = '003067BAEBDFB2760122' AND app_code = '046' ========================2019-11-29 10:42:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248418' ========================2019-11-29 10:42:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248418' ========================2019-11-29 10:42:14======================== UPDATE mac_detail SET pc_name = 'ANNA-PC', os_type = '110', user_id = 'hyein1127', user_name = '[황혜인]', screen_w = '1920', screen_h = '1080', cdkey = '755061866111' WHERE mac_idx = '248418' ========================2019-11-29 11:08:58======================== noteurl_start parm_app_code = 048 parm_pc_name = 1F2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E900225034AB5220 sCDKey = 434133617514 sName = 1F2 ========================2019-11-29 11:08:58======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-11-29 11:08:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-11-29 11:08:58======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E900225034AB5220' AND app_code = '048' ========================2019-11-29 11:08:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304024' ========================2019-11-29 11:08:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304024' ========================2019-11-29 11:08:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '304024', '8CB0E900225034AB5220', '048', '1F2', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2019-11-29 13:49:48======================== noteurl_start parm_app_code = 047 parm_pc_name = YWD-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9B78D384E4B58 sCDKey = 534931489173 sName = YWD-PC ========================2019-11-29 13:49: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 = '534931489173' AND r.app_code = '047' AND r.app_block = 0 ========================2019-11-29 13:49:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'novasix' ========================2019-11-29 13:49:48======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B78D384E4B58' AND app_code = '047' ========================2019-11-29 13:49:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '222488' ========================2019-11-29 13:49:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '222488' ========================2019-11-29 13:49:48======================== UPDATE mac_detail SET pc_name = 'YWD-PC', os_type = '�쐢�룄�슦 10', user_id = 'novasix', user_name = 'MJ소프트[여욱동]', screen_w = '0', screen_h = '0', cdkey = '534931489173' WHERE mac_idx = '222488' ========================2019-11-29 16:01:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GDQEC53 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 94DE80E98CF5DA518237 sCDKey = 527769017292 sName = DESKTOP-GDQEC53 ========================2019-11-29 16:01: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 = '527769017292' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-29 16:01:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yytk77' ========================2019-11-29 16:01:31======================== SELECT idx FROM macs WHERE mac_addr = '94DE80E98CF5DA518237' AND app_code = '039' ========================2019-11-29 16:01:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304059' ========================2019-11-29 16:01:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304059' ========================2019-11-29 16:01: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 ( '304059', '94DE80E98CF5DA518237', '039', 'DESKTOP-GDQEC53', '110', '1680', '1050', 'yytk77', '왕왕테크[진거부]', '527769017292' ) ========================2019-11-29 17:11:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KI3USC1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A72E7396E8492F sCDKey = 702056635853 sName = DESKTOP-KI3USC1 ========================2019-11-29 17:11: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 = '702056635853' AND r.app_code = '039' AND r.app_block = 0 ========================2019-11-29 17:11:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pepe1230' ========================2019-11-29 17:11:51======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A72E7396E8492F' AND app_code = '039' ========================2019-11-29 17:11:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '304061' ========================2019-11-29 17:11:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '304061' ========================2019-11-29 17:11: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 ( '304061', '50B7C3A72E7396E8492F', '039', 'DESKTOP-KI3USC1', '110', '1920', '1080', 'pepe1230', '한라유통[조필용]', '702056635853' )