========================2018-11-14 09:41:31======================== noteurl_start parm_app_code = 045 parm_pc_name = parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 6C626D5D391AAE81FA52 sCDKey = 789238471662 sName = 한지수 ========================2018-11-14 09:41: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 = '789238471662' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-14 09:41:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjs1' ========================2018-11-14 09:41:31======================== SELECT idx FROM macs WHERE mac_addr = '6C626D5D391AAE81FA52' AND app_code = '045' ========================2018-11-14 09:41:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251279' ========================2018-11-14 09:41:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251279' ========================2018-11-14 09:41:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251279', '6C626D5D391AAE81FA52', '045', '한지수 ', '110', '1680', '1050', 'hjs1', '엠제이소프트[한지수1]', '789238471662' ) ========================2018-11-14 09:55:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-I3TNM99 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 049226D10946BEBE4FC2 sCDKey = 239811510079 sName = DESKTOP-I3TNM99 ========================2018-11-14 09:55: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 = '239811510079' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-14 09:55:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'momo1929' ========================2018-11-14 09:55:38======================== SELECT idx FROM macs WHERE mac_addr = '049226D10946BEBE4FC2' AND app_code = '039' ========================2018-11-14 09:55:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267684' ========================2018-11-14 09:55:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267684' ========================2018-11-14 09:55:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '267684', '049226D10946BEBE4FC2', '039', 'DESKTOP-I3TNM99', '110', '1920', '1080', 'momo1929', '협진렌탈[김윤모]', '239811510079' ) ========================2018-11-14 11:09:51======================== noteurl_start parm_app_code = 046 parm_pc_name = GJNAIL01-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050997F087F1072858C sCDKey = 040167889161 sName = GJNAIL01-PC ========================2018-11-14 11:09: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 = '040167889161' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-14 11:11:37======================== noteurl_start parm_app_code = 046 parm_pc_name = GJNAIL01-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050997F087F1072858C sCDKey = 040167889161 sName = GJNAIL01-PC ========================2018-11-14 11:11: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 = '040167889161' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-14 11:11:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjnailmall' ========================2018-11-14 11:11:37======================== SELECT idx FROM macs WHERE mac_addr = 'D050997F087F1072858C' AND app_code = '046' ========================2018-11-14 11:11:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '162919' ========================2018-11-14 11:11:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '162919' ========================2018-11-14 11:11:37======================== UPDATE mac_detail SET pc_name = 'GJNAIL01-PC', os_type = '110', user_id = 'gjnailmall', user_name = '네일몰광주점[서미옥]', screen_w = '1920', screen_h = '1080', cdkey = '040167889161' WHERE mac_idx = '162919' ========================2018-11-14 12:00:06======================== noteurl_start parm_app_code = 046 parm_pc_name = ASUS parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 54271E46E1EF705F4B0E sCDKey = 475467945095 sName = ASUS ========================2018-11-14 12:00: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 = '475467945095' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-14 14:09:19======================== noteurl_start parm_app_code = 047 parm_pc_name = 청라제일-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 0024548AD821F2CBAAB0 sCDKey = 356624337579 sName = 청라제일-PC ========================2018-11-14 14:09: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 = '356624337579' AND r.app_code = '047' AND r.app_block = 0 ========================2018-11-14 14:09:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bcd9999' ========================2018-11-14 14:09:19======================== SELECT idx FROM macs WHERE mac_addr = '0024548AD821F2CBAAB0' AND app_code = '047' ========================2018-11-14 14:09:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267728' ========================2018-11-14 14:09:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267728' ========================2018-11-14 14:09:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '267728', '0024548AD821F2CBAAB0', '047', '청라제일-PC', '�쐢�룄�슦 7', '0', '0', 'bcd9999', '청라제일철물건재공구[이민욱]', '356624337579' ) ========================2018-11-14 14:37:33======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D0509966928B6CBDE2E8 sCDKey = 827950362379 sName = USER-PC ========================2018-11-14 14:37: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 = '827950362379' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-14 14:37:40======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D0509966928B6CBDE2E8 sCDKey = 827950362379 sName = USER-PC ========================2018-11-14 14:37:40======================== 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 = '827950362379' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-14 14:37:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dadada83' ========================2018-11-14 14:37:40======================== SELECT idx FROM macs WHERE mac_addr = 'D0509966928B6CBDE2E8' AND app_code = '039' ========================2018-11-14 14:37:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267733' ========================2018-11-14 14:37:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267733' ========================2018-11-14 14:37:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '267733', 'D0509966928B6CBDE2E8', '039', 'USER-PC', '90', '1680', '1050', 'dadada83', '지우정밀[박근돈]', '827950362379' ) ========================2018-11-14 15:36:02======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A498015DFBC sCDKey = 851095746023 sName = SEOWL17H15185 ========================2018-11-14 15:36: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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2018-11-14 17:59:51======================== noteurl_start parm_app_code = 051 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A498015DFBC sCDKey = 851095746023 sName = SEOWL17H15185 ========================2018-11-14 17:59: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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2018-11-14 17:59:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ik549892' ========================2018-11-14 17:59:51======================== SELECT idx FROM macs WHERE mac_addr = 'D4258B944A498015DFBC' AND app_code = '051' ========================2018-11-14 17:59:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267741' ========================2018-11-14 17:59:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267741' ========================2018-11-14 17:59: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 ( '267741', 'D4258B944A498015DFBC', '051', 'SEOWL17H15185', '109', '1920', '1080', 'ik549892', '지에스케이(GSK)[김인배]', '851095746023' )