========================2020-12-31 00:33:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-65JG6QM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E085DD28D6165C168D sCDKey = 422114683375 sName = DESKTOP-65JG6QM ========================2020-12-31 00:33: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 = '422114683375' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-31 00:33:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'id4love' ========================2020-12-31 00:33:52======================== SELECT idx FROM macs WHERE mac_addr = '50E085DD28D6165C168D' AND app_code = '039' ========================2020-12-31 00:33:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '333578' ========================2020-12-31 00:33:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '333578' ========================2020-12-31 00:33:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '333578', '50E085DD28D6165C168D', '039', 'DESKTOP-65JG6QM', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375' ) ========================2020-12-31 09:31:47======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04CB1AF3798119493 sCDKey = 685230340148 sName = POS-PC ========================2020-12-31 09:31:47======================== 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 = '685230340148' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-31 09:31:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'petclubgj' ========================2020-12-31 09:31:47======================== SELECT idx FROM macs WHERE mac_addr = '00E04CB1AF3798119493' AND app_code = '046' ========================2020-12-31 09:31:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '333591' ========================2020-12-31 09:31:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '333591' ========================2020-12-31 09:31:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '333591', '00E04CB1AF3798119493', '046', 'POS-PC', '110', '1024', '768', 'petclubgj', '펫클럽퍼스트도그[김기은]', '685230340148' ) ========================2020-12-31 10:26:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9A4ICKI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A989F27AA1A5F5 sCDKey = 615248701701 sName = DESKTOP-9A4ICKI ========================2020-12-31 10:26: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 = '615248701701' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-31 10:26:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhs1859' ========================2020-12-31 10:26:46======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A989F27AA1A5F5' AND app_code = '039' ========================2020-12-31 10:26:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '333569' ========================2020-12-31 10:26:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '333569' ========================2020-12-31 10:26:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '333569', '50B7C3A989F27AA1A5F5', '039', 'DESKTOP-9A4ICKI', '110', '1920', '1080', 'jhs1859', '보임텍[심재혁]', '615248701701' ) ========================2020-12-31 10:47:42======================== noteurl_start parm_app_code = 046 parm_pc_name = N08OCZ93YJCFRUW parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975A6F3586F8D6576E sCDKey = 685230340148 sName = N08OCZ93YJCFRUW ========================2020-12-31 10:47:42======================== 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 = '685230340148' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-31 10:47:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'petclubgj' ========================2020-12-31 10:47:42======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A6F3586F8D6576E' AND app_code = '046' ========================2020-12-31 10:47:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272613' ========================2020-12-31 10:47:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272613' ========================2020-12-31 10:47:42======================== UPDATE mac_detail SET pc_name = 'N08OCZ93YJCFRUW', os_type = '64', user_id = 'petclubgj', user_name = '펫클럽퍼스트도그[김기은]', screen_w = '1024', screen_h = '768', cdkey = '685230340148' WHERE mac_idx = '272613' ========================2020-12-31 15:48:20======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BFMLV8Q parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 909F33EBE3339C787701 sCDKey = 460028709655 sName = DESKTOP-BFMLV8Q ========================2020-12-31 15:48: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 = '460028709655' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-31 15:48:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jm7337' ========================2020-12-31 15:48:20======================== SELECT idx FROM macs WHERE mac_addr = '909F33EBE3339C787701' AND app_code = '046' ========================2020-12-31 15:48:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288582' ========================2020-12-31 15:48:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288582' ========================2020-12-31 15:48:20======================== UPDATE mac_detail SET pc_name = 'DESKTOP-BFMLV8Q', os_type = '110', user_id = 'jm7337', user_name = '레드스완[권서연]', screen_w = '1680', screen_h = '1050', cdkey = '460028709655' WHERE mac_idx = '288582' ========================2020-12-31 15:55:09======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-KSIE9ESM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4C1D968752499AE370EC sCDKey = 774078853154 sName = LAPTOP-KSIE9ESM ========================2020-12-31 15:55:09======================== 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 = '774078853154' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-31 15:55:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ja2126' ========================2020-12-31 15:55:09======================== SELECT idx FROM macs WHERE mac_addr = '4C1D968752499AE370EC' AND app_code = '039' ========================2020-12-31 15:55:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '333627' ========================2020-12-31 15:55:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '333627' ========================2020-12-31 15:55:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '333627', '4C1D968752499AE370EC', '039', 'LAPTOP-KSIE9ESM', '110', '1920', '1080', 'ja2126', '형제상사[윤종태]', '774078853154' ) ========================2020-12-31 17:17:10======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00E04CB1DB3D98119493 sCDKey = 918717095898 sName = POS-PC ========================2020-12-31 17:17:10======================== 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 = '918717095898' AND r.app_code = '047' AND r.app_block = 0 ========================2020-12-31 17:17:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ybbike' ========================2020-12-31 17:17:10======================== SELECT idx FROM macs WHERE mac_addr = '00E04CB1DB3D98119493' AND app_code = '047' ========================2020-12-31 17:17:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '333638' ========================2020-12-31 17:17:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '333638' ========================2020-12-31 17:17:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '333638', '00E04CB1DB3D98119493', '047', 'POS-PC', '�쐢�룄�슦 10', '0', '0', 'ybbike', 'yb바이크 성북구자전거가게[김용백]', '918717095898' )