========================2020-06-23 08:31:54======================== noteurl_start parm_app_code = 048 parm_pc_name = 얼마예요 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18C04D22F1ADD18FA2D0 sCDKey = 780547338320 sName = 얼마예요 ========================2020-06-23 08:31: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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-23 08:31:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-06-23 08:31:55======================== SELECT idx FROM macs WHERE mac_addr = '18C04D22F1ADD18FA2D0' AND app_code = '048' ========================2020-06-23 08:31:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319230' ========================2020-06-23 08:31:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319230' ========================2020-06-23 08:31:55======================== UPDATE mac_detail SET pc_name = '얼마예요', os_type = '�쐢�룄�슦 10', user_id = 'aone0022', user_name = '(주)에이원메디칼[강창중]', screen_w = '0', screen_h = '0', cdkey = '780547338320' WHERE mac_idx = '319230' ========================2020-06-23 12:04:29======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4A022OP parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BC5FF4D85D0766C68538 sCDKey = 677531853851 sName = DESKTOP-4A022OP ========================2020-06-23 12:04:29======================== 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 = '677531853851' AND r.app_code = '047' AND r.app_block = 0 ========================2020-06-23 12:04:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yjpark9730' ========================2020-06-23 12:04:30======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4D85D0766C68538' AND app_code = '047' ========================2020-06-23 12:04:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320273' ========================2020-06-23 12:04:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320273' ========================2020-06-23 12:04:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320273', 'BC5FF4D85D0766C68538', '047', 'DESKTOP-4A022OP', '�쐢�룄�슦 10', '0', '0', 'yjpark9730', '태성엘이디[박윤정]', '677531853851' ) ========================2020-06-23 13:18:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-J8EPB4Q parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00CFE056734E887C8EA2 sCDKey = 205797578278 sName = DESKTOP-J8EPB4Q ========================2020-06-23 13:18: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 = '205797578278' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-23 13:18:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dbswhdt2' ========================2020-06-23 13:18:50======================== SELECT idx FROM macs WHERE mac_addr = '00CFE056734E887C8EA2' AND app_code = '039' ========================2020-06-23 13:18:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320274' ========================2020-06-23 13:18:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320274' ========================2020-06-23 13:18:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320274', '00CFE056734E887C8EA2', '039', 'DESKTOP-J8EPB4Q', '110', '1920', '1080', 'dbswhdt2', '제일전기조명[윤종식]', '205797578278' ) ========================2020-06-23 15:30:42======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-GNK4L61 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C22B4B2F66CB07C0 sCDKey = 902396377681 sName = DESKTOP-GNK4L61 ========================2020-06-23 15:30: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 = '902396377681' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-23 15:30:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qnc05014' ========================2020-06-23 15:30:42======================== SELECT idx FROM macs WHERE mac_addr = '7085C22B4B2F66CB07C0' AND app_code = '048' ========================2020-06-23 15:30:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320312' ========================2020-06-23 15:30:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320312' ========================2020-06-23 15:30: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 ( '320312', '7085C22B4B2F66CB07C0', '048', 'DESKTOP-GNK4L61', '�쐢�룄�슦 10', '0', '0', 'qnc05014', '(주)큐엔씨B2B점[유임묵]', '902396377681' ) ========================2020-06-23 17:43:06======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2020-06-23 17:43: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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-23 17:43:49======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2020-06-23 17:43: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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-23 17:44:12======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2020-06-23 17:44: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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-23 17:44:17======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2020-06-23 17:44: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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-23 17:44:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hando77' ========================2020-06-23 17:44:17======================== SELECT idx FROM macs WHERE mac_addr = '98838981F74D76D7F1ED' AND app_code = '039' ========================2020-06-23 17:44:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235354' ========================2020-06-23 17:44:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235354' ========================2020-06-23 17:44:17======================== UPDATE mac_detail SET pc_name = 'HANDO', os_type = '110', user_id = 'hando77', user_name = '한도교역[한도교역]', screen_w = '1920', screen_h = '1080', cdkey = '173379187341' WHERE mac_idx = '235354'