========================2018-12-04 06:52:30======================== noteurl_start parm_app_code = 048 parm_pc_name = 강정미1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 강정미3 ========================2018-12-04 06:52: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-12-04 06:52:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-12-04 06:52:30======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEB832C5262F991' AND app_code = '048' ========================2018-12-04 06:52:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254561' ========================2018-12-04 06:52:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254561' ========================2018-12-04 06:52:30======================== UPDATE mac_detail SET pc_name = '강정미3', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '254561' ========================2018-12-04 09:20:05======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6FDE4E48128CA8 sCDKey = 204467956951 sName = ========================2018-12-04 09:20: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 = '204467956951' AND r.app_code = '050' AND r.app_block = 0 ========================2018-12-04 09:20:15======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6FDE4E48128CA8 sCDKey = 204467956951 sName = dile ========================2018-12-04 09:20: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 = '204467956951' AND r.app_code = '050' AND r.app_block = 0 ========================2018-12-04 09:20:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdsoon0402' ========================2018-12-04 09:20:15======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6FDE4E48128CA8' AND app_code = '050' ========================2018-12-04 09:20:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269816' ========================2018-12-04 09:20:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269816' ========================2018-12-04 09:20: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 ( '269816', 'E8039A6FDE4E48128CA8', '050', 'dile', '90', '1920', '1080', 'kdsoon0402', '대전평생교육진흥원[대전평생교육진흥원]', '204467956951' ) ========================2018-12-04 09:21:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GHJANA9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC810D7EE0E sCDKey = 789191115919 sName = DESKTOP-GHJANA9 ========================2018-12-04 09:21: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 = '789191115919' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 09:21:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dydtn9098' ========================2018-12-04 09:21:07======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC810D7EE0E' AND app_code = '039' ========================2018-12-04 09:21:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269757' ========================2018-12-04 09:21:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269757' ========================2018-12-04 09:21:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '269757', 'F44D30BC810D7EE0E', '039', 'DESKTOP-GHJANA9', '110', '1920', '1080', 'dydtn9098', '오케이오일[박용수]', '789191115919' ) ========================2018-12-04 09:48:46======================== noteurl_start parm_app_code = 046 parm_pc_name = LYS-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 794338922709 sName = LYS-PC ========================2018-12-04 09:48: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 = '794338922709' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-04 09:48:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-04 09:48:46======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '046' ========================2018-12-04 09:48:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269824' ========================2018-12-04 09:48:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269824' ========================2018-12-04 09:48:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '269824', '0030676B307C92E57388', '046', 'LYS-PC', '110', '1920', '1080', 'lys0121', '[이윤솔]', '794338922709' ) ========================2018-12-04 11:54:38======================== noteurl_start parm_app_code = 047 parm_pc_name = BROCCOLI_BOY-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BFB4B4E452F6A440 sCDKey = 736345277617 sName = BROCCOLI_BOY-PC ========================2018-12-04 11:54:38======================== 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 = '736345277617' AND r.app_code = '047' AND r.app_block = 0 ========================2018-12-04 11:54:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rarari29' ========================2018-12-04 11:54:38======================== SELECT idx FROM macs WHERE mac_addr = '1831BFB4B4E452F6A440' AND app_code = '047' ========================2018-12-04 11:54:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269870' ========================2018-12-04 11:54:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269870' ========================2018-12-04 11:54:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '269870', '1831BFB4B4E452F6A440', '047', 'BROCCOLI_BOY-PC', '�쐢�룄�슦 7', '0', '0', 'rarari29', '연암골재판넬[최성환]', '736345277617' ) ========================2018-12-04 13:35:46======================== noteurl_start parm_app_code = 046 parm_pc_name = MG parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 1C1B0D87C12B14A84CEC sCDKey = 518069715941 sName = MG ========================2018-12-04 13:35: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 = '518069715941' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-04 13:35:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wss6011' ========================2018-12-04 13:35:46======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D87C12B14A84CEC' AND app_code = '046' ========================2018-12-04 13:35:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269880' ========================2018-12-04 13:35:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269880' ========================2018-12-04 13:35:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '269880', '1C1B0D87C12B14A84CEC', '046', 'MG', '90', '1024', '768', 'wss6011', '청주신선낚시[위상선]', '518069715941' ) ========================2018-12-04 13:42:50======================== noteurl_start parm_app_code = 039 parm_pc_name = IRIVER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D43D7EB2F01D420A6CAE sCDKey = 057077548547 sName = IRIVER-PC ========================2018-12-04 13:42: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 = '057077548547' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 13:42:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sangsim11' ========================2018-12-04 13:42:50======================== SELECT idx FROM macs WHERE mac_addr = 'D43D7EB2F01D420A6CAE' AND app_code = '039' ========================2018-12-04 13:42:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269883' ========================2018-12-04 13:42:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269883' ========================2018-12-04 13:42:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '269883', 'D43D7EB2F01D420A6CAE', '039', 'IRIVER-PC', '90', '1920', '1080', 'sangsim11', '상신기업[서상심]', '057077548547' ) ========================2018-12-04 16:33:08======================== noteurl_start ========================2018-12-04 16:33:08======================== 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 = '' AND r.app_code = '' AND r.app_block = 0 ========================2018-12-04 17:44:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7CR0VE9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E4029B3703D9627461D4 sCDKey = 826605316014 sName = DESKTOP-7CR0VE9 ========================2018-12-04 17:44: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 = '826605316014' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 17:44:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'y1776073' ========================2018-12-04 17:44:40======================== SELECT idx FROM macs WHERE mac_addr = 'E4029B3703D9627461D4' AND app_code = '039' ========================2018-12-04 17:44:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '195365' ========================2018-12-04 17:44:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '195365' ========================2018-12-04 17:44:40======================== UPDATE mac_detail SET pc_name = 'DESKTOP-7CR0VE9', os_type = '110', user_id = 'y1776073', user_name = '광자동화[황순영]', screen_w = '1920', screen_h = '1080', cdkey = '826605316014' WHERE mac_idx = '195365' ========================2018-12-04 22:02:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2018-12-04 22:02: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 22:02:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2018-12-04 22:02: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 22:03:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = E0D55E36D988 sName = DESKTOP-IHIELAL ========================2018-12-04 22:03: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 = 'E0D55E36D988' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 22:04:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = E0D55E36D988 sName = DESKTOP-IHIELAL ========================2018-12-04 22:04: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 = 'E0D55E36D988' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 22:07:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = E0D55E36D988 sName = DESKTOP-IHIELAL ========================2018-12-04 22:07: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 = 'E0D55E36D988' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 22:12:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = E0D55E36D988 sName = DESKTOP-IHIELAL ========================2018-12-04 22:12:13======================== 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 = 'E0D55E36D988' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 22:18:58======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = E0D55E36D988 sName = DESKTOP-IHIELAL ========================2018-12-04 22:18: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 = 'E0D55E36D988' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 22:19:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2018-12-04 22:19:55======================== 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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-04 22:20:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2018-12-04 22:20: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0