========================2019-01-03 09:19:01======================== noteurl_start parm_app_code = 039 parm_pc_name = 엔진하체부 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B06EBF7E493EA8F42BAE sCDKey = 416639321766 sName = 엔진하체부 ========================2019-01-03 09:19: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 = '416639321766' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-03 09:19:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori6666' ========================2019-01-03 09:19:01======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBF7E493EA8F42BAE' AND app_code = '039' ========================2019-01-03 09:19:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272769' ========================2019-01-03 09:19:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272769' ========================2019-01-03 09:19:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272769', 'B06EBF7E493EA8F42BAE', '039', '엔진하체부', '110', '1920', '1080', 'woori6666', '우리공업사[이중근]', '416639321766' ) ========================2019-01-03 10:49:08======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509957D4741882D6A1 sCDKey = 553963775460 sName = ADMIN-PC ========================2019-01-03 10:49: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 = '553963775460' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-03 10:49:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnsexper0401' ========================2019-01-03 10:49:08======================== SELECT idx FROM macs WHERE mac_addr = 'D0509957D4741882D6A1' AND app_code = '039' ========================2019-01-03 10:49:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272785' ========================2019-01-03 10:49:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272785' ========================2019-01-03 10:49: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 ( '272785', 'D0509957D4741882D6A1', '039', 'ADMIN-PC', '90', '1920', '1080', 'dnsexper0401', '디앤에스엑스퍼[유정현]', '553963775460' ) ========================2019-01-03 10:59:16======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-81068CL parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CFDA15B18EFD4F06C0D sCDKey = 793831748044 sName = DESKTOP-81068CL ========================2019-01-03 10:59: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 = '793831748044' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-03 10:59:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ygman301' ========================2019-01-03 10:59:16======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15B18EFD4F06C0D' AND app_code = '048' ========================2019-01-03 10:59:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272792' ========================2019-01-03 10:59:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272792' ========================2019-01-03 10:59: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 ( '272792', '2CFDA15B18EFD4F06C0D', '048', 'DESKTOP-81068CL', '�쐢�룄�슦 10', '0', '0', 'ygman301', '야광맨[(주)글로벌에이치엠]', '793831748044' ) ========================2019-01-03 13:41:29======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GKFQA7V parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2A11C133814916B sCDKey = 854512780616 sName = DESKTOP-GKFQA7V ========================2019-01-03 13:41: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 = '854512780616' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-03 13:41:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodboy216' ========================2019-01-03 13:41:29======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A11C133814916B' AND app_code = '047' ========================2019-01-03 13:41:29======================== 값이 없을 경우 ========================2019-01-03 14:02:03======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GKFQA7V parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2A11C133814916B sCDKey = 854512780616 sName = DESKTOP-GKFQA7V ========================2019-01-03 14:02: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 = '854512780616' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-03 14:02:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodboy216' ========================2019-01-03 14:02:03======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A11C133814916B' AND app_code = '047' ========================2019-01-03 14:02:03======================== 값이 없을 경우 ========================2019-01-03 14:33:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SPRDIUB parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30BC22BE4A23CD3B sCDKey = 116466244096 sName = 근풍실업 ========================2019-01-03 14:33: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 = '116466244096' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-03 14:33:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kpbox1' ========================2019-01-03 14:33:56======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BC22BE4A23CD3B' AND app_code = '039' ========================2019-01-03 14:33:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272827' ========================2019-01-03 14:33:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272827' ========================2019-01-03 14:33:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272827', 'F44D30BC22BE4A23CD3B', '039', '근풍실업', '110', '1920', '1080', 'kpbox1', '근풍실업[김혜숙]', '116466244096' ) ========================2019-01-03 14:44:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GKFQA7V parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2A11C133814916B sCDKey = 854512780616 sName = DESKTOP-GKFQA7V ========================2019-01-03 14:44:35======================== 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 = '854512780616' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-03 14:44:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodboy216' ========================2019-01-03 14:44:35======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A11C133814916B' AND app_code = '047' ========================2019-01-03 14:44:35======================== 값이 없을 경우 ========================2019-01-03 16:00:24======================== noteurl_start parm_app_code = 039 parm_pc_name = ADMIN-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509957D4746A29F59E sCDKey = 553963775460 sName = ADMIN-PC ========================2019-01-03 16:00:24======================== 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 = '553963775460' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-03 16:00:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnsexper0401' ========================2019-01-03 16:00:24======================== SELECT idx FROM macs WHERE mac_addr = 'D0509957D4746A29F59E' AND app_code = '039' ========================2019-01-03 16:00:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272844' ========================2019-01-03 16:00:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272844' ========================2019-01-03 16:00:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272844', 'D0509957D4746A29F59E', '039', 'ADMIN-PC', '90', '1920', '1080', 'dnsexper0401', '디앤에스엑스퍼[유정현]', '553963775460' ) ========================2019-01-03 16:28:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A53POJ5 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = D0509927CAC67968A sCDKey = 130237735661 sName = DESKTOP-A53POJ5 ========================2019-01-03 16:28: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 = '130237735661' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-03 16:28:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ppo7677' ========================2019-01-03 16:28:00======================== SELECT idx FROM macs WHERE mac_addr = 'D0509927CAC67968A' AND app_code = '039' ========================2019-01-03 16:28:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272850' ========================2019-01-03 16:28:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272850' ========================2019-01-03 16:28: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 ( '272850', 'D0509927CAC67968A', '039', 'DESKTOP-A53POJ5', '110', '1280', '720', 'ppo7677', '(주)태안건업[김은실]', '130237735661' )