========================2020-05-14 09:46:04======================== noteurl_start parm_app_code = 048 parm_pc_name = MAIN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 8C89A58C5BFDF67B9A06 sCDKey = 060358662126 sName = MAIN ========================2020-05-14 09:46: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 = '060358662126' AND r.app_code = '048' AND r.app_block = 0 ========================2020-05-14 09:46:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gndj' ========================2020-05-14 09:46:04======================== SELECT idx FROM macs WHERE mac_addr = '8C89A58C5BFDF67B9A06' AND app_code = '048' ========================2020-05-14 09:46:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317386' ========================2020-05-14 09:46:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317386' ========================2020-05-14 09:46: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 ( '317386', '8C89A58C5BFDF67B9A06', '048', 'MAIN', '�쐢�룄�슦 10', '0', '0', 'gndj', '지앤디협동조합[이철우]', '060358662126' ) ========================2020-05-14 12:07:46======================== noteurl_start parm_app_code = 048 parm_pc_name = 서울상담 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838937EE071523563F sCDKey = 748055397824 sName = 서울상담 ========================2020-05-14 12:07:46======================== 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 = '748055397824' AND r.app_code = '048' AND r.app_block = 0 ========================2020-05-14 12:07:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mailo7' ========================2020-05-14 12:07:46======================== SELECT idx FROM macs WHERE mac_addr = '98838937EE071523563F' AND app_code = '048' ========================2020-05-14 12:07:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317399' ========================2020-05-14 12:07:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317399' ========================2020-05-14 12:07:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '317399', '98838937EE071523563F', '048', '서울상담', '�쐢�룄�슦 10', '0', '0', 'mailo7', '송영훈[송영훈]', '748055397824' ) ========================2020-05-14 12:19:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-KPIDLH4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99F62B4A48539487 sCDKey = 382657324492 sName = 삼성전지조명 ========================2020-05-14 12:19: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 = '382657324492' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-14 12:20:06======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-KPIDLH4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99F62B4A48539487 sCDKey = 382657324492 sName = 노현숙 ========================2020-05-14 12:20: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 = '382657324492' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-14 12:20:58======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-KPIDLH4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99F62B4A48539487 sCDKey = 382657324492 sName = ADMIN ========================2020-05-14 12:20:58======================== 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 = '382657324492' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-14 14:35:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0KJP1D4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00D86155575088DD22B2 sCDKey = 982834938334 sName = DESKTOP-0KJP1D4 ========================2020-05-14 14:35: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 = '982834938334' AND r.app_code = '039' AND r.app_block = 0 ========================2020-05-14 14:35:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jurapower11' ========================2020-05-14 14:35:06======================== SELECT idx FROM macs WHERE mac_addr = '00D86155575088DD22B2' AND app_code = '039' ========================2020-05-14 14:35:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285750' ========================2020-05-14 14:35:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285750' ========================2020-05-14 14:35:06======================== UPDATE mac_detail SET pc_name = 'DESKTOP-0KJP1D4', os_type = '110', user_id = 'jurapower11', user_name = '멋지다오피스텔[장승목]', screen_w = '1920', screen_h = '1080', cdkey = '982834938334' WHERE mac_idx = '285750'