========================2019-08-26 07:48:23======================== noteurl_start parm_app_code = 046 parm_pc_name = 문일공구본점 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B42E9960EB3E76FA137F sCDKey = 658645129020 sName = 문일공구본점 ========================2019-08-26 07:48: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 = '658645129020' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-26 07:49:45======================== noteurl_start parm_app_code = 046 parm_pc_name = 문일공구본점 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B42E9960EB3E76FA137F sCDKey = 658645129020 sName = 문일공구본점 ========================2019-08-26 07:49: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 = '658645129020' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-26 09:02:20======================== noteurl_start parm_app_code = 046 parm_pc_name = 문일공구본점 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B42E9960EB3E76FA137F sCDKey = 658645129020 sName = 문일공구본점 ========================2019-08-26 09:02: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 = '658645129020' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-26 09:02:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mik4844' ========================2019-08-26 09:02:20======================== SELECT idx FROM macs WHERE mac_addr = 'B42E9960EB3E76FA137F' AND app_code = '046' ========================2019-08-26 09:02:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293971' ========================2019-08-26 09:02:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293971' ========================2019-08-26 09:02:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293971', 'B42E9960EB3E76FA137F', '046', '문일공구본점', '110', '1024', '768', 'mik4844', '문일종합공구철물(유)[문일기]', '658645129020' ) ========================2019-08-26 09:02:25======================== noteurl_start parm_app_code = 046 parm_pc_name = 문일공구본점 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B42E9960EB3E76FA137F sCDKey = 658645129020 sName = 문일공구본점 ========================2019-08-26 09:02:25======================== 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 = '658645129020' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-26 11:01:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HQAJUOG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8A5D20524153CEE940DB sCDKey = 593643242192 sName = DESKTOP-HQAJUOG ========================2019-08-26 11:01:03======================== 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 = '593643242192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:01:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhy0606' ========================2019-08-26 11:01:03======================== SELECT idx FROM macs WHERE mac_addr = '8A5D20524153CEE940DB' AND app_code = '039' ========================2019-08-26 11:01:03======================== 값이 없을 경우 ========================2019-08-26 11:07:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HQAJUOG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8A5D20524153CEE940DB sCDKey = 593643242192 sName = DESKTOP-HQAJUOG ========================2019-08-26 11:07: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 = '593643242192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:07:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhy0606' ========================2019-08-26 11:07:26======================== SELECT idx FROM macs WHERE mac_addr = '8A5D20524153CEE940DB' AND app_code = '039' ========================2019-08-26 11:07:26======================== 값이 없을 경우 ========================2019-08-26 11:07:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HQAJUOG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8A5D20524153CEE940DB sCDKey = 593643242192 sName = DESKTOP-HQAJUOG ========================2019-08-26 11:07: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 = '593643242192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:07:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhy0606' ========================2019-08-26 11:07:33======================== SELECT idx FROM macs WHERE mac_addr = '8A5D20524153CEE940DB' AND app_code = '039' ========================2019-08-26 11:07:33======================== 값이 없을 경우 ========================2019-08-26 11:10:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HQAJUOG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8A5D20524153CEE940DB sCDKey = 593643242192 sName = DESKTOP-HQAJUOG ========================2019-08-26 11:10: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 = '593643242192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:10:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhy0606' ========================2019-08-26 11:10:05======================== SELECT idx FROM macs WHERE mac_addr = '8A5D20524153CEE940DB' AND app_code = '039' ========================2019-08-26 11:10:05======================== 값이 없을 경우 ========================2019-08-26 11:10:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HQAJUOG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8A5D20524153CEE940DB sCDKey = 593643242192 sName = DESKTOP-HQAJUOG ========================2019-08-26 11:10: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 = '593643242192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:10:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhy0606' ========================2019-08-26 11:10:15======================== SELECT idx FROM macs WHERE mac_addr = '8A5D20524153CEE940DB' AND app_code = '039' ========================2019-08-26 11:10:15======================== 값이 없을 경우 ========================2019-08-26 11:11:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HQAJUOG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8A5D20524153CEE940DB sCDKey = 593643242192 sName = DESKTOP-HQAJUOG ========================2019-08-26 11:11: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 = '593643242192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:11:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhy0606' ========================2019-08-26 11:11:34======================== SELECT idx FROM macs WHERE mac_addr = '8A5D20524153CEE940DB' AND app_code = '039' ========================2019-08-26 11:11:34======================== 값이 없을 경우 ========================2019-08-26 11:13:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-HQAJUOG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8A5D20524153CEE940DB sCDKey = 593643242192 sName = DESKTOP-HQAJUOG ========================2019-08-26 11:13:49======================== 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 = '593643242192' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:13:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhy0606' ========================2019-08-26 11:13:49======================== SELECT idx FROM macs WHERE mac_addr = '8A5D20524153CEE940DB' AND app_code = '039' ========================2019-08-26 11:13:49======================== 값이 없을 경우 ========================2019-08-26 11:50:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JE0IU4S parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 86B82052415338ED2A59 sCDKey = 455716962303 sName = DESKTOP-JE0IU4S ========================2019-08-26 11:50: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 = '455716962303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:50:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elantra017' ========================2019-08-26 11:50:23======================== SELECT idx FROM macs WHERE mac_addr = '86B82052415338ED2A59' AND app_code = '039' ========================2019-08-26 11:50:23======================== 값이 없을 경우 ========================2019-08-26 11:50:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JE0IU4S parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 86B82052415338ED2A59 sCDKey = 455716962303 sName = DESKTOP-JE0IU4S ========================2019-08-26 11:50: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 = '455716962303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:50:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elantra017' ========================2019-08-26 11:50:46======================== SELECT idx FROM macs WHERE mac_addr = '86B82052415338ED2A59' AND app_code = '039' ========================2019-08-26 11:50:46======================== 값이 없을 경우 ========================2019-08-26 11:50:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JE0IU4S parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 86B82052415338ED2A59 sCDKey = 455716962303 sName = DESKTOP-JE0IU4S ========================2019-08-26 11:50: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 = '455716962303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:50:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elantra017' ========================2019-08-26 11:50:50======================== SELECT idx FROM macs WHERE mac_addr = '86B82052415338ED2A59' AND app_code = '039' ========================2019-08-26 11:50:50======================== 값이 없을 경우 ========================2019-08-26 11:51:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JE0IU4S parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 86B82052415338ED2A59 sCDKey = 455716962303 sName = DESKTOP-JE0IU4S ========================2019-08-26 11:51: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 = '455716962303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:51:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elantra017' ========================2019-08-26 11:51:28======================== SELECT idx FROM macs WHERE mac_addr = '86B82052415338ED2A59' AND app_code = '039' ========================2019-08-26 11:51:28======================== 값이 없을 경우 ========================2019-08-26 11:54:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JE0IU4S parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BCD32052415338ED2A59 sCDKey = 455716962303 sName = DESKTOP-JE0IU4S ========================2019-08-26 11:54: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 = '455716962303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 11:54:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elantra017' ========================2019-08-26 11:54:05======================== SELECT idx FROM macs WHERE mac_addr = 'BCD32052415338ED2A59' AND app_code = '039' ========================2019-08-26 11:54:05======================== 값이 없을 경우 ========================2019-08-26 13:13:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JE0IU4S parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BCD32052415338ED2A59 sCDKey = 455716962303 sName = DESKTOP-JE0IU4S ========================2019-08-26 13:13: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 = '455716962303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 13:13:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elantra017' ========================2019-08-26 13:13:16======================== SELECT idx FROM macs WHERE mac_addr = 'BCD32052415338ED2A59' AND app_code = '039' ========================2019-08-26 13:13:16======================== 값이 없을 경우 ========================2019-08-26 13:17:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JE0IU4S parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BCD32052415338ED2A59 sCDKey = 455716962303 sName = DESKTOP-JE0IU4S ========================2019-08-26 13:17: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 = '455716962303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 13:17:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elantra017' ========================2019-08-26 13:17:21======================== SELECT idx FROM macs WHERE mac_addr = 'BCD32052415338ED2A59' AND app_code = '039' ========================2019-08-26 13:17:21======================== 값이 없을 경우 ========================2019-08-26 13:19:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JE0IU4S parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BCD32052415338ED2A59 sCDKey = 455716962303 sName = DESKTOP-JE0IU4S ========================2019-08-26 13: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 = '455716962303' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-26 13:19:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elantra017' ========================2019-08-26 13:19:07======================== SELECT idx FROM macs WHERE mac_addr = 'BCD32052415338ED2A59' AND app_code = '039' ========================2019-08-26 13:19:07======================== 값이 없을 경우 ========================2019-08-26 17:06:08======================== noteurl_start parm_app_code = 045 parm_pc_name = LSH2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE5C6AB0D604 sCDKey = 716760292314 sName = LSH2 ========================2019-08-26 17:06: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 = '716760292314' AND r.app_code = '045' AND r.app_block = 0 ========================2019-08-26 17:06:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lshgooes' ========================2019-08-26 17:06:08======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE5C6AB0D604' AND app_code = '045' ========================2019-08-26 17:06:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283811' ========================2019-08-26 17:06:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283811' ========================2019-08-26 17:06: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 ( '283811', 'F44D30B9AE5C6AB0D604', '045', 'LSH2', '110', '1920', '1080', 'lshgooes', 'MJSOFT[홍길동]', '716760292314' )