========================2019-01-21 08:47:57======================== noteurl_start parm_app_code = 039 parm_pc_name = QQQ-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 5CF9DDDF40BDEA96C3CE sCDKey = 251108264133 sName = QQQ-PC ========================2019-01-21 08:47: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 = '251108264133' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-21 09:26:23======================== noteurl_start parm_app_code = 039 parm_pc_name = QQQ-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 5CF9DDDF40BDEA96C3CE sCDKey = 251108264133 sName = QQQ-PC ========================2019-01-21 09:26:23======================== 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 = '251108264133' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-21 09:26:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eunn2048' ========================2019-01-21 09:26:23======================== SELECT idx FROM macs WHERE mac_addr = '5CF9DDDF40BDEA96C3CE' AND app_code = '039' ========================2019-01-21 09:26:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274618' ========================2019-01-21 09:26:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274618' ========================2019-01-21 09:26:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274618', '5CF9DDDF40BDEA96C3CE', '039', 'QQQ-PC', '90', '1920', '1080', 'eunn2048', 'SKS페인트(주)[김은영]', '251108264133' ) ========================2019-01-21 10:16:00======================== noteurl_start parm_app_code = 046 parm_pc_name = HANAFOOD0751 parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = B8AEEDFBE7D7A2630916 sCDKey = 302049586825 sName = HANAFOOD0751 ========================2019-01-21 10:16: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 = '302049586825' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-21 10:16:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanafood0751' ========================2019-01-21 10:16:00======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDFBE7D7A2630916' AND app_code = '046' ========================2019-01-21 10:16:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274804' ========================2019-01-21 10:16:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274804' ========================2019-01-21 10:16:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274804', 'B8AEEDFBE7D7A2630916', '046', 'HANAFOOD0751', '110', '2560', '1080', 'hanafood0751', '하나(한길)식자재[곽준혁]', '302049586825' ) ========================2019-01-21 10:29:10======================== noteurl_start parm_app_code = 046 parm_pc_name = HOMESPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF7325BFF3A4AF7DFD sCDKey = 921252470168 sName = HOMESPOS ========================2019-01-21 10:29: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 = '921252470168' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-21 10:29:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2019-01-21 10:29:10======================== SELECT idx FROM macs WHERE mac_addr = '50AF7325BFF3A4AF7DFD' AND app_code = '046' ========================2019-01-21 10:29:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236522' ========================2019-01-21 10:29:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236522' ========================2019-01-21 10:29:10======================== UPDATE mac_detail SET pc_name = 'HOMESPOS', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1024', screen_h = '768', cdkey = '921252470168' WHERE mac_idx = '236522' ========================2019-01-21 10:37:06======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00E04C9730F834627EBF sCDKey = 545505594168 sName = POS-PC ========================2019-01-21 10:37: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 = '545505594168' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-21 10:37:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'parkse15' ========================2019-01-21 10:37:06======================== SELECT idx FROM macs WHERE mac_addr = '00E04C9730F834627EBF' AND app_code = '047' ========================2019-01-21 10:37:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274808' ========================2019-01-21 10:37:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274808' ========================2019-01-21 10:37:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274808', '00E04C9730F834627EBF', '047', 'POS-PC', '�쐢�룄�슦 7', '0', '0', 'parkse15', '(주)세종전기[박세윤]', '545505594168' ) ========================2019-01-21 10:44:21======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-K579BJ4 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = D0509987C9C72C3B06BD sCDKey = 204164651767 sName = DESKTOP-K579BJ4 ========================2019-01-21 10:44: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 = '204164651767' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-21 10:44:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ohdanhong' ========================2019-01-21 10:44:21======================== SELECT idx FROM macs WHERE mac_addr = 'D0509987C9C72C3B06BD' AND app_code = '046' ========================2019-01-21 10:44:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274812' ========================2019-01-21 10:44:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274812' ========================2019-01-21 10:44: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 ( '274812', 'D0509987C9C72C3B06BD', '046', 'DESKTOP-K579BJ4', '110', '1280', '1024', 'ohdanhong', '서림수산[오현주]', '204164651767' ) ========================2019-01-21 14:29:27======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF7325BBA2A41C65F sCDKey = 302053377530 sName = USER-PC ========================2019-01-21 14:29: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 = '302053377530' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-21 14:29:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dodopetcokr' ========================2019-01-21 14:29:27======================== SELECT idx FROM macs WHERE mac_addr = '50AF7325BBA2A41C65F' AND app_code = '046' ========================2019-01-21 14:29:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274853' ========================2019-01-21 14:29:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274853' ========================2019-01-21 14:29:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274853', '50AF7325BBA2A41C65F', '046', 'USER-PC', '90', '1024', '768', 'dodopetcokr', '도도펫본점[신인기]', '302053377530' ) ========================2019-01-21 14:36:11======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-7M644CJ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30BC77387870A406 sCDKey = 807375456416 sName = DESKTOP-7M644CJ ========================2019-01-21 14:36:11======================== 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 = '807375456416' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-21 14:57:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L85VD2F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE12A58E6F484FB sCDKey = 794210755106 sName = DESKTOP-L85VD2F ========================2019-01-21 14:57: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 = '794210755106' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-21 14:57:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mido3840' ========================2019-01-21 14:57:26======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE12A58E6F484FB' AND app_code = '039' ========================2019-01-21 14:57:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274858' ========================2019-01-21 14:57:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274858' ========================2019-01-21 14:57: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 ( '274858', '24F5AAE12A58E6F484FB', '039', 'DESKTOP-L85VD2F', '110', '1920', '1080', 'mido3840', '미도주택관리(주)[임이식]', '794210755106' ) ========================2019-01-21 15:01:41======================== noteurl_start parm_app_code = 039 parm_pc_name = KSY parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2A463FB64582C2C sCDKey = 029901884930 sName = KSY ========================2019-01-21 15:01: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 = '029901884930' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-21 15:01:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ntbk2975' ========================2019-01-21 15:01:41======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A463FB64582C2C' AND app_code = '039' ========================2019-01-21 15:01:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274860' ========================2019-01-21 15:01:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274860' ========================2019-01-21 15:01:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '274860', '7085C2A463FB64582C2C', '039', 'KSY', '110', '1920', '1080', 'ntbk2975', '앤티뱅크[김영숙]', '029901884930' ) ========================2019-01-21 15:20:16======================== noteurl_start parm_app_code = 048 parm_pc_name = 강정미2층출입문 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883898182284CA1F0E3 sCDKey = 434133617514 sName = 강정미2층출입문 ========================2019-01-21 15:20: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-21 15:20:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-01-21 15:20:16======================== SELECT idx FROM macs WHERE mac_addr = '9883898182284CA1F0E3' AND app_code = '048' ========================2019-01-21 15:20:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239964' ========================2019-01-21 15:20:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239964' ========================2019-01-21 15:20:16======================== UPDATE mac_detail SET pc_name = '강정미2층출입문', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '239964'