========================2018-08-27 07:47:50======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BJQM0FU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EB90BF9147F94B8 sCDKey = 618650604114 sName = USER-PC ========================2018-08-27 07:47: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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-27 09:04:17======================== noteurl_start parm_app_code = 039 parm_pc_name = 디자인 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C26E940DACABE537 sCDKey = 894494273207 sName = 디자인 ========================2018-08-27 09:04: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 = '894494273207' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 09:04:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cha0101' ========================2018-08-27 09:04:17======================== SELECT idx FROM macs WHERE mac_addr = '7085C26E940DACABE537' AND app_code = '039' ========================2018-08-27 09:04:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256944' ========================2018-08-27 09:04:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256944' ========================2018-08-27 09:04:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256944', '7085C26E940DACABE537', '039', '디자인', '110', '1920', '1080', 'cha0101', '하나로시스템[송기창]', '894494273207' ) ========================2018-08-27 09:29:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FH12K3N parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = F44D30AE86A6EADBBC96 sCDKey = 472107753222 sName = DESKTOP-FH12K3N ========================2018-08-27 09:29: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 = '472107753222' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 09:29:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kse184866' ========================2018-08-27 09:29:18======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30AE86A6EADBBC96' AND app_code = '039' ========================2018-08-27 09:29:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258131' ========================2018-08-27 09:29:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258131' ========================2018-08-27 09:29: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 ( '258131', 'F44D30AE86A6EADBBC96', '039', 'DESKTOP-FH12K3N', '110', '1440', '900', 'kse184866', '메디칼라인[김상언]', '472107753222' ) ========================2018-08-27 09:34:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FH12K3N parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = F44D30AE86A67227E96B sCDKey = 472107753222 sName = DESKTOP-FH12K3N ========================2018-08-27 09:34: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 = '472107753222' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 09:34:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kse184866' ========================2018-08-27 09:34:49======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30AE86A67227E96B' AND app_code = '039' ========================2018-08-27 09:34:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258221' ========================2018-08-27 09:34:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258221' ========================2018-08-27 09:34: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 ( '258221', 'F44D30AE86A67227E96B', '039', 'DESKTOP-FH12K3N', '110', '1440', '900', 'kse184866', '메디칼라인[김상언]', '472107753222' ) ========================2018-08-27 10:29:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2P9JVI3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFBBE1B8E446A2B89 sCDKey = 284545283206 sName = DESKTOP-2P9JVI3 ========================2018-08-27 10:29: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 = '284545283206' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 10:29:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kiki0784' ========================2018-08-27 10:29:46======================== SELECT idx FROM macs WHERE mac_addr = '4CEDFBBE1B8E446A2B89' AND app_code = '039' ========================2018-08-27 10:29:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258224' ========================2018-08-27 10:29:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258224' ========================2018-08-27 10:29: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 ( '258224', '4CEDFBBE1B8E446A2B89', '039', 'DESKTOP-2P9JVI3', '110', '1920', '1080', 'kiki0784', '(주)원산업개발[오종민]', '284545283206' ) ========================2018-08-27 13:08:13======================== noteurl_start parm_app_code = 045 parm_pc_name = PARKCHULMIN parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 28D244A0AD27E04EC014 sCDKey = 094475644696 sName = PARKCHULMIN ========================2018-08-27 13:08: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 = '094475644696' AND r.app_code = '045' AND r.app_block = 0 ========================2018-08-27 13:08:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'saehansystem' ========================2018-08-27 13:08:13======================== SELECT idx FROM macs WHERE mac_addr = '28D244A0AD27E04EC014' AND app_code = '045' ========================2018-08-27 13:08:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258263' ========================2018-08-27 13:08:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258263' ========================2018-08-27 13:08: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 ( '258263', '28D244A0AD27E04EC014', '045', 'PARKCHULMIN', '110', '1280', '720', 'saehansystem', '새한시스템[김대중]', '094475644696' ) ========================2018-08-27 13:20:08======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-DO33FCJE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 302432D263C930B0B0F3 sCDKey = 964204957977 sName = LAPTOP-DO33FCJE ========================2018-08-27 13:20: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 = '964204957977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 13:20:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'smilesunae' ========================2018-08-27 13:20:08======================== SELECT idx FROM macs WHERE mac_addr = '302432D263C930B0B0F3' AND app_code = '039' ========================2018-08-27 13:20:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257664' ========================2018-08-27 13:20:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257664' ========================2018-08-27 13:20:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '257664', '302432D263C930B0B0F3', '039', 'LAPTOP-DO33FCJE', '110', '1920', '1080', 'smilesunae', '루나[이선애]', '964204957977' ) ========================2018-08-27 14:09:45======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BJQM0FU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EB90BF9147F94B8 sCDKey = 618650604114 sName = daelim01 ========================2018-08-27 14:09: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 = '618650604114' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-27 14:51:46======================== noteurl_start parm_app_code = 046 parm_pc_name = STJ-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067BAEBDFD0BA7F9F sCDKey = 298504286643 sName = STJ-PC ========================2018-08-27 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 = '298504286643' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-27 14:51:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdod123' ========================2018-08-27 14:51:46======================== SELECT idx FROM macs WHERE mac_addr = '003067BAEBDFD0BA7F9F' AND app_code = '046' ========================2018-08-27 14:51:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258275' ========================2018-08-27 14:51:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258275' ========================2018-08-27 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 ( '258275', '003067BAEBDFD0BA7F9F', '046', 'STJ-PC', '110', '1920', '1080', 'kdod123', '엠제이소프트[송태진]', '298504286643' ) ========================2018-08-27 15:39:02======================== noteurl_start parm_app_code = 039 parm_pc_name = PC-MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838982C321DAB017AA sCDKey = 853846793831 sName = PC-MAIN ========================2018-08-27 15:39: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 15:39:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-08-27 15:39:02======================== SELECT idx FROM macs WHERE mac_addr = '98838982C321DAB017AA' AND app_code = '039' ========================2018-08-27 15:39:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238790' ========================2018-08-27 15:39:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238790' ========================2018-08-27 15:39:02======================== UPDATE mac_detail SET pc_name = 'PC-MAIN', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '238790' ========================2018-08-27 15:43:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-E3K4IT7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AAFA68A6221A6C sCDKey = 853846793831 sName = DESKTOP-E3K4IT7 ========================2018-08-27 15:43: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 15:43:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-08-27 15:43:07======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AAFA68A6221A6C' AND app_code = '039' ========================2018-08-27 15:43:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258285' ========================2018-08-27 15:43:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258285' ========================2018-08-27 15:43: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 ( '258285', '50B7C3AAFA68A6221A6C', '039', 'DESKTOP-E3K4IT7', '110', '1920', '1080', 'ijs7740', '(주)고려양행[김기범]', '853846793831' ) ========================2018-08-27 15:50:20======================== noteurl_start parm_app_code = 039 parm_pc_name = PC04-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599F50F84EE1999FD sCDKey = 853846793831 sName = PC04-PC ========================2018-08-27 15:50:20======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 15:50:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-08-27 15:50:20======================== SELECT idx FROM macs WHERE mac_addr = '64E599F50F84EE1999FD' AND app_code = '039' ========================2018-08-27 15:50:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '182605' ========================2018-08-27 15:50:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '182605' ========================2018-08-27 15:50:20======================== UPDATE mac_detail SET pc_name = 'PC04-PC', os_type = '90', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '182605' ========================2018-08-27 15:50:28======================== noteurl_start parm_app_code = 039 parm_pc_name = PC04-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599F50F84EE1999FD sCDKey = 853846793831 sName = PC04-PC ========================2018-08-27 15:50:28======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 15:50:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-08-27 15:50:28======================== SELECT idx FROM macs WHERE mac_addr = '64E599F50F84EE1999FD' AND app_code = '039' ========================2018-08-27 15:50:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '182605' ========================2018-08-27 15:50:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '182605' ========================2018-08-27 15:50:28======================== UPDATE mac_detail SET pc_name = 'PC04-PC', os_type = '90', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '182605' ========================2018-08-27 15:51:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8TI1HQQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18CF5E2E273654FCC8F4 sCDKey = 853846793831 sName = DESKTOP-8TI1HQQ ========================2018-08-27 15:51: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 15:51:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-08-27 15:51:15======================== SELECT idx FROM macs WHERE mac_addr = '18CF5E2E273654FCC8F4' AND app_code = '039' ========================2018-08-27 15:51:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251588' ========================2018-08-27 15:51:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251588' ========================2018-08-27 15:51:15======================== UPDATE mac_detail SET pc_name = 'DESKTOP-8TI1HQQ', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '251588' ========================2018-08-27 15:58:33======================== noteurl_start parm_app_code = 039 parm_pc_name = ACE-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6C626DB120CBEE1999FD sCDKey = 853846793831 sName = ACE-PC ========================2018-08-27 15:58: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 15:58:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-08-27 15:58:33======================== SELECT idx FROM macs WHERE mac_addr = '6C626DB120CBEE1999FD' AND app_code = '039' ========================2018-08-27 15:58:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '182355' ========================2018-08-27 15:58:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '182355' ========================2018-08-27 15:58:33======================== UPDATE mac_detail SET pc_name = 'ACE-PC', os_type = '90', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '182355' ========================2018-08-27 15:58:46======================== noteurl_start parm_app_code = 039 parm_pc_name = ACE-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6C626DB120CBEE1999FD sCDKey = 853846793831 sName = ACE-PC ========================2018-08-27 15:58: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-27 16:13:39======================== noteurl_start parm_app_code = 046 parm_pc_name = X-NOTE-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E0B9A58D8657B69661D2 sCDKey = 753237620546 sName = X-NOTE-PC ========================2018-08-27 16:13:39======================== 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 = '753237620546' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-27 18:25:57======================== noteurl_start parm_app_code = 047 parm_pc_name = MSDN-SPECIAL parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 003018AC51259CE85318 sCDKey = 231474130547 sName = MSDN-SPECIAL ========================2018-08-27 18:25: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 = '231474130547' AND r.app_code = '047' AND r.app_block = 0 ========================2018-08-27 18:25:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'piaros' ========================2018-08-27 18:25:57======================== SELECT idx FROM macs WHERE mac_addr = '003018AC51259CE85318' AND app_code = '047' ========================2018-08-27 18:25:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258317' ========================2018-08-27 18:25:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258317' ========================2018-08-27 18:25: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 ( '258317', '003018AC51259CE85318', '047', 'MSDN-SPECIAL', '�쐢�룄�슦 7', '0', '0', 'piaros', 'DS유통[전성수]', '231474130547' )