========================2018-02-09 11:18:29======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 금림 ========================2018-02-09 11:18: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:18:51======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = ========================2018-02-09 11:18: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:19:06======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 김진성 ========================2018-02-09 11:19: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:19:16======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 김진성 ========================2018-02-09 11:19:16======================== 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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:20:14======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 금림1 ========================2018-02-09 11:20: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:30:07======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 금림1 ========================2018-02-09 11:30: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:30:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'soungjin9' ========================2018-02-09 11:30:07======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D38142F72E773E3' AND app_code = '039' ========================2018-02-09 11:30:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235329' ========================2018-02-09 11:30:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235329' ========================2018-02-09 11:30: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 ( '235329', '1C1B0D38142F72E773E3', '039', '금림1', '110', '1920', '1080', 'soungjin9', '센트럴타워[김진성]', '337741337408' ) ========================2018-02-09 11:30:15======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 금림1 ========================2018-02-09 11: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:30:36======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 금림1 ========================2018-02-09 11:30: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:30:54======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 금림1 ========================2018-02-09 11:30:54======================== 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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:31:00======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 금림1 ========================2018-02-09 11:31:00======================== 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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:32:07======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 센트럴타워 ========================2018-02-09 11:32: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:32:19======================== noteurl_start parm_app_code = 039 parm_pc_name = 금림1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D38142F72E773E3 sCDKey = 337741337408 sName = 센트럴타워 ========================2018-02-09 11:32: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 = '337741337408' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-09 11:56:54======================== noteurl_start parm_app_code = 047 parm_pc_name = 김창원 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 64E599FB3E060A5DC0D8 sCDKey = 486979617356 sName = 김창원 ========================2018-02-09 11:56:54======================== 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 = '486979617356' AND r.app_code = '047' AND r.app_block = 0 ========================2018-02-09 11:56:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'klmm12' ========================2018-02-09 11:56:54======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E060A5DC0D8' AND app_code = '047' ========================2018-02-09 11:56:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '223850' ========================2018-02-09 11:56:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '223850' ========================2018-02-09 11:56:54======================== UPDATE mac_detail SET pc_name = '김창원', os_type = '�쐢�룄�슦 10', user_id = 'klmm12', user_name = '엠제이소프트[김창원]', screen_w = '0', screen_h = '0', cdkey = '486979617356' WHERE mac_idx = '223850' ========================2018-02-09 13:40:16======================== 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 = 00E160C6096E18DC9AD8 sCDKey = 670959866226 sName = PP-PC ========================2018-02-09 13:40:16======================== 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-02-09 13:40:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnsjkr' ========================2018-02-09 13:40:16======================== SELECT idx FROM macs WHERE mac_addr = '00E160C6096E18DC9AD8' AND app_code = '039' ========================2018-02-09 13:40:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241698' ========================2018-02-09 13:40:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241698' ========================2018-02-09 13:40:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241698', '00E160C6096E18DC9AD8', '039', 'PP-PC', '90', '1680', '1050', 'dnsjkr', '동남산전[황대근]', '670959866226' ) ========================2018-02-09 16:33:37======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-6VAS6FL parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = E0D55E53076A28C0A014 sCDKey = 355063433623 sName = 호평종합건재다산점 ========================2018-02-09 16:33: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 = '355063433623' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-09 16:33:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'shg12355' ========================2018-02-09 16:33:37======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E53076A28C0A014' AND app_code = '046' ========================2018-02-09 16:33:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241874' ========================2018-02-09 16:33:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241874' ========================2018-02-09 16:33: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 ( '241874', 'E0D55E53076A28C0A014', '046', '호평종합건재다산점', '110', '1360', '768', 'shg12355', '호평종합건재[서희근]', '355063433623' ) ========================2018-02-09 16:55:17======================== noteurl_start parm_app_code = 051 parm_pc_name = W10TL5CG750649D parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = D4258B944A49F28D4899 sCDKey = 851095746023 sName = 17H15185 ========================2018-02-09 16:55: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 = '851095746023' AND r.app_code = '051' AND r.app_block = 0 ========================2018-02-09 16:55:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ik549892' ========================2018-02-09 16:55:18======================== SELECT idx FROM macs WHERE mac_addr = 'D4258B944A49F28D4899' AND app_code = '051' ========================2018-02-09 16:55:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240167' ========================2018-02-09 16:55:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240167' ========================2018-02-09 16:55: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 ( '240167', 'D4258B944A49F28D4899', '051', '17H15185', '109', '1366', '768', 'ik549892', '지에스케이(GSK)[김인배]', '851095746023' ) ========================2018-02-09 17:15:21======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-FHH5SBR parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = E8393533549A28BD92A2 sCDKey = 995043238263 sName = DESKTOP-FHH5SBR ========================2018-02-09 17:15: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 = '995043238263' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-09 17:15:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hizoner' ========================2018-02-09 17:15:21======================== SELECT idx FROM macs WHERE mac_addr = 'E8393533549A28BD92A2' AND app_code = '046' ========================2018-02-09 17:15:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241881' ========================2018-02-09 17:15:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241881' ========================2018-02-09 17:15:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241881', 'E8393533549A28BD92A2', '046', 'DESKTOP-FHH5SBR', '110', '1280', '1024', 'hizoner', '다판다원주점[최영수]', '995043238263' )