========================2018-10-18 09:53:28======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-20150330ZP parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA1467F6F9C2CAC037 sCDKey = 752997096570 sName = WIN7-20150330ZP ========================2018-10-18 09:53: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 = '752997096570' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-18 09:53:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kpmaterials' ========================2018-10-18 09:53:28======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA1467F6F9C2CAC037' AND app_code = '039' ========================2018-10-18 09:53:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259968' ========================2018-10-18 09:53:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '259968' ========================2018-10-18 09:53:28======================== UPDATE mac_detail SET pc_name = 'WIN7-20150330ZP', os_type = '90', user_id = 'kpmaterials', user_name = '케이피매터리얼즈[박규]', screen_w = '1920', screen_h = '1080', cdkey = '752997096570' WHERE mac_idx = '259968' ========================2018-10-18 10:14:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PUVV8MJ parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A402B99DC98EC016F7D3 sCDKey = 921252470167 sName = DESKTOP-PUVV8MJ ========================2018-10-18 10:14: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 = '921252470167' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-18 10:14:51======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-PUVV8MJ parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A402B99DC98EC016F7D3 sCDKey = 921252470168 sName = DESKTOP-PUVV8MJ ========================2018-10-18 10:14: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 = '921252470168' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-18 10:14:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2018-10-18 10:14:51======================== SELECT idx FROM macs WHERE mac_addr = 'A402B99DC98EC016F7D3' AND app_code = '046' ========================2018-10-18 10:14:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250285' ========================2018-10-18 10:14:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250285' ========================2018-10-18 10:14:51======================== UPDATE mac_detail SET pc_name = 'DESKTOP-PUVV8MJ', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1536', screen_h = '864', cdkey = '921252470168' WHERE mac_idx = '250285' ========================2018-10-18 13:46:10======================== noteurl_start parm_app_code = 039 parm_pc_name = 20180618-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = D05099AA725EEE1999FD sCDKey = 505525054564 sName = 20180618-PC ========================2018-10-18 13:46:10======================== 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 = '505525054564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-18 13:46:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dud7791' ========================2018-10-18 13:46:10======================== SELECT idx FROM macs WHERE mac_addr = 'D05099AA725EEE1999FD' AND app_code = '039' ========================2018-10-18 13:46:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '263599' ========================2018-10-18 13:46:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '263599' ========================2018-10-18 13:46:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '263599', 'D05099AA725EEE1999FD', '039', '20180618-PC', '90', '1280', '1024', 'dud7791', '영창빌딩[김영식]', '505525054564' ) ========================2018-10-18 15:07:12======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-I7ARSDC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55EBF5D238E46DB35 sCDKey = 917357002172 sName = DESKTOP-I7ARSDC ========================2018-10-18 15:07: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 = '917357002172' AND r.app_code = '048' AND r.app_block = 0 ========================2018-10-18 15:07:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsafd' ========================2018-10-18 15:07:12======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EBF5D238E46DB35' AND app_code = '048' ========================2018-10-18 15:07:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '263641' ========================2018-10-18 15:07:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '263641' ========================2018-10-18 15:07:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '263641', 'E0D55EBF5D238E46DB35', '048', 'DESKTOP-I7ARSDC', '�쐢�룄�슦 10', '0', '0', 'jinsafd', '케이디네트웍스[도선애]', '917357002172' )