========================2018-06-05 10:01:07======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 90 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 902B344F66B49AF86715 sCDKey = 287132114565 sName = 이노아이코리아 ========================2018-06-05 10:01: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 = '287132114565' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-05 10:01:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'innoikorea' ========================2018-06-05 10:01:07======================== SELECT idx FROM macs WHERE mac_addr = '902B344F66B49AF86715' AND app_code = '046' ========================2018-06-05 10:01:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251315' ========================2018-06-05 10:01:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251315' ========================2018-06-05 10:01: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 ( '251315', '902B344F66B49AF86715', '046', '이노아이코리아', '90', '1360', '768', 'innoikorea', '(주)이노아이코리아[이병일]', '287132114565' ) ========================2018-06-05 10:34:57======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-R29FI2O parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8C497146D5757AAB197 sCDKey = 452775506015 sName = DESKTOP-R29FI2O ========================2018-06-05 10:34:57======================== 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 = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2018-06-05 10:34:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ecstel' ========================2018-06-05 10:34:57======================== SELECT idx FROM macs WHERE mac_addr = 'D8C497146D5757AAB197' AND app_code = '050' ========================2018-06-05 10:34:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251216' ========================2018-06-05 10:34:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251216' ========================2018-06-05 10:34:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251216', 'D8C497146D5757AAB197', '050', 'DESKTOP-R29FI2O', '109', '1536', '864', 'ecstel', '(주)이씨에스텔레콤[유지해]', '452775506015' ) ========================2018-06-05 11:10:16======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-F64C89G4UEK parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 408D5CF468A65BF370 sCDKey = 553020546151 sName = WIN-F64C89G4UEK ========================2018-06-05 11:10:16======================== 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 = '553020546151' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-05 11:10:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nhd563' ========================2018-06-05 11:10:16======================== SELECT idx FROM macs WHERE mac_addr = '408D5CF468A65BF370' AND app_code = '039' ========================2018-06-05 11:10:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251349' ========================2018-06-05 11:10:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251349' ========================2018-06-05 11:10:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251349', '408D5CF468A65BF370', '039', 'WIN-F64C89G4UEK', '90', '1280', '1024', 'nhd563', '대한기업(주)[이충규]', '553020546151' ) ========================2018-06-05 11:53:13======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-FT4D2MEMUSI parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001CC0FBAC9E907DE66C sCDKey = 271340129174 sName = WIN-FT4D2MEMUSI ========================2018-06-05 11:53:13======================== 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 = '271340129174' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-05 11:53:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'good2003' ========================2018-06-05 11:53:13======================== SELECT idx FROM macs WHERE mac_addr = '001CC0FBAC9E907DE66C' AND app_code = '039' ========================2018-06-05 11:53:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251356' ========================2018-06-05 11:53:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251356' ========================2018-06-05 11:53:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251356', '001CC0FBAC9E907DE66C', '039', 'WIN-FT4D2MEMUSI', '90', '1920', '1080', 'good2003', '(주)N.E KOREA[김종국]', '271340129174' ) ========================2018-06-05 15:35:51======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 902B3492E9DE2A48AB73 sCDKey = 013212832239 sName = PC ========================2018-06-05 15:35: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 = '013212832239' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-05 15:35:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jmf0918' ========================2018-06-05 15:35:51======================== SELECT idx FROM macs WHERE mac_addr = '902B3492E9DE2A48AB73' AND app_code = '039' ========================2018-06-05 15:35:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251383' ========================2018-06-05 15:35:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251383' ========================2018-06-05 15:35: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 ( '251383', '902B3492E9DE2A48AB73', '039', 'PC', '90', '1680', '1050', 'jmf0918', '세일상사[윤종면]', '013212832239' ) ========================2018-06-05 15:38:18======================== noteurl_start parm_app_code = 047 parm_pc_name = 사무실1-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 94DE80A9244D90E0C874 sCDKey = 058523340290 sName = 사무실1-PC ========================2018-06-05 15:38: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 = '058523340290' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-05 15:38:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'judofts' ========================2018-06-05 15:38:18======================== SELECT idx FROM macs WHERE mac_addr = '94DE80A9244D90E0C874' AND app_code = '047' ========================2018-06-05 15:38:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235876' ========================2018-06-05 15:38:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235876' ========================2018-06-05 15:38:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '235876', '94DE80A9244D90E0C874', '047', '사무실1-PC', '�쐢�룄�슦 10', '0', '0', 'judofts', '주도낚시[최대선]', '058523340290' ) ========================2018-06-05 16:17:19======================== noteurl_start parm_app_code = 039 parm_pc_name = JBH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0A8CDE8C3A8B617DE69 sCDKey = 550400830049 sName = JBH-PC ========================2018-06-05 16:17:19======================== 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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-05 16:17:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bmtec' ========================2018-06-05 16:17:19======================== SELECT idx FROM macs WHERE mac_addr = 'A0A8CDE8C3A8B617DE69' AND app_code = '039' ========================2018-06-05 16:17:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '171942' ========================2018-06-05 16:17:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '171942' ========================2018-06-05 16:17:19======================== UPDATE mac_detail SET pc_name = 'JBH-PC', os_type = '110', user_id = 'bmtec', user_name = 'BMTEC[전보현]', screen_w = '1920', screen_h = '1080', cdkey = '550400830049' WHERE mac_idx = '171942' ========================2018-06-05 16:17:31======================== noteurl_start parm_app_code = 039 parm_pc_name = JBH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A0A8CDE8C3A8B617DE69 sCDKey = 550400830049 sName = JBH-PC ========================2018-06-05 16:17: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 = '550400830049' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-05 17:18:24======================== noteurl_start parm_app_code = 046 parm_pc_name = POS01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = C03FD5BF6F3D90810A20 sCDKey = 978890224543 sName = POS01 ========================2018-06-05 17:18:24======================== 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 = '978890224543' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-05 17:18:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ddd1972' ========================2018-06-05 17:18:24======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BF6F3D90810A20' AND app_code = '046' ========================2018-06-05 17:18:24======================== 값이 없을 경우 ========================2018-06-05 17:18:31======================== noteurl_start parm_app_code = 046 parm_pc_name = POS01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = C03FD5BF6F3D90810A20 sCDKey = 978890224543 sName = POS01 ========================2018-06-05 17:18: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 = '978890224543' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-05 17:18:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ddd1972' ========================2018-06-05 17:18:31======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BF6F3D90810A20' AND app_code = '046' ========================2018-06-05 17:18:31======================== 값이 없을 경우 ========================2018-06-05 17:19:24======================== noteurl_start parm_app_code = 046 parm_pc_name = POS01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = C03FD5BF6F3D90810A20 sCDKey = 978890224543 sName = POS01 ========================2018-06-05 17:19:24======================== 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 = '978890224543' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-05 17:19:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ddd1972' ========================2018-06-05 17:19:24======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BF6F3D90810A20' AND app_code = '046' ========================2018-06-05 17:19:24======================== 값이 없을 경우 ========================2018-06-05 17:24:13======================== noteurl_start parm_app_code = 046 parm_pc_name = POS01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = C03FD5BF6F3D90810A20 sCDKey = 978890224543 sName = POS01 ========================2018-06-05 17:24:13======================== 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 = '978890224543' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-05 17:24:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ddd1972' ========================2018-06-05 17:24:13======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BF6F3D90810A20' AND app_code = '046' ========================2018-06-05 17:24:13======================== 값이 없을 경우 ========================2018-06-05 17:27:17======================== noteurl_start parm_app_code = 046 parm_pc_name = POS01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = C03FD5BF6F3D90810A20 sCDKey = 978890224543 sName = POS01 ========================2018-06-05 17:27:17======================== 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 = '978890224543' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-05 17:27:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ddd1972' ========================2018-06-05 17:27:17======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BF6F3D90810A20' AND app_code = '046' ========================2018-06-05 17:27:17======================== 값이 없을 경우 ========================2018-06-05 17:30:26======================== noteurl_start parm_app_code = 046 parm_pc_name = POS01 parm_os_type = 64 parm_screen_w = 768 parm_screen_h = 768 parm_user_mac = C03FD5BF6F3D90810A20 sCDKey = 978890224543 sName = POS01 ========================2018-06-05 17:30: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 = '978890224543' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-05 17:30:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ddd1972' ========================2018-06-05 17:30:26======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5BF6F3D90810A20' AND app_code = '046' ========================2018-06-05 17:30:26======================== 값이 없을 경우