========================2018-07-26 08:56:04======================== noteurl_start parm_app_code = 046 parm_pc_name = COM parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 10BF487DE0352B66EF5 sCDKey = 827945452777 sName = COM ========================2018-07-26 08:56: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 = '827945452777' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-26 10:36:51======================== noteurl_start parm_app_code = 045 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10C37B4E09E510B22252 sCDKey = 426621923236 sName = MSDN-SPECIAL ========================2018-07-26 10:36: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 = '426621923236' AND r.app_code = '045' AND r.app_block = 0 ========================2018-07-26 10:36:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'heavenof' ========================2018-07-26 10:36:51======================== SELECT idx FROM macs WHERE mac_addr = '10C37B4E09E510B22252' AND app_code = '045' ========================2018-07-26 10:36:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255670' ========================2018-07-26 10:36:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255670' ========================2018-07-26 10:36: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 ( '255670', '10C37B4E09E510B22252', '045', 'MSDN-SPECIAL', '110', '1920', '1080', 'heavenof', '(주)서광테라[김정호]', '426621923236' ) ========================2018-07-26 11:29:33======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = BC5FF470F03E2C3899D2 sCDKey = 699676022619 sName = USER ========================2018-07-26 11:29:33======================== 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 = '699676022619' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-26 11:29:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ko613200' ========================2018-07-26 11:29:33======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF470F03E2C3899D2' AND app_code = '039' ========================2018-07-26 11:29:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247499' ========================2018-07-26 11:29:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247499' ========================2018-07-26 11:29:33======================== UPDATE mac_detail SET pc_name = 'USER', os_type = '90', user_id = 'ko613200', user_name = '대경산업[이숙자]', screen_w = '1680', screen_h = '1050', cdkey = '699676022619' WHERE mac_idx = '247499' ========================2018-07-26 13:18:30======================== noteurl_start parm_app_code = 039 parm_pc_name = AS201806-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 448A5BB899A2FB20F96 sCDKey = 302056573212 sName = AS201806-PC ========================2018-07-26 13:18: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 = '302056573212' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-26 13:18:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ko4325' ========================2018-07-26 13:18:30======================== SELECT idx FROM macs WHERE mac_addr = '448A5BB899A2FB20F96' AND app_code = '039' ========================2018-07-26 13:18:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255692' ========================2018-07-26 13:18:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255692' ========================2018-07-26 13:18: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 ( '255692', '448A5BB899A2FB20F96', '039', 'AS201806-PC', '90', '1920', '1080', 'ko4325', '비오유통[박광옥]', '302056573212' ) ========================2018-07-26 13:34:16======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = E0D55E95844218648631 sCDKey = 110810768510 sName = WIN7-PC ========================2018-07-26 13:34: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 = '110810768510' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-26 13:34:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pack121234' ========================2018-07-26 13:34:16======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E95844218648631' AND app_code = '039' ========================2018-07-26 13:34:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255694' ========================2018-07-26 13:34:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255694' ========================2018-07-26 13:34: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 ( '255694', 'E0D55E95844218648631', '039', 'WIN7-PC', '90', '1440', '900', 'pack121234', '고평주유소[박종백]', '110810768510' ) ========================2018-07-26 15:04:06======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 001BB1F3EA48D81761CD sCDKey = 210742859361 sName = MSDN-SPECIAL ========================2018-07-26 15:04: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-26 15:04:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2018-07-26 15:04:06======================== SELECT idx FROM macs WHERE mac_addr = '001BB1F3EA48D81761CD' AND app_code = '039' ========================2018-07-26 15:04:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255709' ========================2018-07-26 15:04:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255709' ========================2018-07-26 15:04: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 ( '255709', '001BB1F3EA48D81761CD', '039', 'MSDN-SPECIAL', '90', '1366', '768', 'julee37', '개성자바라, 스텐나라[이순녀]', '210742859361' ) ========================2018-07-26 16:04:30======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0NS3BK9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E8FFF5A58BB7FD6 sCDKey = 713551939638 sName = DESKTOP-0NS3BK9 ========================2018-07-26 16:04: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 = '713551939638' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-26 16:04:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jk9700' ========================2018-07-26 16:04:30======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E8FFF5A58BB7FD6' AND app_code = '039' ========================2018-07-26 16:04:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255716' ========================2018-07-26 16:04:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255716' ========================2018-07-26 16:04: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 ( '255716', 'E0D55E8FFF5A58BB7FD6', '039', 'DESKTOP-0NS3BK9', '110', '1920', '1080', 'jk9700', '명성철망[강성용]', '713551939638' ) ========================2018-07-26 16:58:12======================== noteurl_start parm_app_code = 048 parm_pc_name = IMHG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 210604963618 sName = IMHG ========================2018-07-26 16:58: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 = '210604963618' AND r.app_code = '048' AND r.app_block = 0 ========================2018-07-26 16:58:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lhg88' ========================2018-07-26 16:58:12======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '048' ========================2018-07-26 16:58:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239172' ========================2018-07-26 16:58:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239172' ========================2018-07-26 16:58:12======================== UPDATE mac_detail SET pc_name = 'IMHG', os_type = '�쐢�룄�슦 10', user_id = 'lhg88', user_name = '엠제이소프트[임현규]', screen_w = '0', screen_h = '0', cdkey = '210604963618' WHERE mac_idx = '239172' ========================2018-07-26 16:59:06======================== noteurl_start parm_app_code = 048 parm_pc_name = IMHG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 210604963618 sName = IMHG ========================2018-07-26 16:59: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 = '210604963618' AND r.app_code = '048' AND r.app_block = 0 ========================2018-07-26 16:59:43======================== noteurl_start parm_app_code = 048 parm_pc_name = IMHG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 210604963618 sName = IMHG ========================2018-07-26 16:59:43======================== 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 = '210604963618' AND r.app_code = '048' AND r.app_block = 0 ========================2018-07-26 17:18:02======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-MGKUV8J6DNP parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = C01885D23DA38C693C16 sCDKey = 638265972681 sName = WIN-MGKUV8J6DNP ========================2018-07-26 17:18: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 = '638265972681' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-26 17:18:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'funnymall' ========================2018-07-26 17:18:02======================== SELECT idx FROM macs WHERE mac_addr = 'C01885D23DA38C693C16' AND app_code = '046' ========================2018-07-26 17:18:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255727' ========================2018-07-26 17:18:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255727' ========================2018-07-26 17:18:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '255727', 'C01885D23DA38C693C16', '046', 'WIN-MGKUV8J6DNP', '90', '1366', '768', 'funnymall', '퍼니몰[이영은]', '638265972681' ) ========================2018-07-26 17:21:43======================== noteurl_start parm_app_code = 046 parm_pc_name = CENTER parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3497F69DFBB914E257DC sCDKey = 708132111489 sName = CENTER ========================2018-07-26 17:21:43======================== 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 = '708132111489' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-26 17:21:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wangyoungeun' ========================2018-07-26 17:21:43======================== SELECT idx FROM macs WHERE mac_addr = '3497F69DFBB914E257DC' AND app_code = '046' ========================2018-07-26 17:21:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255728' ========================2018-07-26 17:21:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255728' ========================2018-07-26 17:21:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '255728', '3497F69DFBB914E257DC', '046', 'CENTER', '110', '1920', '1080', 'wangyoungeun', '리드몰[이영은]', '708132111489' ) ========================2018-07-26 17:23:27======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B06EBF832844A42ABEFB sCDKey = 708132111489 sName = POS ========================2018-07-26 17:23: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 = '708132111489' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-26 17:23:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wangyoungeun' ========================2018-07-26 17:23:27======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBF832844A42ABEFB' AND app_code = '046' ========================2018-07-26 17:23:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255731' ========================2018-07-26 17:23:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255731' ========================2018-07-26 17:23:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '255731', 'B06EBF832844A42ABEFB', '046', 'POS', '110', '1600', '900', 'wangyoungeun', '리드몰[이영은]', '708132111489' )