========================2018-03-16 10:48:19======================== noteurl_start parm_app_code = 039 parm_pc_name = ABB1-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 002314A059A010ED30FC sCDKey = 340762225041 sName = ABB1-PC ========================2018-03-16 10:48: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 = '340762225041' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-16 10:48:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lappingg04' ========================2018-03-16 10:48:19======================== SELECT idx FROM macs WHERE mac_addr = '002314A059A010ED30FC' AND app_code = '039' ========================2018-03-16 10:48:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244655' ========================2018-03-16 10:48:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244655' ========================2018-03-16 10:48: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 ( '244655', '002314A059A010ED30FC', '039', 'ABB1-PC', '90', '1920', '1200', 'lappingg04', 'AB & B[이종원]', '340762225041' ) ========================2018-03-16 10:58:30======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 10:58:30======================== 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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 10:59:14======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 10:59: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 10:59:41======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 10:59:41======================== 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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 11:19:51======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 11:19:51======================== 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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 11:20:28======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 11:20:28======================== 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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 11:21:45======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 11:21: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 11:28:12======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 6C29951F33BC868B039C sCDKey = 075441473699 sName = ========================2018-03-16 11:28: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 = '075441473699' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-16 11:28:36======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 6C29951F33BC868B039C sCDKey = 075441473699 sName = sanho ========================2018-03-16 11:28:36======================== 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 = '075441473699' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-16 11:28:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bsk7279' ========================2018-03-16 11:28:36======================== SELECT idx FROM macs WHERE mac_addr = '6C29951F33BC868B039C' AND app_code = '046' ========================2018-03-16 11:28:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244664' ========================2018-03-16 11:28:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244664' ========================2018-03-16 11:28:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244664', '6C29951F33BC868B039C', '046', 'sanho', '110', '1536', '864', 'bsk7279', '지니퍼피[백승기]', '075441473699' ) ========================2018-03-16 11:29:06======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 11:29: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 11:29:17======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 11:29:17======================== 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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 13:07:53======================== noteurl_start parm_app_code = 039 parm_pc_name = SK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F406690D5D3BC7935D9 sCDKey = 941510009506 sName = SK ========================2018-03-16 13:07: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 = '941510009506' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-16 13:07:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ca5223' ========================2018-03-16 13:07:53======================== SELECT idx FROM macs WHERE mac_addr = 'F406690D5D3BC7935D9' AND app_code = '039' ========================2018-03-16 13:07:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244676' ========================2018-03-16 13:07:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244676' ========================2018-03-16 13:07:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244676', 'F406690D5D3BC7935D9', '039', 'SK', '110', '1920', '1080', 'ca5223', '청암창호[권창환]', '941510009506' ) ========================2018-03-16 13:09:33======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 13:09: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 13:15:37======================== noteurl_start parm_app_code = 050 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 13:15: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 = '887148749309' AND r.app_code = '050' AND r.app_block = 0 ========================2018-03-16 13:15:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kingohkee' ========================2018-03-16 13:15:37======================== SELECT idx FROM macs WHERE mac_addr = '847BEB1796BD4233DF15' AND app_code = '050' ========================2018-03-16 13:15:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '190028' ========================2018-03-16 13:15:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '190028' ========================2018-03-16 13:15:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '190028', '847BEB1796BD4233DF15', '050', 'SEO-N16-006', '90', '1920', '1200', 'kingohkee', 'LMS[조병옥]', '887148749309' ) ========================2018-03-16 13:15:48======================== noteurl_start parm_app_code = 050 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-16 13:15:48======================== 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 = '887148749309' AND r.app_code = '050' AND r.app_block = 0 ========================2018-03-16 13:58:09======================== noteurl_start parm_app_code = 051 parm_pc_name = KCG-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D304C7862A6138453 sCDKey = 292180582916 sName = KCG-PC ========================2018-03-16 13:58: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 = '292180582916' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 13:58:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gyu1001' ========================2018-03-16 13:58:09======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304C7862A6138453' AND app_code = '051' ========================2018-03-16 13:58:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '212971' ========================2018-03-16 13:58:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '212971' ========================2018-03-16 13:58: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 ( '212971', 'F44D304C7862A6138453', '051', 'KCG-PC', '109', '1920', '1080', 'gyu1001', '창규자동차[권창규]', '292180582916' ) ========================2018-03-16 14:09:01======================== noteurl_start parm_app_code = 050 parm_pc_name = SEO-W12-001 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4AE52C00D6B55458620 sCDKey = 887148749309 sName = SEO-W12-001 ========================2018-03-16 14:09: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 = '887148749309' AND r.app_code = '050' AND r.app_block = 0 ========================2018-03-16 14:21:15======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-W12-001 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4AE52C00D6B55458620 sCDKey = 473735708251 sName = SEO-W12-001 ========================2018-03-16 14:21: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 = '473735708251' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 14:21:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kingohkee' ========================2018-03-16 14:21:15======================== SELECT idx FROM macs WHERE mac_addr = 'D4AE52C00D6B55458620' AND app_code = '051' ========================2018-03-16 14:21:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244679' ========================2018-03-16 14:21:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244679' ========================2018-03-16 14:21: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 ( '244679', 'D4AE52C00D6B55458620', '051', 'SEO-W12-001', '90', '1920', '1080', 'kingohkee', 'LMS[조병옥]', '473735708251' ) ========================2018-03-16 14:30:27======================== noteurl_start parm_app_code = 039 parm_pc_name = LABNPART parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 0023AE84A93D5CD5524D sCDKey = 432114869519 sName = LABNPART ========================2018-03-16 14:30: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 = '432114869519' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-16 14:30:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'labnpart' ========================2018-03-16 14:30:27======================== SELECT idx FROM macs WHERE mac_addr = '0023AE84A93D5CD5524D' AND app_code = '039' ========================2018-03-16 14:30:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '156391' ========================2018-03-16 14:30:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '156391' ========================2018-03-16 14:30:27======================== UPDATE mac_detail SET pc_name = 'LABNPART', os_type = '90', user_id = 'labnpart', user_name = '랩앤파트코리아[최영일]', screen_w = '1280', screen_h = '1024', cdkey = '432114869519' WHERE mac_idx = '156391' ========================2018-03-16 15:08:33======================== noteurl_start parm_app_code = 039 parm_pc_name = FOX-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002185CD278CBAD3C2FF sCDKey = 664959019230 sName = FOX-PC ========================2018-03-16 15:08: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 = '664959019230' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-16 15:08:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'winds9291' ========================2018-03-16 15:08:33======================== SELECT idx FROM macs WHERE mac_addr = '002185CD278CBAD3C2FF' AND app_code = '039' ========================2018-03-16 15:08:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244695' ========================2018-03-16 15:08:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244695' ========================2018-03-16 15:08: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 ( '244695', '002185CD278CBAD3C2FF', '039', 'FOX-PC', '90', '1920', '1080', 'winds9291', '신흥산업사[김정원]', '664959019230' ) ========================2018-03-16 15:48:31======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838910757792D5622E sCDKey = 505783813356 sName = SAMSUNG ========================2018-03-16 15:48: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 = '505783813356' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-16 15:48:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dbsdudcns2' ========================2018-03-16 15:48:31======================== SELECT idx FROM macs WHERE mac_addr = '98838910757792D5622E' AND app_code = '039' ========================2018-03-16 15:48:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244702' ========================2018-03-16 15:48:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244702' ========================2018-03-16 15:48: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 ( '244702', '98838910757792D5622E', '039', 'SAMSUNG', '110', '1920', '1080', 'dbsdudcns2', '빙그레모악대리점[윤영춘]', '505783813356' ) ========================2018-03-16 15:49:35======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 473735708251 sName = SEO-N16-006 ========================2018-03-16 15:49: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 = '473735708251' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-16 15:49:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kingohkee' ========================2018-03-16 15:49:35======================== SELECT idx FROM macs WHERE mac_addr = '847BEB1796BD4233DF15' AND app_code = '051' ========================2018-03-16 15:49:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '190027' ========================2018-03-16 15:49:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '190027' ========================2018-03-16 15:49:35======================== UPDATE mac_detail SET pc_name = 'SEO-N16-006', os_type = '90', user_id = 'kingohkee', user_name = 'LMS[조병옥]', screen_w = '1920', screen_h = '1200', cdkey = '473735708251' WHERE mac_idx = '190027' ========================2018-03-16 17:14:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-PT65L04 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 8C89A5DC37D8D4F04E2E sCDKey = 867810080946 sName = DESKTOP-PT65L04 ========================2018-03-16 17:14: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 = '867810080946' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-16 17:14:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dm2663' ========================2018-03-16 17:14:07======================== SELECT idx FROM macs WHERE mac_addr = '8C89A5DC37D8D4F04E2E' AND app_code = '039' ========================2018-03-16 17:14:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '209527' ========================2018-03-16 17:14:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '209527' ========================2018-03-16 17:14:07======================== UPDATE mac_detail SET pc_name = 'DESKTOP-PT65L04', os_type = '110', user_id = 'dm2663', user_name = '동문자동화[류규식]', screen_w = '1680', screen_h = '1050', cdkey = '867810080946' WHERE mac_idx = '209527'