========================2020-04-06 09:05:59======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-37IU5AJ parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 7085C2CC4EA824FE4468 sCDKey = 975677425073 sName = POS2-200406 ========================2020-04-06 09:05:59======================== 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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-06 09:05:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2020-04-06 09:05:59======================== SELECT idx FROM macs WHERE mac_addr = '7085C2CC4EA824FE4468' AND app_code = '046' ========================2020-04-06 09:05:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314729' ========================2020-04-06 09:05:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314729' ========================2020-04-06 09:05:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314729', '7085C2CC4EA824FE4468', '046', 'POS2-200406', '110', '1024', '768', 'ami2881', '아미상사[이재훈]', '975677425073' ) ========================2020-04-06 09:41:18======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GO8STMH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E902FF976DBC9E9 sCDKey = 342918991698 sName = DESKTOP-GO8STMH ========================2020-04-06 09:41:18======================== 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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-06 09:41:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2020-04-06 09:41:18======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E902FF976DBC9E9' AND app_code = '046' ========================2020-04-06 09:41:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313008' ========================2020-04-06 09:41:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313008' ========================2020-04-06 09:41:18======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GO8STMH', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]', screen_w = '1920', screen_h = '1080', cdkey = '342918991698' WHERE mac_idx = '313008' ========================2020-04-06 11:19:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-C0C801B parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D43D7E558A21FAA5B084 sCDKey = 552641487169 sName = DESKTOP-C0C801B ========================2020-04-06 11:19: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 = '552641487169' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-06 11:19:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chosw65' ========================2020-04-06 11:19:41======================== SELECT idx FROM macs WHERE mac_addr = 'D43D7E558A21FAA5B084' AND app_code = '039' ========================2020-04-06 11:19:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314707' ========================2020-04-06 11:19:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314707' ========================2020-04-06 11:19:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314707', 'D43D7E558A21FAA5B084', '039', 'DESKTOP-C0C801B', '110', '1920', '1080', 'chosw65', '주신푸드[조성원]', '552641487169' ) ========================2020-04-06 14:18:22======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-HPFTTFS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00266604F2D0A68259A2 sCDKey = 721130173697 sName = DESKTOP-HPFTTFS ========================2020-04-06 14:18:22======================== 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 = '721130173697' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-06 14:18:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samwon6440' ========================2020-04-06 14:18:22======================== SELECT idx FROM macs WHERE mac_addr = '00266604F2D0A68259A2' AND app_code = '046' ========================2020-04-06 14:18:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314765' ========================2020-04-06 14:18:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314765' ========================2020-04-06 14:18:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314765', '00266604F2D0A68259A2', '046', 'DESKTOP-HPFTTFS', '110', '1920', '1080', 'samwon6440', '삼원유통[박범진]', '721130173697' ) ========================2020-04-06 14:39:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BLVEMUP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 40A8F0660C4D6033E2A2 sCDKey = 002210892571 sName = DESKTOP-BLVEMUP ========================2020-04-06 14:39: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 = '002210892571' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-06 14:39:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wook7967' ========================2020-04-06 14:39:30======================== SELECT idx FROM macs WHERE mac_addr = '40A8F0660C4D6033E2A2' AND app_code = '039' ========================2020-04-06 14:39:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314767' ========================2020-04-06 14:39:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314767' ========================2020-04-06 14:39: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 ( '314767', '40A8F0660C4D6033E2A2', '039', 'DESKTOP-BLVEMUP', '110', '1920', '1080', 'wook7967', '티제이메탈[김종욱]', '002210892571' ) ========================2020-04-06 15:15:48======================== noteurl_start parm_app_code = 039 parm_pc_name = LG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C808E971F4E0F42A16E0 sCDKey = 701543551076 sName = LG ========================2020-04-06 15:15: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 = '701543551076' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-06 15:15:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hkmetals' ========================2020-04-06 15:15:48======================== SELECT idx FROM macs WHERE mac_addr = 'C808E971F4E0F42A16E0' AND app_code = '039' ========================2020-04-06 15:15:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314772' ========================2020-04-06 15:15:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314772' ========================2020-04-06 15:15:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314772', 'C808E971F4E0F42A16E0', '039', 'LG', '110', '1920', '1080', 'hkmetals', '해광금속[김원일]', '701543551076' ) ========================2020-04-06 16:08:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-U89J5H6 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B42E99ED83178A473CD4 sCDKey = 107601679230 sName = DESKTOP-U89J5H6 ========================2020-04-06 16:08:04======================== 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 = '107601679230' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-06 16:08:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bgj8664' ========================2020-04-06 16:08:04======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99ED83178A473CD4' AND app_code = '039' ========================2020-04-06 16:08:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '314784' ========================2020-04-06 16:08:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '314784' ========================2020-04-06 16:08:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '314784', 'B42E99ED83178A473CD4', '039', 'DESKTOP-U89J5H6', '110', '1280', '1024', 'bgj8664', '명도특수인쇄[복기정]', '107601679230' )