========================2019-07-19 09:54:52======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-MACM5LGDO3J parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E063318A0542139329 sCDKey = 375508873226 sName = WIN-MACM5LGDO3J ========================2019-07-19 09:54:52======================== 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 = '375508873226' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-19 09:54:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wdjs86101' ========================2019-07-19 09:54:52======================== SELECT idx FROM macs WHERE mac_addr = '00E063318A0542139329' AND app_code = '039' ========================2019-07-19 09:54:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291139' ========================2019-07-19 09:54:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291139' ========================2019-07-19 09:54:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291139', '00E063318A0542139329', '039', 'WIN-MACM5LGDO3J', '90', '1920', '1080', 'wdjs86101', '월드장식[탁경숙]', '375508873226' ) ========================2019-07-19 09:55:02======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-MACM5LGDO3J parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E063318A0542139329 sCDKey = 375508873226 sName = WIN-MACM5LGDO3J ========================2019-07-19 09:55: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 = '375508873226' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-19 10:31:18======================== noteurl_start parm_app_code = 051 parm_pc_name = SKIN-0502744N parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389275D903E52F7A0 sCDKey = 003401679376 sName = SKIN-0502744N ========================2019-07-19 10:31:18======================== 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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-19 10:31:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2019-07-19 10:31:18======================== SELECT idx FROM macs WHERE mac_addr = '988389275D903E52F7A0' AND app_code = '051' ========================2019-07-19 10:31:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290552' ========================2019-07-19 10:31:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290552' ========================2019-07-19 10:31:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290552', '988389275D903E52F7A0', '051', 'SKIN-0502744N', '90', '1920', '1080', 'skinfosec', '인포섹[이대윤]', '003401679376' ) ========================2019-07-19 11:14:18======================== noteurl_start parm_app_code = 046 parm_pc_name = VB parm_os_type = 64 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D16817280D8FDA sCDKey = 473748127893 sName = VB ========================2019-07-19 11:14:18======================== 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 = '473748127893' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-19 11:14:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2019-07-19 11:14:18======================== SELECT idx FROM macs WHERE mac_addr = '080027D16817280D8FDA' AND app_code = '046' ========================2019-07-19 11:14:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '196416' ========================2019-07-19 11:14:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '196416' ========================2019-07-19 11:14:18======================== UPDATE mac_detail SET pc_name = 'VB', os_type = '64', user_id = 'aej123456', user_name = '엠제이소프트[안은준]', screen_w = '1920', screen_h = '976', cdkey = '473748127893' WHERE mac_idx = '196416' ========================2019-07-19 11:19:46======================== 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 ========================2019-07-19 11:19: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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-19 11:23:31======================== 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 ========================2019-07-19 11:23: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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-19 11:23:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2019-07-19 11:23:31======================== SELECT idx FROM macs WHERE mac_addr = '04D4C48DE1E2763521F2' AND app_code = '039' ========================2019-07-19 11:23:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291136' ========================2019-07-19 11:23:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291136' ========================2019-07-19 11:23:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291136', '04D4C48DE1E2763521F2', '039', '신우04', '110', '1920', '1080', 'sinwoo6', '신우포장[이경재]', '870286827806' ) ========================2019-07-19 11:33:49======================== noteurl_start parm_app_code = 050 parm_pc_name = JBKIM parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EDAF44C4AE70EA5 sCDKey = 678905519571 sName = 솔바텍 ========================2019-07-19 11:33:49======================== 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 = '678905519571' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-19 11:33:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'solbar' ========================2019-07-19 11:33:49======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EDAF44C4AE70EA5' AND app_code = '050' ========================2019-07-19 11:33:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291154' ========================2019-07-19 11:33:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291154' ========================2019-07-19 11:33:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291154', 'E0D55EDAF44C4AE70EA5', '050', '솔바텍', '109', '1920', '1080', 'solbar', '(주)솔바텍[오영근]', '678905519571' ) ========================2019-07-19 11:42:35======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389DD50FDEA42F54E sCDKey = 058323762427 sName = DESKTOP ========================2019-07-19 11:42: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 = '058323762427' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-19 11:42:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'multicampus' ========================2019-07-19 11:42:35======================== SELECT idx FROM macs WHERE mac_addr = '988389DD50FDEA42F54E' AND app_code = '051' ========================2019-07-19 11:42:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291146' ========================2019-07-19 11:42:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291146' ========================2019-07-19 11:42:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291146', '988389DD50FDEA42F54E', '051', 'DESKTOP', '109', '1920', '1080', 'multicampus', '멀티캠퍼스 역삼[권영석]', '058323762427' ) ========================2019-07-19 11:43:58======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389DD461DEA42F54E sCDKey = 058323762427 sName = DESKTOP ========================2019-07-19 11:43: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 = '058323762427' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-19 11:43:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'multicampus' ========================2019-07-19 11:43:58======================== SELECT idx FROM macs WHERE mac_addr = '988389DD461DEA42F54E' AND app_code = '051' ========================2019-07-19 11:43:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291148' ========================2019-07-19 11:43:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291148' ========================2019-07-19 11:43:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291148', '988389DD461DEA42F54E', '051', 'DESKTOP', '109', '1920', '1080', 'multicampus', '멀티캠퍼스 역삼[권영석]', '058323762427' ) ========================2019-07-19 11:59:12======================== noteurl_start parm_app_code = 039 parm_pc_name = 신우03-LJS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3CA067248E5D42F56612 sCDKey = 870286827806 sName = 신우03 ========================2019-07-19 11:59:12======================== 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 ========================2019-07-19 11:59:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2019-07-19 11:59:12======================== SELECT idx FROM macs WHERE mac_addr = '3CA067248E5D42F56612' AND app_code = '039' ========================2019-07-19 11:59:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '213003' ========================2019-07-19 11:59:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '213003' ========================2019-07-19 11:59:12======================== UPDATE mac_detail SET pc_name = '신우03', os_type = '110', user_id = 'sinwoo6', user_name = '신우포장[이경재]', screen_w = '1920', screen_h = '1080', cdkey = '870286827806' WHERE mac_idx = '213003' ========================2019-07-19 11:59:26======================== noteurl_start parm_app_code = 039 parm_pc_name = 신우03-LJS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3CA067248E5D42F56612 sCDKey = 870286827806 sName = 신우03 ========================2019-07-19 11:59: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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-19 14:23:57======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-MACM5LGDO3J parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00090FAA000142139329 sCDKey = 375508873226 sName = WIN-MACM5LGDO3J ========================2019-07-19 14:23: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 = '375508873226' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-19 14:23:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wdjs86101' ========================2019-07-19 14:23:57======================== SELECT idx FROM macs WHERE mac_addr = '00090FAA000142139329' AND app_code = '039' ========================2019-07-19 14:23:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '275637' ========================2019-07-19 14:23:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '275637' ========================2019-07-19 14:23:57======================== UPDATE mac_detail SET pc_name = 'WIN-MACM5LGDO3J', os_type = '90', user_id = 'wdjs86101', user_name = '월드장식[탁경숙]', screen_w = '1920', screen_h = '1080', cdkey = '375508873226' WHERE mac_idx = '275637' ========================2019-07-19 15:43:19======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TAJOA52 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 78E7D1D6FD75C890956E sCDKey = 129422369000 sName = DESKTOP-TAJOA52 ========================2019-07-19 15:43: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 = '129422369000' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-19 17:50:15======================== noteurl_start parm_app_code = 051 parm_pc_name = HEA002174 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC8385F36B2DBC805A62 sCDKey = 937740825227 sName = HEA002174 ========================2019-07-19 17:50:15======================== 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 = '937740825227' AND r.app_code = '051' AND r.app_block = 0 ========================2019-07-19 17:50:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'irisinfotech' ========================2019-07-19 17:50:15======================== SELECT idx FROM macs WHERE mac_addr = 'BC8385F36B2DBC805A62' AND app_code = '051' ========================2019-07-19 17:50:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290576' ========================2019-07-19 17:50:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290576' ========================2019-07-19 17:50:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290576', 'BC8385F36B2DBC805A62', '051', 'HEA002174', '109', '1920', '1080', 'irisinfotech', 'IRIS INFOTECH[조광희]', '937740825227' ) ========================2019-07-19 18:28:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NTKVTT0 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 32AABABACFD6AE39B9D4 sCDKey = 151317336230 sName = DESKTOP-NTKVTT0 ========================2019-07-19 18:28: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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-19 20:25:58======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CT1TR7O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1C1B0D8952D03621E802 sCDKey = 967548682712 sName = DESKTOP-CT1TR7O ========================2019-07-19 20:25: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 = '967548682712' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-19 20:26:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-CT1TR7O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1C1B0D8952D03621E802 sCDKey = 967548682712 sName = 불모임 ========================2019-07-19 20:26: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 = '967548682712' AND r.app_code = '047' AND r.app_block = 0