========================2018-01-02 10:24:17======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = FFFFFFFFFFFFA49B53B7 sCDKey = 755192599021 sName = PC ========================2018-01-02 10:24: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 = '755192599021' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 10:24:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LOV17KJ parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 9883892DDCD46226A947 sCDKey = 267735507375 sName = DESKTOP-LOV17KJ ========================2018-01-02 10:24: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 = '267735507375' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 10:24:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bmsys9939' ========================2018-01-02 10:24:20======================== SELECT idx FROM macs WHERE mac_addr = '9883892DDCD46226A947' AND app_code = '039' ========================2018-01-02 10:24:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '214222' ========================2018-01-02 10:24:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '214222' ========================2018-01-02 10:24:20======================== UPDATE mac_detail SET pc_name = 'DESKTOP-LOV17KJ', os_type = '110', user_id = 'bmsys9939', user_name = '부명시스템[김영길]', screen_w = '1536', screen_h = '864', cdkey = '267735507375' WHERE mac_idx = '214222' ========================2018-01-02 10:30:15======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = FFFFFFFFFFFFA49B53B7 sCDKey = 755192599021 sName = PC ========================2018-01-02 10:30: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 = '755192599021' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 10:30:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k9025' ========================2018-01-02 10:30:15======================== SELECT idx FROM macs WHERE mac_addr = 'FFFFFFFFFFFFA49B53B7' AND app_code = '039' ========================2018-01-02 10:30:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237568' ========================2018-01-02 10:30:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237568' ========================2018-01-02 10:30:15======================== UPDATE mac_detail SET pc_name = 'PC', os_type = '110', user_id = 'k9025', user_name = '(주)중동물류[김양곤]', screen_w = '1536', screen_h = '864', cdkey = '755192599021' WHERE mac_idx = '237568' ========================2018-01-02 10:30:21======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = FFFFFFFFFFFFA49B53B7 sCDKey = 755192599021 sName = PC ========================2018-01-02 10:30:21======================== 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 = '755192599021' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 10:30:33======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = FFFFFFFFFFFFA49B53B7 sCDKey = 755192599021 sName = PC ========================2018-01-02 10:30: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 = '755192599021' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 10:30:48======================== noteurl_start parm_app_code = 039 parm_pc_name = PC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = FFFFFFFFFFFFA49B53B7 sCDKey = 755192599021 sName = PC ========================2018-01-02 10:30: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 = '755192599021' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 11:13:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-705V2FK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F83441008FF2FE4D1BE4 sCDKey = 736191736205 sName = DESKTOP-705V2FK ========================2018-01-02 11:13: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 = '736191736205' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 11:13:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'knhibird' ========================2018-01-02 11:13:04======================== SELECT idx FROM macs WHERE mac_addr = 'F83441008FF2FE4D1BE4' AND app_code = '039' ========================2018-01-02 11:13:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237528' ========================2018-01-02 11:13:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237528' ========================2018-01-02 11:13: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 ( '237528', 'F83441008FF2FE4D1BE4', '039', 'DESKTOP-705V2FK', '110', '1920', '1080', 'knhibird', '이규능[이규능]', '736191736205' ) ========================2018-01-02 11:29:26======================== noteurl_start parm_app_code = 048 parm_pc_name = KCG-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D304C7862A6138453 sCDKey = 557205780622 sName = KCG-PC ========================2018-01-02 11:29: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 = '557205780622' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-02 11:29:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gyu1001' ========================2018-01-02 11:29:26======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304C7862A6138453' AND app_code = '048' ========================2018-01-02 11:29:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237866' ========================2018-01-02 11:29:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237866' ========================2018-01-02 11:29:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '237866', 'F44D304C7862A6138453', '048', 'KCG-PC', '�쐢�룄�슦 10', '0', '0', 'gyu1001', '창규자동차[권창규]', '557205780622' ) ========================2018-01-02 11:49:43======================== noteurl_start parm_app_code = 045 parm_pc_name = POS1 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 6002925B0156C0A59A4B sCDKey = 767959915510 sName = POS1 ========================2018-01-02 11:49:43======================== 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 = '767959915510' AND r.app_code = '045' AND r.app_block = 0 ========================2018-01-02 11:49:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chojaeseong' ========================2018-01-02 11:49:43======================== SELECT idx FROM macs WHERE mac_addr = '6002925B0156C0A59A4B' AND app_code = '045' ========================2018-01-02 11:49:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237875' ========================2018-01-02 11:49:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237875' ========================2018-01-02 11:49:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '237875', '6002925B0156C0A59A4B', '045', 'POS1', '64', '1024', '768', 'chojaeseong', '미소매점[조재성]', '767959915510' ) ========================2018-01-02 11:53:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 767959915510 sName = DESKTOP-RIU7E7C ========================2018-01-02 11:53:56======================== 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 = '767959915510' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-02 11:54:10======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-RIU7E7C parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 9883892E09ACAA233C88 sCDKey = 003400982708 sName = DESKTOP-RIU7E7C ========================2018-01-02 11:54:10======================== 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 = '003400982708' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-02 11:54:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chojaeseong' ========================2018-01-02 11:54:10======================== SELECT idx FROM macs WHERE mac_addr = '9883892E09ACAA233C88' AND app_code = '046' ========================2018-01-02 11:54:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '198520' ========================2018-01-02 11:54:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '198520' ========================2018-01-02 11:54:10======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RIU7E7C', os_type = '110', user_id = 'chojaeseong', user_name = '미소매점[조재성]', screen_w = '1366', screen_h = '768', cdkey = '003400982708' WHERE mac_idx = '198520' ========================2018-01-02 13:01:29======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-Q6PQIGMIS0 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B8AEEDAF696D102C15C2 sCDKey = 270789054722 sName = MSDN-Q6PQIGMIS0 ========================2018-01-02 13:01:29======================== 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 = '270789054722' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-02 13:01:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'smh8910' ========================2018-01-02 13:01:29======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDAF696D102C15C2' AND app_code = '046' ========================2018-01-02 13:01:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237892' ========================2018-01-02 13:01:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237892' ========================2018-01-02 13:01:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '237892', 'B8AEEDAF696D102C15C2', '046', 'MSDN-Q6PQIGMIS0', '90', '1600', '900', 'smh8910', '덕성종합건재[송문호]', '270789054722' ) ========================2018-01-02 14:00:02======================== noteurl_start parm_app_code = 039 parm_pc_name = U110-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E1BC0F684599400 sCDKey = 230147408911 sName = U110-PC ========================2018-01-02 14:00: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 = '230147408911' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 14:00:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee8631234' ========================2018-01-02 14:00:02======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E1BC0F684599400' AND app_code = '039' ========================2018-01-02 14:00:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237905' ========================2018-01-02 14:00:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237905' ========================2018-01-02 14:00:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '237905', 'E0D55E1BC0F684599400', '039', 'U110-PC', '90', '1920', '1080', 'lee8631234', '형제광고사(주)[이영일]', '230147408911' ) ========================2018-01-02 14:26:07======================== noteurl_start parm_app_code = 039 parm_pc_name = MAIN-PC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 309C235ECFE34AAC29B9 sCDKey = 205593624524 sName = MAIN-PC ========================2018-01-02 14:26: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 = '205593624524' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 14:26:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yujindacro' ========================2018-01-02 14:26:07======================== SELECT idx FROM macs WHERE mac_addr = '309C235ECFE34AAC29B9' AND app_code = '039' ========================2018-01-02 14:26:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237608' ========================2018-01-02 14:26:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237608' ========================2018-01-02 14:26: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 ( '237608', '309C235ECFE34AAC29B9', '039', 'MAIN-PC', '110', '1366', '768', 'yujindacro', '유진다크로[정필호]', '205593624524' ) ========================2018-01-02 14:42:58======================== noteurl_start parm_app_code = 039 parm_pc_name = PJS parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003018A18AEC682074B1 sCDKey = 602903636174 sName = PJS ========================2018-01-02 14:42: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 = '602903636174' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 14:42:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'minsunmall' ========================2018-01-02 14:42:58======================== SELECT idx FROM macs WHERE mac_addr = '003018A18AEC682074B1' AND app_code = '039' ========================2018-01-02 14:42:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '151063' ========================2018-01-02 14:42:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '151063' ========================2018-01-02 14:42:58======================== UPDATE mac_detail SET pc_name = 'PJS', os_type = '90', user_id = 'minsunmall', user_name = '민선종합상사[박종성]', screen_w = '1920', screen_h = '1080', cdkey = '602903636174' WHERE mac_idx = '151063' ========================2018-01-02 16:05:12======================== noteurl_start parm_app_code = 039 parm_pc_name = MSI-NOTEBOOK-ST parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8CB8A7E7F155427A512 sCDKey = 432114869519 sName = MSI-NOTEBOOK-ST ========================2018-01-02 16:05: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 = '432114869519' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 16:05:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'labnpart' ========================2018-01-02 16:05:12======================== SELECT idx FROM macs WHERE mac_addr = 'D8CB8A7E7F155427A512' AND app_code = '039' ========================2018-01-02 16:05:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237933' ========================2018-01-02 16:05:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237933' ========================2018-01-02 16:05:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '237933', 'D8CB8A7E7F155427A512', '039', 'MSI-NOTEBOOK-ST', '110', '1536', '864', 'labnpart', '랩앤파트코리아[최영일]', '432114869519' ) ========================2018-01-02 16:25:28======================== noteurl_start parm_app_code = 039 parm_pc_name = PP-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D02788DA6D2518DC9AD8 sCDKey = 670959866226 sName = PP-PC ========================2018-01-02 16:25: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 = '670959866226' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 16:25:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnsjkr' ========================2018-01-02 16:25:28======================== SELECT idx FROM macs WHERE mac_addr = 'D02788DA6D2518DC9AD8' AND app_code = '039' ========================2018-01-02 16:25:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '234803' ========================2018-01-02 16:25:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '234803' ========================2018-01-02 16:25:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '234803', 'D02788DA6D2518DC9AD8', '039', 'PP-PC', '90', '1680', '1050', 'dnsjkr', '동남산전[황대근]', '670959866226' ) ========================2018-01-02 18:01:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CL48A0P parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B06EBF34E5A1F0CC6903 sCDKey = 002230984718 sName = DESKTOP-CL48A0P ========================2018-01-02 18:01: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 = '002230984718' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-02 18:01:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mkkk9644' ========================2018-01-02 18:01:08======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBF34E5A1F0CC6903' AND app_code = '039' ========================2018-01-02 18:01:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236310' ========================2018-01-02 18:01:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236310' ========================2018-01-02 18:01:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '236310', 'B06EBF34E5A1F0CC6903', '039', 'DESKTOP-CL48A0P', '110', '1920', '1080', 'mkkk9644', '벽산제주영업소[문경국]', '002230984718' )