========================2018-08-09 10:04:09======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-SMJG59FC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 646E69B13A298043E48A sCDKey = 983166690172 sName = LAPTOP-SMJG59FC ========================2018-08-09 10:04:09======================== 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 = '983166690172' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-09 10:04:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bkzzz77' ========================2018-08-09 10:04:09======================== SELECT idx FROM macs WHERE mac_addr = '646E69B13A298043E48A' AND app_code = '039' ========================2018-08-09 10:04:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238018' ========================2018-08-09 10:04:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238018' ========================2018-08-09 10:04:09======================== UPDATE mac_detail SET pc_name = 'LAPTOP-SMJG59FC', os_type = '110', user_id = 'bkzzz77', user_name = '어린이백화점[윤병근]', screen_w = '1536', screen_h = '864', cdkey = '983166690172' WHERE mac_idx = '238018' ========================2018-08-09 10:09:21======================== noteurl_start parm_app_code = 046 parm_pc_name = JJ parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = C48508D28BE2F2722C0E sCDKey = 749315301697 sName = JJ ========================2018-08-09 10:09: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 = '749315301697' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-09 10:09:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramses1414' ========================2018-08-09 10:09:21======================== SELECT idx FROM macs WHERE mac_addr = 'C48508D28BE2F2722C0E' AND app_code = '046' ========================2018-08-09 10:09:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198985' ========================2018-08-09 10:09:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198985' ========================2018-08-09 10:09:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '198985', 'C48508D28BE2F2722C0E', '046', 'JJ', '110', '1680', '1050', 'ramses1414', '영진상사[권동현]', '749315301697' ) ========================2018-08-09 10:09:25======================== noteurl_start parm_app_code = 046 parm_pc_name = JJ parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = C48508D28BE2F2722C0E sCDKey = 749315301697 sName = JJ ========================2018-08-09 10:09:25======================== 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 = '749315301697' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-09 10:11:33======================== noteurl_start parm_app_code = 046 parm_pc_name = JJ parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = C48508D28BE2F2722C0E sCDKey = 749315301697 sName = admin ========================2018-08-09 10:11:33======================== 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 = '749315301697' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-09 10:11:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramses1414' ========================2018-08-09 10:11:33======================== SELECT idx FROM macs WHERE mac_addr = 'C48508D28BE2F2722C0E' AND app_code = '046' ========================2018-08-09 10:11:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198985' ========================2018-08-09 10:11:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198985' ========================2018-08-09 10:11:33======================== UPDATE mac_detail SET pc_name = 'admin', os_type = '110', user_id = 'ramses1414', user_name = '영진상사[권동현]', screen_w = '1680', screen_h = '1050', cdkey = '749315301697' WHERE mac_idx = '198985' ========================2018-08-09 10:50:47======================== noteurl_start parm_app_code = 048 parm_pc_name = KHH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 905663571513 sName = KHH-PC ========================2018-08-09 10:50:47======================== 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 = '905663571513' AND r.app_code = '048' AND r.app_block = 0 ========================2018-08-09 10:50:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'donkey0318' ========================2018-08-09 10:50:47======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE5C6AB0D604' AND app_code = '048' ========================2018-08-09 10:50:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256832' ========================2018-08-09 10:50:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256832' ========================2018-08-09 10:50:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256832', 'F44D30B9AE5C6AB0D604', '048', 'KHH-PC', '�쐢�룄�슦 10', '0', '0', 'donkey0318', '엠제이소프트[김현호]', '905663571513' ) ========================2018-08-09 10:54:57======================== noteurl_start parm_app_code = 048 parm_pc_name = KHH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 905663571513 sName = KHH-PC ========================2018-08-09 10:54:57======================== 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 = '905663571513' AND r.app_code = '048' AND r.app_block = 0 ========================2018-08-09 14:53:01======================== noteurl_start parm_app_code = 047 parm_pc_name = WN22363 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A0C589998ED2DABE589E sCDKey = 231851322592 sName = WN22363 ========================2018-08-09 14:53:01======================== 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 = '231851322592' AND r.app_code = '047' AND r.app_block = 0 ========================2018-08-09 14:53:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hak79' ========================2018-08-09 14:53:01======================== SELECT idx FROM macs WHERE mac_addr = 'A0C589998ED2DABE589E' AND app_code = '047' ========================2018-08-09 14:53:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256859' ========================2018-08-09 14:53:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256859' ========================2018-08-09 14:53:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256859', 'A0C589998ED2DABE589E', '047', 'WN22363', '�쐢�룄�슦 7', '0', '0', 'hak79', '[이봉학1]', '231851322592' ) ========================2018-08-09 15:04:53======================== noteurl_start parm_app_code = 039 parm_pc_name = BB012014070826 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = C4D987F75C38AE7553C2 sCDKey = 338315316844 sName = BB012014070826 ========================2018-08-09 15:04:53======================== 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 = '338315316844' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-09 15:04:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ispa1020' ========================2018-08-09 15:04:53======================== SELECT idx FROM macs WHERE mac_addr = 'C4D987F75C38AE7553C2' AND app_code = '039' ========================2018-08-09 15:04:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223750' ========================2018-08-09 15:04:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223750' ========================2018-08-09 15:04:53======================== UPDATE mac_detail SET pc_name = 'BB012014070826', os_type = '90', user_id = 'ispa1020', user_name = '스테셔너리코리아[최종진]', screen_w = '1366', screen_h = '768', cdkey = '338315316844' WHERE mac_idx = '223750' ========================2018-08-09 15:40:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IP5LDK5 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691632C65741C02A8 sCDKey = 212639585467 sName = DESKTOP-IP5LDK5 ========================2018-08-09 15:40:33======================== 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 = '212639585467' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-09 15:40:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ms3760' ========================2018-08-09 15:40:33======================== SELECT idx FROM macs WHERE mac_addr = '94C691632C65741C02A8' AND app_code = '039' ========================2018-08-09 15:40:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256870' ========================2018-08-09 15:40:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256870' ========================2018-08-09 15:40:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256870', '94C691632C65741C02A8', '039', 'DESKTOP-IP5LDK5', '110', '1920', '1080', 'ms3760', '엠에스센타[황강준]', '212639585467' ) ========================2018-08-09 16:13:37======================== noteurl_start parm_app_code = 039 parm_pc_name = PG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509929A0AF361D75B2 sCDKey = 552792642040 sName = PG ========================2018-08-09 16:13:37======================== 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 = '552792642040' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-09 16:13:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbk2457' ========================2018-08-09 16:13:37======================== SELECT idx FROM macs WHERE mac_addr = 'D0509929A0AF361D75B2' AND app_code = '039' ========================2018-08-09 16:13:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223587' ========================2018-08-09 16:13:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223587' ========================2018-08-09 16:13:37======================== UPDATE mac_detail SET pc_name = 'PG', os_type = '110', user_id = 'jbk2457', user_name = '동광산업[전봉기]', screen_w = '1920', screen_h = '1080', cdkey = '552792642040' WHERE mac_idx = '223587' ========================2018-08-09 16:14:29======================== noteurl_start parm_app_code = 039 parm_pc_name = HP-OWNER parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2C4138A82D56229F2F2 sCDKey = 552792642040 sName = HP-OWNER ========================2018-08-09 16:14: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 = '552792642040' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-09 16:14:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbk2457' ========================2018-08-09 16:14:29======================== SELECT idx FROM macs WHERE mac_addr = '2C4138A82D56229F2F2' AND app_code = '039' ========================2018-08-09 16:14:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256879' ========================2018-08-09 16:14:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256879' ========================2018-08-09 16:14: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 ( '256879', '2C4138A82D56229F2F2', '039', 'HP-OWNER', '90', '1920', '1080', 'jbk2457', '동광산업[전봉기]', '552792642040' ) ========================2018-08-09 16:21:14======================== noteurl_start parm_app_code = 039 parm_pc_name = MI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = D0509929A09E68B22397 sCDKey = 552792642040 sName = MI ========================2018-08-09 16:21:14======================== 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 = '552792642040' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-09 16:21:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbk2457' ========================2018-08-09 16:21:14======================== SELECT idx FROM macs WHERE mac_addr = 'D0509929A09E68B22397' AND app_code = '039' ========================2018-08-09 16:21:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256882' ========================2018-08-09 16:21:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256882' ========================2018-08-09 16:21:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256882', 'D0509929A09E68B22397', '039', 'MI', '110', '1920', '1200', 'jbk2457', '동광산업[전봉기]', '552792642040' ) ========================2018-08-09 16:23:26======================== noteurl_start parm_app_code = 039 parm_pc_name = HP-OWNER parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2C4138A82D56229F2F2 sCDKey = 552792642040 sName = HP-OWNER ========================2018-08-09 16:23:26======================== 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 = '552792642040' AND r.app_code = '039' AND r.app_block = 0 ========================2018-08-09 16:23:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbk2457' ========================2018-08-09 16:23:26======================== SELECT idx FROM macs WHERE mac_addr = '2C4138A82D56229F2F2' AND app_code = '039' ========================2018-08-09 16:23:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256879' ========================2018-08-09 16:23:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256879' ========================2018-08-09 16:23:26======================== UPDATE mac_detail SET pc_name = 'HP-OWNER', os_type = '90', user_id = 'jbk2457', user_name = '동광산업[전봉기]', screen_w = '1920', screen_h = '1080', cdkey = '552792642040' WHERE mac_idx = '256879' ========================2018-08-09 17:07:02======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732B26A8EE2B1141 sCDKey = 301492624355 sName = 오치동 호야애견 ========================2018-08-09 17:07:02======================== 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 = '301492624355' AND r.app_code = '046' AND r.app_block = 0 ========================2018-08-09 17:07:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'zx0361' ========================2018-08-09 17:07:02======================== SELECT idx FROM macs WHERE mac_addr = '50AF732B26A8EE2B1141' AND app_code = '046' ========================2018-08-09 17:07:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256888' ========================2018-08-09 17:07:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256888' ========================2018-08-09 17:07:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '256888', '50AF732B26A8EE2B1141', '046', '오치동 호야애견', '110', '1024', '768', 'zx0361', 'LBcompany[백수연]', '301492624355' )