========================2018-06-12 00:59:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DREAM-20180604T parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA14A051E6C8CD8309 sCDKey = 851112038872 sName = DREAM-20180604T ========================2018-06-12 00:59:25======================== 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 = '851112038872' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-12 00:59:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goclick01' ========================2018-06-12 00:59:25======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14A051E6C8CD8309' AND app_code = '039' ========================2018-06-12 00:59:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251809' ========================2018-06-12 00:59:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251809' ========================2018-06-12 00:59:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251809', 'FCAA14A051E6C8CD8309', '039', 'DREAM-20180604T', '90', '1920', '1080', 'goclick01', '제텍코리아[김형준]', '851112038872' ) ========================2018-06-12 12:10:15======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 001FE26BCBE627F99CC sCDKey = 175775530909 sName = MSDN-SPECIAL ========================2018-06-12 12:10: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 = '175775530909' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-12 13:59:44======================== noteurl_start parm_app_code = 046 parm_pc_name = SE-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C279F6413431B5AE sCDKey = 230018513014 sName = SE-PC ========================2018-06-12 13:59:44======================== 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 = '230018513014' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-12 13:59:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lch43481' ========================2018-06-12 13:59:44======================== SELECT idx FROM macs WHERE mac_addr = '7085C279F6413431B5AE' AND app_code = '046' ========================2018-06-12 13:59:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251837' ========================2018-06-12 13:59:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251837' ========================2018-06-12 13:59:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251837', '7085C279F6413431B5AE', '046', 'SE-PC', '90', '1920', '1080', 'lch43481', '조은에프엔씨[엄주성]', '230018513014' ) ========================2018-06-12 14:14:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OEKLFP7 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 309C23B7851B583AD05B sCDKey = 716806219602 sName = DESKTOP-OEKLFP7 ========================2018-06-12 14:14: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 = '716806219602' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-12 14:14:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qas6480' ========================2018-06-12 14:14:15======================== SELECT idx FROM macs WHERE mac_addr = '309C23B7851B583AD05B' AND app_code = '039' ========================2018-06-12 14:14:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251660' ========================2018-06-12 14:14:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251660' ========================2018-06-12 14:14:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251660', '309C23B7851B583AD05B', '039', 'DESKTOP-OEKLFP7', '110', '1600', '900', 'qas6480', '태양기계조각[전병배]', '716806219602' ) ========================2018-06-12 14:51:46======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732C0476EE2B1141 sCDKey = 315507678062 sName = DESKTOP-IR4BE71 ========================2018-06-12 14:51: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 = '315507678062' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-12 14:51:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'koossthree' ========================2018-06-12 14:51:46======================== SELECT idx FROM macs WHERE mac_addr = '50AF732C0476EE2B1141' AND app_code = '047' ========================2018-06-12 14:51:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251849' ========================2018-06-12 14:51:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251849' ========================2018-06-12 14:51: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 ( '251849', '50AF732C0476EE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'koossthree', '다우종합상사[박준성]', '315507678062' ) ========================2018-06-12 14:52:08======================== noteurl_start parm_app_code = 046 parm_pc_name = VISION-H61 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = E840F25E7ECD7C4EBAED sCDKey = 518069715941 sName = VISION-H61 ========================2018-06-12 14:52:08======================== 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 = '518069715941' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-12 14:52:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wss6011' ========================2018-06-12 14:52:08======================== SELECT idx FROM macs WHERE mac_addr = 'E840F25E7ECD7C4EBAED' AND app_code = '046' ========================2018-06-12 14:52:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '109939' ========================2018-06-12 14:52:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '109939' ========================2018-06-12 14:52:08======================== UPDATE mac_detail SET pc_name = 'VISION-H61', os_type = '64', user_id = 'wss6011', user_name = '청주신선낚시[위상선]', screen_w = '1024', screen_h = '768', cdkey = '518069715941' WHERE mac_idx = '109939' ========================2018-06-12 14:52:12======================== noteurl_start parm_app_code = 046 parm_pc_name = VISION-H61 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = E840F25E7ECD7C4EBAED sCDKey = 518069715941 sName = VISION-H61 ========================2018-06-12 14:52: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 = '518069715941' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-12 14:52:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wss6011' ========================2018-06-12 14:52:13======================== SELECT idx FROM macs WHERE mac_addr = 'E840F25E7ECD7C4EBAED' AND app_code = '046' ========================2018-06-12 14:52:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '109939' ========================2018-06-12 14:52:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '109939' ========================2018-06-12 14:52:13======================== UPDATE mac_detail SET pc_name = 'VISION-H61', os_type = '64', user_id = 'wss6011', user_name = '청주신선낚시[위상선]', screen_w = '1024', screen_h = '768', cdkey = '518069715941' WHERE mac_idx = '109939' ========================2018-06-12 14:52:27======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732BEC6CEE2B1141 sCDKey = 740776951094 sName = DESKTOP-IR4BE71 ========================2018-06-12 14:52:27======================== 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 = '740776951094' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-12 14:57:57======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732BEC6CEE2B1141 sCDKey = 740776951094 sName = DESKTOP-IR4BE71 ========================2018-06-12 14:57: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 = '740776951094' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-12 14:57:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tech3656' ========================2018-06-12 14:57:57======================== SELECT idx FROM macs WHERE mac_addr = '50AF732BEC6CEE2B1141' AND app_code = '047' ========================2018-06-12 14:57:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251852' ========================2018-06-12 14:57:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251852' ========================2018-06-12 14:57: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 ( '251852', '50AF732BEC6CEE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'tech3656', '(주)테크앤툴[노만호]', '740776951094' ) ========================2018-06-12 15:14:03======================== noteurl_start parm_app_code = 045 parm_pc_name = MAIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA146638019ED6ACEC sCDKey = 362378873579 sName = MAIN-PC ========================2018-06-12 15:14:03======================== 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 = '362378873579' AND r.app_code = '045' AND r.app_block = 0 ========================2018-06-12 15:14:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'haegang' ========================2018-06-12 15:14:03======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146638019ED6ACEC' AND app_code = '045' ========================2018-06-12 15:14:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251853' ========================2018-06-12 15:14:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251853' ========================2018-06-12 15:14:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251853', 'FCAA146638019ED6ACEC', '045', 'MAIN-PC', '90', '1920', '1080', 'haegang', '(주)해강상사[정진영]', '362378873579' ) ========================2018-06-12 15:24:41======================== noteurl_start parm_app_code = 046 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = C83DD476E6E9EA42EA86 sCDKey = 518069715941 sName = USER ========================2018-06-12 15:24: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 = '518069715941' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-12 15:24:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wss6011' ========================2018-06-12 15:24:41======================== SELECT idx FROM macs WHERE mac_addr = 'C83DD476E6E9EA42EA86' AND app_code = '046' ========================2018-06-12 15:24:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251847' ========================2018-06-12 15:24:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251847' ========================2018-06-12 15:24: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 ( '251847', 'C83DD476E6E9EA42EA86', '046', 'USER', '110', '1366', '768', 'wss6011', '청주신선낚시[위상선]', '518069715941' )