========================2018-06-08 09:08:05======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 00FFC8DDB92870900801 sCDKey = 167774888715 sName = SAMSUNG ========================2018-06-08 09:08:05======================== 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 = '167774888715' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-08 09:08:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dntkdwlr' ========================2018-06-08 09:08:05======================== SELECT idx FROM macs WHERE mac_addr = '00FFC8DDB92870900801' AND app_code = '039' ========================2018-06-08 09:08:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251563' ========================2018-06-08 09:08:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251563' ========================2018-06-08 09:08:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251563', '00FFC8DDB92870900801', '039', 'SAMSUNG', '110', '1536', '864', 'dntkdwlr', '승리유통[우상직]', '167774888715' ) ========================2018-06-08 09:53:05======================== noteurl_start parm_app_code = 047 parm_pc_name = LAPTOP-ORKK9A2P parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9822EFF6A8656AD38281 sCDKey = 721803825991 sName = LAPTOP-ORKK9A2P ========================2018-06-08 09:53:05======================== 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 = '721803825991' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-08 09:53:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dongaflower' ========================2018-06-08 09:53:05======================== SELECT idx FROM macs WHERE mac_addr = '9822EFF6A8656AD38281' AND app_code = '047' ========================2018-06-08 09:53:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251570' ========================2018-06-08 09:53:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251570' ========================2018-06-08 09:53:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251570', '9822EFF6A8656AD38281', '047', 'LAPTOP-ORKK9A2P', '�쐢�룄�슦 10', '0', '0', 'dongaflower', '동아플라워자재[김무선]', '721803825991' ) ========================2018-06-08 13:08:04======================== 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-06-08 13:08: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-08 13:08:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-06-08 13:08:04======================== SELECT idx FROM macs WHERE mac_addr = '18CF5E2E273654FCC8F4' AND app_code = '039' ========================2018-06-08 13:08:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251588' ========================2018-06-08 13:08:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251588' ========================2018-06-08 13:08:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251588', '18CF5E2E273654FCC8F4', '039', 'DESKTOP-8TI1HQQ', '110', '1920', '1080', 'ijs7740', '(주)고려양행[김기범]', '853846793831' ) ========================2018-06-08 13:46:21======================== noteurl_start parm_app_code = 039 parm_pc_name = HHP280G3MT01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C8D3FFB96ECDF80C97AD sCDKey = 302923846099 sName = HHP280G3MT01 ========================2018-06-08 13:46:21======================== 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 = '302923846099' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-08 13:46:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pryong21' ========================2018-06-08 13:46:21======================== SELECT idx FROM macs WHERE mac_addr = 'C8D3FFB96ECDF80C97AD' AND app_code = '039' ========================2018-06-08 13:46:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251597' ========================2018-06-08 13:46:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251597' ========================2018-06-08 13:46:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251597', 'C8D3FFB96ECDF80C97AD', '039', 'HHP280G3MT01', '110', '1920', '1080', 'pryong21', '선메디칼[선미숙]', '302923846099' ) ========================2018-06-08 14:54:42======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-F3632OP parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 305A3A0831388CC3C71A sCDKey = 740776951094 sName = DESKTOP-F3632OP ========================2018-06-08 14:54:42======================== 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-08 14:54:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tech3656' ========================2018-06-08 14:54:42======================== SELECT idx FROM macs WHERE mac_addr = '305A3A0831388CC3C71A' AND app_code = '047' ========================2018-06-08 14:54:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251582' ========================2018-06-08 14:54:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251582' ========================2018-06-08 14:54:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251582', '305A3A0831388CC3C71A', '047', 'DESKTOP-F3632OP', '�쐢�룄�슦 10', '0', '0', 'tech3656', '(주)테크앤툴[노만호]', '740776951094' ) ========================2018-06-08 16:36:24======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC1-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1831BF4F7AE4FCC4D116 sCDKey = 951887133959 sName = POS-PC1-PC ========================2018-06-08 16:36:24======================== 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 = '951887133959' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-08 16:36:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodnom35' ========================2018-06-08 16:36:24======================== SELECT idx FROM macs WHERE mac_addr = '1831BF4F7AE4FCC4D116' AND app_code = '046' ========================2018-06-08 16:36:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251621' ========================2018-06-08 16:36:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251621' ========================2018-06-08 16:36:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251621', '1831BF4F7AE4FCC4D116', '046', 'POS-PC1-PC', '90', '1920', '1080', 'goodnom35', '일등식품[소인환]', '951887133959' )