========================2021-12-10 10:32:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-25GAPH7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E1A8403721A7949 sCDKey = 329357009795 sName = DESKTOP-25GAPH7 ========================2021-12-10 10:32: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 = '329357009795' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-10 10:32:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjlaser' ========================2021-12-10 10:32:20======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E1A8403721A7949' AND app_code = '039' ========================2021-12-10 10:32:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356239' ========================2021-12-10 10:32:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356239' ========================2021-12-10 10:32:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '356239', 'E0D55E1A8403721A7949', '039', 'DESKTOP-25GAPH7', '110', '1920', '1080', 'cjlaser', '창조레이저[김찬호]', '329357009795' ) ========================2021-12-10 11:24:12======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7ATUVDS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 10F0056B8627EC27A63B sCDKey = 588524411493 sName = 노트북 ========================2021-12-10 11:24: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 = '588524411493' AND r.app_code = '047' AND r.app_block = 0 ========================2021-12-10 11:24:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onemart2019' ========================2021-12-10 11:24:12======================== SELECT idx FROM macs WHERE mac_addr = '10F0056B8627EC27A63B' AND app_code = '047' ========================2021-12-10 11:24:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355498' ========================2021-12-10 11:24:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355498' ========================2021-12-10 11:24:12======================== UPDATE mac_detail SET pc_name = '노트북', os_type = '�쐢�룄�슦 10', user_id = 'onemart2019', user_name = 'ONEmart[송웅]', screen_w = '0', screen_h = '0', cdkey = '588524411493' WHERE mac_idx = '355498' ========================2021-12-10 11:34:54======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-7ATUVDS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 10F0056B8627EC27A63B sCDKey = 588524411493 sName = 노트북 ========================2021-12-10 11:34:54======================== 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 = '588524411493' AND r.app_code = '047' AND r.app_block = 0 ========================2021-12-10 11:34:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onemart2019' ========================2021-12-10 11:34:55======================== SELECT idx FROM macs WHERE mac_addr = '10F0056B8627EC27A63B' AND app_code = '047' ========================2021-12-10 11:34:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355498' ========================2021-12-10 11:34:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355498' ========================2021-12-10 11:34:55======================== UPDATE mac_detail SET pc_name = '노트북', os_type = '�쐢�룄�슦 10', user_id = 'onemart2019', user_name = 'ONEmart[송웅]', screen_w = '0', screen_h = '0', cdkey = '588524411493' WHERE mac_idx = '355498' ========================2021-12-10 15:43:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2RJQG97 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E9273003CAA989A sCDKey = 024273106239 sName = DESKTOP-2RJQG97 ========================2021-12-10 15:43: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 = '024273106239' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-10 15:43:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'is10000' ========================2021-12-10 15:43:19======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E9273003CAA989A' AND app_code = '039' ========================2021-12-10 15:43:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356268' ========================2021-12-10 15:43:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356268' ========================2021-12-10 15:43: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 ( '356268', 'E0D55E9273003CAA989A', '039', 'DESKTOP-2RJQG97', '110', '1920', '1080', 'is10000', '충주시농협쌀조합공동사업법인[이상현]', '024273106239' ) ========================2021-12-10 17:12:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-LPHB2QH parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00E04C4C21907AE53821 sCDKey = 749421869585 sName = DESKTOP-LPHB2QH ========================2021-12-10 17:12:56======================== 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 = '749421869585' AND r.app_code = '046' AND r.app_block = 0 ========================2021-12-10 17:12:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jg0000' ========================2021-12-10 17:12:56======================== SELECT idx FROM macs WHERE mac_addr = '00E04C4C21907AE53821' AND app_code = '046' ========================2021-12-10 17:12:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356275' ========================2021-12-10 17:12:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356275' ========================2021-12-10 17:12:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '356275', '00E04C4C21907AE53821', '046', 'DESKTOP-LPHB2QH', '110', '1280', '1024', 'jg0000', '중앙식자재마트[김기양]', '749421869585' ) ========================2021-12-10 18:44:21======================== noteurl_start parm_app_code = 048 parm_pc_name = 주차장 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8CB0E914BA0E02F63433 sCDKey = 434133617514 sName = 주차장 ========================2021-12-10 18:44: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2021-12-10 18:44:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2021-12-10 18:44:22======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E914BA0E02F63433' AND app_code = '048' ========================2021-12-10 18:44:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322140' ========================2021-12-10 18:44:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322140' ========================2021-12-10 18:44:22======================== UPDATE mac_detail SET pc_name = '주차장', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '322140'