========================2018-04-19 10:36:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-H9QDNQ9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 80EE73BE315C7435C459 sCDKey = 985125381266 sName = DESKTOP-H9QDNQ9 ========================2018-04-19 10:36: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 = '985125381266' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-19 10:36:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'seaikarus' ========================2018-04-19 10:36:46======================== SELECT idx FROM macs WHERE mac_addr = '80EE73BE315C7435C459' AND app_code = '039' ========================2018-04-19 10:36:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247665' ========================2018-04-19 10:36:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247665' ========================2018-04-19 10:36:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247665', '80EE73BE315C7435C459', '039', 'DESKTOP-H9QDNQ9', '110', '1920', '1080', 'seaikarus', '신일복사[윤상혁]', '985125381266' ) ========================2018-04-19 15:11:34======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CQEGLKD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9D0DB881F03D7 sCDKey = 682778728524 sName = DESKTOP-CQEGLKD ========================2018-04-19 15: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 = '682778728524' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-19 15:11:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n1001x' ========================2018-04-19 15:11:34======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9D0DB881F03D7' AND app_code = '046' ========================2018-04-19 15:11:34======================== 값이 없을 경우 ========================2018-04-19 15:12:13======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CQEGLKD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9D0DB881F03D7 sCDKey = 682778728524 sName = DESKTOP-CQEGLKD ========================2018-04-19 15:12:13======================== 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 = '682778728524' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-19 15:12:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n1001x' ========================2018-04-19 15:12:13======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9D0DB881F03D7' AND app_code = '046' ========================2018-04-19 15:12:13======================== 값이 없을 경우 ========================2018-04-19 15:15:06======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CQEGLKD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9D0DB881F03D7 sCDKey = 682778728524 sName = DESKTOP-CQEGLKD ========================2018-04-19 15:15: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 = '682778728524' AND r.app_code = '046' AND r.app_block = 0 ========================2018-04-19 15:15:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n1001x' ========================2018-04-19 15:15:06======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9D0DB881F03D7' AND app_code = '046' ========================2018-04-19 15:15:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247692' ========================2018-04-19 15:15:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247692' ========================2018-04-19 15:15: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 ( '247692', 'F44D30B9D0DB881F03D7', '046', 'DESKTOP-CQEGLKD', '110', '1920', '1080', 'n1001x', '중앙철물건재골재[이용식]', '682778728524' ) ========================2018-04-19 15:31:17======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 1078D21D05262C3899D2 sCDKey = 945303690342 sName = USER ========================2018-04-19 15:31: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 = '945303690342' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-19 15:31:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dhhwang71' ========================2018-04-19 15:31:17======================== SELECT idx FROM macs WHERE mac_addr = '1078D21D05262C3899D2' AND app_code = '039' ========================2018-04-19 15:31:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247560' ========================2018-04-19 15:31:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247560' ========================2018-04-19 15:31:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '247560', '1078D21D05262C3899D2', '039', 'USER', '90', '1600', '900', 'dhhwang71', '내쇼날플라스틱 엔피씨[황대홍]', '945303690342' ) ========================2018-04-19 17:36:06======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 003067DB467F92B7FB58 sCDKey = 340789024286 sName = MSDN-SPECIAL ========================2018-04-19 17:36: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 = '340789024286' AND r.app_code = '039' AND r.app_block = 0 ========================2018-04-19 17:36:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cosmot' ========================2018-04-19 17:36:06======================== SELECT idx FROM macs WHERE mac_addr = '003067DB467F92B7FB58' AND app_code = '039' ========================2018-04-19 17:36:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '99923' ========================2018-04-19 17:36:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '99923' ========================2018-04-19 17:36: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 ( '99923', '003067DB467F92B7FB58', '039', 'MSDN-SPECIAL', '90', '1280', '1024', 'cosmot', '코스모과학[조성복]', '340789024286' )