========================2021-11-25 10:29:31======================== noteurl_start parm_app_code = 047 parm_pc_name = JA5 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 60A44CB506592A786276 sCDKey = 258870946981 sName = JA5 ========================2021-11-25 10:29:31======================== 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 = '258870946981' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-25 10:31:59======================== noteurl_start parm_app_code = 047 parm_pc_name = JA5 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 60A44CB506592A786276 sCDKey = 258870946981 sName = JA5 ========================2021-11-25 10:31: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 = '258870946981' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-25 10:31:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jangangun' ========================2021-11-25 10:31:59======================== SELECT idx FROM macs WHERE mac_addr = '60A44CB506592A786276' AND app_code = '047' ========================2021-11-25 10:31:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355171' ========================2021-11-25 10:31:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355171' ========================2021-11-25 10:31: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 ( '355171', '60A44CB506592A786276', '047', 'JA5', '�쐢�룄�슦 10', '0', '0', 'jangangun', '장안건[임종희]', '258870946981' ) ========================2021-11-25 13:54:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LEB6HD0 parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 00089FFFCD82D4521F6F sCDKey = 080554338112 sName = DESKTOP-LEB6HD0 ========================2021-11-25 13:54:03======================== 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 = '080554338112' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-25 13:54:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'schsin1' ========================2021-11-25 13:54:03======================== SELECT idx FROM macs WHERE mac_addr = '00089FFFCD82D4521F6F' AND app_code = '039' ========================2021-11-25 13:54:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355190' ========================2021-11-25 13:54:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355190' ========================2021-11-25 13:54:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355190', '00089FFFCD82D4521F6F', '039', 'DESKTOP-LEB6HD0', '110', '1360', '768', 'schsin1', '상명금속[신승철]', '080554338112' ) ========================2021-11-25 13:57:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-ED6AN0M parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = EA2ADCAF40895E9A63A5 sCDKey = 760167774807 sName = DESKTOP-ED6AN0M ========================2021-11-25 13:57:24======================== 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 = '760167774807' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-25 13:57:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lhj878800' ========================2021-11-25 13:57:24======================== SELECT idx FROM macs WHERE mac_addr = 'EA2ADCAF40895E9A63A5' AND app_code = '039' ========================2021-11-25 13:57:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355192' ========================2021-11-25 13:57:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355192' ========================2021-11-25 13:57:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355192', 'EA2ADCAF40895E9A63A5', '039', 'DESKTOP-ED6AN0M', '110', '1536', '864', 'lhj878800', '올큐어[이현정]', '760167774807' ) ========================2021-11-25 14:11:34======================== noteurl_start parm_app_code = 039 parm_pc_name = 신우04 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 04D4C48DE1E2763521F2 sCDKey = 870286827806 sName = 신우04 ========================2021-11-25 14:11:34======================== 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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-25 14:11:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2021-11-25 14:11:34======================== SELECT idx FROM macs WHERE mac_addr = '04D4C48DE1E2763521F2' AND app_code = '039' ========================2021-11-25 14:11:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291136' ========================2021-11-25 14:11:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291136' ========================2021-11-25 14:11:34======================== UPDATE mac_detail SET pc_name = '신우04', os_type = '110', user_id = 'sinwoo6', user_name = '신우포장[이경재]', screen_w = '1920', screen_h = '1080', cdkey = '870286827806' WHERE mac_idx = '291136' ========================2021-11-25 14:11:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6CD5RBL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897C7B30A4005B49 sCDKey = 870286827806 sName = DESKTOP-6CD5RBL ========================2021-11-25 14:11:40======================== 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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-25 14:11:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2021-11-25 14:11:40======================== SELECT idx FROM macs WHERE mac_addr = '9883897C7B30A4005B49' AND app_code = '039' ========================2021-11-25 14:11:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '302815' ========================2021-11-25 14:11:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '302815' ========================2021-11-25 14:11:40======================== UPDATE mac_detail SET pc_name = 'DESKTOP-6CD5RBL', os_type = '110', user_id = 'sinwoo6', user_name = '신우포장[이경재]', screen_w = '1920', screen_h = '1080', cdkey = '870286827806' WHERE mac_idx = '302815' ========================2021-11-25 14:12:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-R7LN3GI parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = D8BBC10EAA91CCF5AB39 sCDKey = 870286827806 sName = DESKTOP-R7LN3GI ========================2021-11-25 14:12:24======================== 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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-25 14:12:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2021-11-25 14:12:24======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC10EAA91CCF5AB39' AND app_code = '039' ========================2021-11-25 14:12:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347167' ========================2021-11-25 14:12:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '347167' ========================2021-11-25 14:12:24======================== UPDATE mac_detail SET pc_name = 'DESKTOP-R7LN3GI', os_type = '110', user_id = 'sinwoo6', user_name = '신우포장[이경재]', screen_w = '2560', screen_h = '1440', cdkey = '870286827806' WHERE mac_idx = '347167' ========================2021-11-25 14:12:50======================== noteurl_start parm_app_code = 039 parm_pc_name = USER5 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 04D9F55E91609880F1DE sCDKey = 870286827806 sName = USER5 ========================2021-11-25 14:12: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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-25 14:12:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2021-11-25 14:12:50======================== SELECT idx FROM macs WHERE mac_addr = '04D9F55E91609880F1DE' AND app_code = '039' ========================2021-11-25 14:12:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '301608' ========================2021-11-25 14:12:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '301608' ========================2021-11-25 14:12:50======================== UPDATE mac_detail SET pc_name = 'USER5', os_type = '110', user_id = 'sinwoo6', user_name = '신우포장[이경재]', screen_w = '1920', screen_h = '1080', cdkey = '870286827806' WHERE mac_idx = '301608' ========================2021-11-25 15:42:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UK3585T parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 84A9386A7CEC5A59D93D sCDKey = 422114683375 sName = DESKTOP-UK3585T ========================2021-11-25 15:42: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 = '422114683375' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-25 15:42:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'id4love' ========================2021-11-25 15:42:47======================== SELECT idx FROM macs WHERE mac_addr = '84A9386A7CEC5A59D93D' AND app_code = '039' ========================2021-11-25 15:42:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355201' ========================2021-11-25 15:42:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355201' ========================2021-11-25 15:42: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 ( '355201', '84A9386A7CEC5A59D93D', '039', 'DESKTOP-UK3585T', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375' ) ========================2021-11-25 17:36:27======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-UT1HIPM parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C025A58D8E02E450C011 sCDKey = 238452659169 sName = DESKTOP-UT1HIPM ========================2021-11-25 17:36:27======================== 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 = '238452659169' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-25 17:36:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hankook0954' ========================2021-11-25 17:36:27======================== SELECT idx FROM macs WHERE mac_addr = 'C025A58D8E02E450C011' AND app_code = '047' ========================2021-11-25 17:36:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355210' ========================2021-11-25 17:36:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355210' ========================2021-11-25 17:36:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355210', 'C025A58D8E02E450C011', '047', 'DESKTOP-UT1HIPM', '�쐢�룄�슦 10', '0', '0', 'hankook0954', '한국종합기계[윤종복]', '238452659169' ) ========================2021-11-25 17:40:47======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4Q0S2EN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C025A58D8D5AE6491102 sCDKey = 238452659169 sName = DESKTOP-4Q0S2EN ========================2021-11-25 17:40: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 = '238452659169' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-25 17:40:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hankook0954' ========================2021-11-25 17:40:47======================== SELECT idx FROM macs WHERE mac_addr = 'C025A58D8D5AE6491102' AND app_code = '047' ========================2021-11-25 17:40:47======================== 값이 없을 경우 ========================2021-11-25 17:42:02======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4Q0S2EN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C025A58D8D5AE6491102 sCDKey = 238452659169 sName = DESKTOP-4Q0S2EN ========================2021-11-25 17:42: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 = '238452659169' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-25 17:42:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hankook0954' ========================2021-11-25 17:42:02======================== SELECT idx FROM macs WHERE mac_addr = 'C025A58D8D5AE6491102' AND app_code = '047' ========================2021-11-25 17:42:02======================== 값이 없을 경우 ========================2021-11-25 17:42:39======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4Q0S2EN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C025A58D8D5AE6491102 sCDKey = 238452659169 sName = DESKTOP-4Q0S2EN ========================2021-11-25 17:42:39======================== 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 = '238452659169' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-25 17:42:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hankook0954' ========================2021-11-25 17:42:39======================== SELECT idx FROM macs WHERE mac_addr = 'C025A58D8D5AE6491102' AND app_code = '047' ========================2021-11-25 17:42:39======================== 값이 없을 경우 ========================2021-11-25 17:49:34======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4Q0S2EN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C025A58D8D5AE6491102 sCDKey = 238452659169 sName = DESKTOP-4Q0S2EN ========================2021-11-25 17:49:34======================== 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 = '238452659169' AND r.app_code = '047' AND r.app_block = 0 ========================2021-11-25 17:49:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hankook0954' ========================2021-11-25 17:49:34======================== SELECT idx FROM macs WHERE mac_addr = 'C025A58D8D5AE6491102' AND app_code = '047' ========================2021-11-25 17:49:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '355215' ========================2021-11-25 17:49:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '355215' ========================2021-11-25 17:49:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '355215', 'C025A58D8D5AE6491102', '047', 'DESKTOP-4Q0S2EN', '�쐢�룄�슦 10', '0', '0', 'hankook0954', '한국종합기계[윤종복]', '238452659169' ) ========================2021-11-25 17:49:39======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-4Q0S2EN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C025A58D8D5AE6491102 sCDKey = 238452659169 sName = DESKTOP-4Q0S2EN ========================2021-11-25 17:49:39======================== 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 = '238452659169' AND r.app_code = '047' AND r.app_block = 0