========================2018-07-16 09:02:49======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JSR3CCD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002522FD720F52BFB5D0 sCDKey = 116617546847 sName = DESKTOP-JSR3CCD ========================2018-07-16 09:02:49======================== 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 = '116617546847' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-16 09:02:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wooritools' ========================2018-07-16 09:02:49======================== SELECT idx FROM macs WHERE mac_addr = '002522FD720F52BFB5D0' AND app_code = '046' ========================2018-07-16 09:02:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254673' ========================2018-07-16 09:02:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254673' ========================2018-07-16 09:02:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254673', '002522FD720F52BFB5D0', '046', 'DESKTOP-JSR3CCD', '110', '1920', '1080', 'wooritools', '우리종합공구[김민재]', '116617546847' ) ========================2018-07-16 09:02:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JSR3CCD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002522FD720F52BFB5D0 sCDKey = 116617546847 sName = DESKTOP-JSR3CCD ========================2018-07-16 09:02:55======================== 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 = '116617546847' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-16 09:04:45======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 902189105864 sName = AHN-PC ========================2018-07-16 09:04:45======================== 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 = '902189105864' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-16 09:04:57======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 534930996551 sName = AHN-PC ========================2018-07-16 09:04: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 = '534930996551' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-16 09:08:19======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 637698524487 sName = AHN-PC ========================2018-07-16 09:08: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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-16 09:08:37======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 637698524487 sName = AHN-PC ========================2018-07-16 09:08:37======================== 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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-16 09:08:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-07-16 09:08:37======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73F08A9CF6' AND app_code = '050' ========================2018-07-16 09:08:37======================== 값이 없을 경우 ========================2018-07-16 09:09:12======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 637698524487 sName = AHN-PC ========================2018-07-16 09:09:12======================== 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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-16 09:09:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-07-16 09:09:12======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73F08A9CF6' AND app_code = '050' ========================2018-07-16 09:09:12======================== 값이 없을 경우 ========================2018-07-16 09:14:38======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 637698524487 sName = AHN-PC ========================2018-07-16 09:14: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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-16 09:15:04======================== noteurl_start parm_app_code = 050 parm_pc_name = AHN-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 38D547280D73F08A9CF6 sCDKey = 637698524487 sName = AHN-PC ========================2018-07-16 09:15: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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-16 09:15:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-07-16 09:15:04======================== SELECT idx FROM macs WHERE mac_addr = '38D547280D73F08A9CF6' AND app_code = '050' ========================2018-07-16 09:15:04======================== 값이 없을 경우 ========================2018-07-16 10:06:50======================== noteurl_start parm_app_code = 046 parm_pc_name = TOYTOPIC parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = F44D30BB9BCF819D089 sCDKey = 601545468300 sName = TOYTOPIC ========================2018-07-16 10:06:50======================== 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 = '601545468300' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-16 10:06:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'toytopic' ========================2018-07-16 10:06:50======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BB9BCF819D089' AND app_code = '046' ========================2018-07-16 10:06:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254691' ========================2018-07-16 10:06:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254691' ========================2018-07-16 10:06:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254691', 'F44D30BB9BCF819D089', '046', 'TOYTOPIC', '110', '1600', '900', 'toytopic', '토이토픽(대치점)[오재영]', '601545468300' ) ========================2018-07-16 11:14:17======================== noteurl_start parm_app_code = 050 parm_pc_name = KIM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 909F33EAD82BC8889091 sCDKey = 123456789112 sName = KIM-PC ========================2018-07-16 11:14: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 = '123456789112' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-16 11:40:15======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-2U8TSHH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55EB32489D0448870 sCDKey = 435511149259 sName = DESKTOP-2U8TSHH ========================2018-07-16 11:40:15======================== 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 = '435511149259' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-16 11:40:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'didtkrl' ========================2018-07-16 11:40:15======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EB32489D0448870' AND app_code = '047' ========================2018-07-16 11:40:15======================== 값이 없을 경우 ========================2018-07-16 11:42:15======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-2U8TSHH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55EB32489D0448870 sCDKey = 435511149259 sName = DESKTOP-2U8TSHH ========================2018-07-16 11:42:15======================== 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 = '435511149259' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-16 11:42:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'didtkrl' ========================2018-07-16 11:42:15======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EB32489D0448870' AND app_code = '047' ========================2018-07-16 11:42:15======================== 값이 없을 경우 ========================2018-07-16 16:19:46======================== noteurl_start parm_app_code = 046 parm_pc_name = P1804-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E57A2F0DEC403C1 sCDKey = 270965864323 sName = P1804-PC ========================2018-07-16 16:19: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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-16 16:19:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2018-07-16 16:19:46======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E57A2F0DEC403C1' AND app_code = '046' ========================2018-07-16 16:19:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248670' ========================2018-07-16 16:19:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248670' ========================2018-07-16 16:19: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 ( '248670', 'E0D55E57A2F0DEC403C1', '046', 'P1804-PC', '90', '1920', '1080', 'kyr0909', '동양종합식품[김영록]', '270965864323' ) ========================2018-07-16 16:20:11======================== noteurl_start parm_app_code = 046 parm_pc_name = 사물실3-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D435E9A9215207A462 sCDKey = 270965864323 sName = 사물실3-PC ========================2018-07-16 16:20:11======================== 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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-16 16:20:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2018-07-16 16:20:11======================== SELECT idx FROM macs WHERE mac_addr = '74D435E9A9215207A462' AND app_code = '046' ========================2018-07-16 16:20:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '210006' ========================2018-07-16 16:20:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '210006' ========================2018-07-16 16:20:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '210006', '74D435E9A9215207A462', '046', '사물실3-PC', '90', '1920', '1080', 'kyr0909', '동양종합식품[김영록]', '270965864323' ) ========================2018-07-16 16:24:09======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94DE80FA8278DA9C3468 sCDKey = 270965864323 sName = POS2-PC ========================2018-07-16 16:24: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 = '270965864323' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-16 16:24:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr0909' ========================2018-07-16 16:24:09======================== SELECT idx FROM macs WHERE mac_addr = '94DE80FA8278DA9C3468' AND app_code = '046' ========================2018-07-16 16:24:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198031' ========================2018-07-16 16:24:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198031' ========================2018-07-16 16:24:09======================== UPDATE mac_detail SET pc_name = 'POS2-PC', os_type = '90', user_id = 'kyr0909', user_name = '동양종합식품[김영록]', screen_w = '1920', screen_h = '1080', cdkey = '270965864323' WHERE mac_idx = '198031'