========================2018-07-24 11:27:29======================== noteurl_start parm_app_code = 047 parm_pc_name = STEELSERVER parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 107B4494491AE8859902 sCDKey = 852593588317 sName = STEELSERVER ========================2018-07-24 11:27: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 = '852593588317' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-24 11:27:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hksteel6351' ========================2018-07-24 11:27:29======================== SELECT idx FROM macs WHERE mac_addr = '107B4494491AE8859902' AND app_code = '047' ========================2018-07-24 11:27:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255443' ========================2018-07-24 11:27:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255443' ========================2018-07-24 11:27:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '255443', '107B4494491AE8859902', '047', 'STEELSERVER', '�쐢�룄�슦 7', '0', '0', 'hksteel6351', '(주)한국종합철강[박영옥]', '852593588317' ) ========================2018-07-24 13:34:45======================== noteurl_start parm_app_code = 050 parm_pc_name = 김동순 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6EF31490CAFC83 sCDKey = 204467956951 sName = 김동순 ========================2018-07-24 13:34:45======================== 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 = '204467956951' AND r.app_code = '050' AND r.app_block = 0 ========================2018-07-24 13:34:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdsoon0402' ========================2018-07-24 13:34:45======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6EF31490CAFC83' AND app_code = '050' ========================2018-07-24 13:34:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253452' ========================2018-07-24 13:34:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253452' ========================2018-07-24 13:34:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253452', 'E8039A6EF31490CAFC83', '050', '김동순', '90', '1920', '1080', 'kdsoon0402', '대전평생교육진흥원[대전평생교육진흥원]', '204467956951' ) ========================2018-07-24 13:35:19======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00245477C9963E9C38DC sCDKey = 174615471489 sName = 가정호 ========================2018-07-24 13:35: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 = '174615471489' AND r.app_code = '046' AND r.app_block = 0 ========================2018-07-24 13:35:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kangjh331' ========================2018-07-24 13:35:19======================== SELECT idx FROM macs WHERE mac_addr = '00245477C9963E9C38DC' AND app_code = '046' ========================2018-07-24 13:35:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255229' ========================2018-07-24 13:35:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255229' ========================2018-07-24 13:35: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 ( '255229', '00245477C9963E9C38DC', '046', '가정호', '90', '1024', '768', 'kangjh331', '알파와오메가[가정호]', '174615471489' ) ========================2018-07-24 13:59:42======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-2U8TSHH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55EB32489D0448870 sCDKey = 435511149259 sName = DESKTOP-2U8TSHH ========================2018-07-24 13:59: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 = '435511149259' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-24 13:59:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'didtkrl' ========================2018-07-24 13:59:42======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EB32489D0448870' AND app_code = '047' ========================2018-07-24 13:59:42======================== 값이 없을 경우 ========================2018-07-24 14:00:05======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-2U8TSHH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55EB32489D0448870 sCDKey = 435511149259 sName = DESKTOP-2U8TSHH ========================2018-07-24 14:00: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 = '435511149259' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-24 14:00:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'didtkrl' ========================2018-07-24 14:00:05======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EB32489D0448870' AND app_code = '047' ========================2018-07-24 14:00:05======================== 값이 없을 경우 ========================2018-07-24 15:33:06======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-2U8TSHH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55EB32489D0448870 sCDKey = 435511149259 sName = DESKTOP-2U8TSHH ========================2018-07-24 15:33: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 = '435511149259' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-24 15:33:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'didtkrl' ========================2018-07-24 15:33:06======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EB32489D0448870' AND app_code = '047' ========================2018-07-24 15:33:06======================== 값이 없을 경우 ========================2018-07-24 19:49:05======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-2U8TSHH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55EB32489D0448870 sCDKey = 435511149259 sName = DESKTOP-2U8TSHH ========================2018-07-24 19:49: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 = '435511149259' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-24 19:49:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'didtkrl' ========================2018-07-24 19:49:05======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EB32489D0448870' AND app_code = '047' ========================2018-07-24 19:49:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '255502' ========================2018-07-24 19:49:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '255502' ========================2018-07-24 19:49: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 ( '255502', 'E0D55EB32489D0448870', '047', 'DESKTOP-2U8TSHH', '�쐢�룄�슦 10', '0', '0', 'didtkrl', '기룡스포츠[양기룡]', '435511149259' )