========================2020-03-11 10:11:59======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DC8LDOE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E999B73EFD6802379 sCDKey = 830153203604 sName = DESKTOP-DC8LDOE ========================2020-03-11 10:11:59======================== 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 = '830153203604' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-11 10:11:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoosin4445' ========================2020-03-11 10:11:59======================== SELECT idx FROM macs WHERE mac_addr = 'B42E999B73EFD6802379' AND app_code = '039' ========================2020-03-11 10:11:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312728' ========================2020-03-11 10:11:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312728' ========================2020-03-11 10:11:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '312728', 'B42E999B73EFD6802379', '039', 'DESKTOP-DC8LDOE', '110', '1920', '1080', 'yoosin4445', '유신메라민(주)[이동팔]', '830153203604' ) ========================2020-03-11 10:57:45======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-H4NSKKE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE9456D8015759D sCDKey = 291546858846 sName = DESKTOP-H4NSKKE ========================2020-03-11 10:57: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 = '291546858846' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-11 10:57:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'leesuk5424' ========================2020-03-11 10:57:45======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE9456D8015759D' AND app_code = '046' ========================2020-03-11 10:57:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312738' ========================2020-03-11 10:57:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312738' ========================2020-03-11 10:57: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 ( '312738', '24F5AAE9456D8015759D', '046', 'DESKTOP-H4NSKKE', '110', '1920', '1080', 'leesuk5424', '자연햇살주식회사[이홍숙]', '291546858846' ) ========================2020-03-11 11:05:07======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-KKUVOAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C27F932D8ECB6151 sCDKey = 939657146002 sName = DESKTOP-KKUVOAL ========================2020-03-11 11:05:07======================== 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 = '939657146002' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-11 14:00:09======================== noteurl_start parm_app_code = 048 parm_pc_name = SJMRO-01 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA1405C0DA0EC0B764 sCDKey = 774081000216 sName = SJMRO-01 ========================2020-03-11 14:00: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 = '774081000216' AND r.app_code = '048' AND r.app_block = 0 ========================2020-03-11 14:00:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjmro' ========================2020-03-11 14:00:09======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA1405C0DA0EC0B764' AND app_code = '048' ========================2020-03-11 14:00:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312761' ========================2020-03-11 14:00:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312761' ========================2020-03-11 14:00:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '312761', 'FCAA1405C0DA0EC0B764', '048', 'SJMRO-01', '�쐢�룄�슦 7', '0', '0', 'sjmro', '서준산업안전[윤현희]', '774081000216' ) ========================2020-03-11 15:30:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FJCD1DG parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = BC5FF4DA9EA26AE39184 sCDKey = 210742859361 sName = DESKTOP-FJCD1DG ========================2020-03-11 15:30: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-11 15:30:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'julee37' ========================2020-03-11 15:30:05======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DA9EA26AE39184' AND app_code = '039' ========================2020-03-11 15:30:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312769' ========================2020-03-11 15:30:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312769' ========================2020-03-11 15:30: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 ( '312769', 'BC5FF4DA9EA26AE39184', '039', 'DESKTOP-FJCD1DG', '110', '1680', '1050', 'julee37', '개성자바라, 스텐나라[이순녀]', '210742859361' ) ========================2020-03-11 15:45:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9D8M5VL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99CCE438C6EE292E sCDKey = 776789364081 sName = DESKTOP-9D8M5VL ========================2020-03-11 15:45: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 = '776789364081' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-11 15:45:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'next114' ========================2020-03-11 15:45:21======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99CCE438C6EE292E' AND app_code = '039' ========================2020-03-11 15:45:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312771' ========================2020-03-11 15:45:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312771' ========================2020-03-11 15:45: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 ( '312771', 'B42E99CCE438C6EE292E', '039', 'DESKTOP-9D8M5VL', '110', '1920', '1080', 'next114', '주식회사 넥스트커뮤니케이션[김도원]', '776789364081' ) ========================2020-03-11 16:36:04======================== noteurl_start parm_app_code = 039 parm_pc_name = PC1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D05099A7BE6CB4E4C775 sCDKey = 847166415111 sName = PC1 ========================2020-03-11 16:36: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 = '847166415111' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-11 16:36:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jmko8889' ========================2020-03-11 16:36:04======================== SELECT idx FROM macs WHERE mac_addr = 'D05099A7BE6CB4E4C775' AND app_code = '039' ========================2020-03-11 16:36:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312781' ========================2020-03-11 16:36:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312781' ========================2020-03-11 16:36: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 ( '312781', 'D05099A7BE6CB4E4C775', '039', 'PC1', '110', '1920', '1080', 'jmko8889', '럭키알미늄[고종문]', '847166415111' ) ========================2020-03-11 16:57:33======================== noteurl_start parm_app_code = 050 parm_pc_name = 이봉학 parm_os_type = 109 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = F44D304EC66F2265D712 sCDKey = 474771527128 sName = 이봉학 ========================2020-03-11 16:57: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 = '474771527128' AND r.app_code = '050' AND r.app_block = 0 ========================2020-03-11 16:57:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hak79' ========================2020-03-11 16:57:33======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304EC66F2265D712' AND app_code = '050' ========================2020-03-11 16:57:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240036' ========================2020-03-11 16:57:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240036' ========================2020-03-11 16:57:33======================== UPDATE mac_detail SET pc_name = '이봉학', os_type = '109', user_id = 'hak79', user_name = '[이봉학1]', screen_w = '1600', screen_h = '900', cdkey = '474771527128' WHERE mac_idx = '240036' ========================2020-03-11 17:02:06======================== noteurl_start parm_app_code = 050 parm_pc_name = 오상목 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 406186CB48649E1B94C9 sCDKey = 721062265539 sName = 오상목 ========================2020-03-11 17:02: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 = '721062265539' AND r.app_code = '050' AND r.app_block = 0 ========================2020-03-11 17:02:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2020-03-11 17:02:06======================== SELECT idx FROM macs WHERE mac_addr = '406186CB48649E1B94C9' AND app_code = '050' ========================2020-03-11 17:02:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '222154' ========================2020-03-11 17:02:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '222154' ========================2020-03-11 17:02:06======================== UPDATE mac_detail SET pc_name = '오상목', os_type = '109', user_id = 'adam5352', user_name = '오상목[오상목]', screen_w = '1920', screen_h = '1080', cdkey = '721062265539' WHERE mac_idx = '222154' ========================2020-03-11 20:16:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FJCD1DG parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 1200 parm_user_mac = 0862669EA6316AE39184 sCDKey = 210742859361 sName = DESKTOP-FJCD1DG ========================2020-03-11 20:16: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-11 21:50:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FJCD1DG parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0862669EA6316AE39184 sCDKey = 210742859361 sName = DESKTOP-FJCD1DG ========================2020-03-11 21:50: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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-11 21:52:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FJCD1DG parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 0862669EA6316AE39184 sCDKey = 210742859361 sName = DESKTOP-FJCD1DG ========================2020-03-11 21:52:35======================== 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 = '210742859361' AND r.app_code = '039' AND r.app_block = 0