========================2018-08-20 09:30:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IRQT79A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74E5F905226A34A2F988 sCDKey = 491942713414 sName = DESKTOP-IRQT79A ========================2018-08-20 09:30: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 = '491942713414' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-20 09:30:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjosgs' ========================2018-08-20 09:30:20======================== SELECT idx FROM macs WHERE mac_addr = '74E5F905226A34A2F988' AND app_code = '039' ========================2018-08-20 09:30:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257257' ========================2018-08-20 09:30:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257257' ========================2018-08-20 09:30: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 ( '257257', '74E5F905226A34A2F988', '039', 'DESKTOP-IRQT79A', '110', '1920', '1080', 'hjosgs', '미래산기[신계숙]', '491942713414' ) ========================2018-08-20 11:44:42======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04C3D0FC634627EBF sCDKey = 640146154677 sName = POS-PC ========================2018-08-20 11:44: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 = '640146154677' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-20 11:44:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sf5408' ========================2018-08-20 11:44:42======================== SELECT idx FROM macs WHERE mac_addr = '00E04C3D0FC634627EBF' AND app_code = '046' ========================2018-08-20 11:44:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257612' ========================2018-08-20 11:44:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257612' ========================2018-08-20 11:44:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '257612', '00E04C3D0FC634627EBF', '046', 'POS-PC', '90', '1024', '768', 'sf5408', '호승식품[이명철]', '640146154677' ) ========================2018-08-20 11:55:38======================== noteurl_start parm_app_code = 039 parm_pc_name = KDMAIN parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 705A0F3B415DF8F96132 sCDKey = 146845660413 sName = KDMAIN ========================2018-08-20 11:55:38======================== 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 = '146845660413' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-20 11:55:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kd4052' ========================2018-08-20 11:55:38======================== SELECT idx FROM macs WHERE mac_addr = '705A0F3B415DF8F96132' AND app_code = '039' ========================2018-08-20 11:55:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257614' ========================2018-08-20 11:55:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257614' ========================2018-08-20 11:55:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '257614', '705A0F3B415DF8F96132', '039', 'KDMAIN', '90', '1920', '1080', 'kd4052', '극동타이어[정막래]', '146845660413' ) ========================2018-08-20 13:17:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9ONUDI6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B520095A502EA399C6 sCDKey = 069782472175 sName = DESKTOP-9ONUDI6 ========================2018-08-20 13:17:06======================== 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 = '069782472175' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-20 13:17:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wibh8572' ========================2018-08-20 13:17:06======================== SELECT idx FROM macs WHERE mac_addr = 'F4B520095A502EA399C6' AND app_code = '039' ========================2018-08-20 13:17:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257621' ========================2018-08-20 13:17:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257621' ========================2018-08-20 13:17:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '257621', 'F4B520095A502EA399C6', '039', 'DESKTOP-9ONUDI6', '110', '1920', '1080', 'wibh8572', '(유)양지뜰 푸드시스템[위보훈]', '069782472175' ) ========================2018-08-20 14:36:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-T31F6OG parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 2C4D54D134D2CE15D466 sCDKey = 941461904095 sName = DESKTOP-T31F6OG ========================2018-08-20 14:36: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 = '941461904095' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-20 14:36:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'saehan8501' ========================2018-08-20 14:36:30======================== SELECT idx FROM macs WHERE mac_addr = '2C4D54D134D2CE15D466' AND app_code = '039' ========================2018-08-20 14:36:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257629' ========================2018-08-20 14:36:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257629' ========================2018-08-20 14:36:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '257629', '2C4D54D134D2CE15D466', '039', 'DESKTOP-T31F6OG', '110', '1600', '900', 'saehan8501', '새한용사엔지니어링[김육만]', '941461904095' ) ========================2018-08-20 16:03:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EPHSEND parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30ADAE106CD18B01 sCDKey = 720415474081 sName = DESKTOP-EPHSEND ========================2018-08-20 16:03:02======================== 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 = '720415474081' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-20 16:03:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EPHSEND parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30ADAE106CD18B01 sCDKey = 720431547408 sName = DESKTOP-EPHSEND ========================2018-08-20 16:03: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 = '720431547408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-20 16:04:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EPHSEND parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30ADAE106CD18B01 sCDKey = 720431547408 sName = DESKTOP-EPHSEND ========================2018-08-20 16:04: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 = '720431547408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-20 16:04:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mircrow' ========================2018-08-20 16:04:48======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30ADAE106CD18B01' AND app_code = '039' ========================2018-08-20 16:04:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239807' ========================2018-08-20 16:04:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239807' ========================2018-08-20 16:04:48======================== UPDATE mac_detail SET pc_name = 'DESKTOP-EPHSEND', os_type = '110', user_id = 'mircrow', user_name = '서울경인두부류제조협동조합[권오복]', screen_w = '1920', screen_h = '1080', cdkey = '720431547408' WHERE mac_idx = '239807' ========================2018-08-20 16:07:38======================== noteurl_start parm_app_code = 047 parm_pc_name = USER-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732B6C685A0E160A sCDKey = 752714601735 sName = USER-PC ========================2018-08-20 16:07:38======================== 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 = '752714601735' AND r.app_code = '047' AND r.app_block = 0 ========================2018-08-20 16:07:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adre9' ========================2018-08-20 16:07:38======================== SELECT idx FROM macs WHERE mac_addr = '50AF732B6C685A0E160A' AND app_code = '047' ========================2018-08-20 16:07:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257642' ========================2018-08-20 16:07:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257642' ========================2018-08-20 16:07:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '257642', '50AF732B6C685A0E160A', '047', 'USER-PC', '�쐢�룄�슦 7', '0', '0', 'adre9', '아드레나인컴퍼니[문우신]', '752714601735' )