========================2018-06-29 13:14:15======================== noteurl_start parm_app_code = 048 parm_pc_name = 이승환 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9B79B345CC662 sCDKey = 542107696584 sName = 이승환 ========================2018-06-29 13:14: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 = '542107696584' AND r.app_code = '048' AND r.app_block = 0 ========================2018-06-29 13:14:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vizz' ========================2018-06-29 13:14:15======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B79B345CC662' AND app_code = '048' ========================2018-06-29 13:14:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253098' ========================2018-06-29 13:14:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253098' ========================2018-06-29 13:14:15======================== UPDATE mac_detail SET pc_name = '이승환', os_type = '�쐢�룄�슦 10', user_id = 'vizz', user_name = '이승환[이승환]', screen_w = '0', screen_h = '0', cdkey = '542107696584' WHERE mac_idx = '253098' ========================2018-06-29 13:47:37======================== noteurl_start parm_app_code = 045 parm_pc_name = 박부장 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6CF0490B22EDF8C6C185 sCDKey = 977868007926 sName = 박부장 ========================2018-06-29 13:47: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 = '977868007926' AND r.app_code = '045' AND r.app_block = 0 ========================2018-06-29 13:47:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qq7095164' ========================2018-06-29 13:47:37======================== SELECT idx FROM macs WHERE mac_addr = '6CF0490B22EDF8C6C185' AND app_code = '045' ========================2018-06-29 13:47:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253206' ========================2018-06-29 13:47:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253206' ========================2018-06-29 13:47: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 ( '253206', '6CF0490B22EDF8C6C185', '045', '박부장', '90', '1920', '1080', 'qq7095164', '한국방화문[이화정]', '977868007926' ) ========================2018-06-29 13:48:59======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 001060C7B1B3E7F39CE sCDKey = 545441335904 sName = USER-PC ========================2018-06-29 13:48:59======================== 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 = '545441335904' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-29 13:49:06======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 001060C7B1B3E7F39CE sCDKey = 545441335904 sName = USER-PC ========================2018-06-29 13:49: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 = '545441335904' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-29 13:51:18======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 001060C7B1B3E7F39CE sCDKey = 545441335904 sName = USER-PC ========================2018-06-29 13:51:18======================== 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 = '545441335904' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-29 13:51:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vv09' ========================2018-06-29 13:51:18======================== SELECT idx FROM macs WHERE mac_addr = '001060C7B1B3E7F39CE' AND app_code = '039' ========================2018-06-29 13:51:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253154' ========================2018-06-29 13:51:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253154' ========================2018-06-29 13:51: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 ( '253154', '001060C7B1B3E7F39CE', '039', 'USER-PC', '90', '1280', '800', 'vv09', '영동유업[김은해]', '545441335904' ) ========================2018-06-29 13:51:27======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 001060C7B1B3E7F39CE sCDKey = 545441335904 sName = USER-PC ========================2018-06-29 13:51: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 = '545441335904' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-29 13:51:36======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = 001060C7B1B3E7F39CE sCDKey = 545441335904 sName = USER-PC ========================2018-06-29 13:51: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 = '545441335904' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-29 13:53:04======================== noteurl_start parm_app_code = 045 parm_pc_name = 김과장 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C22BC8BFE8B7B5E1 sCDKey = 977868007926 sName = 김과장 ========================2018-06-29 13:53:04======================== 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 = '977868007926' AND r.app_code = '045' AND r.app_block = 0 ========================2018-06-29 13:53:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qq7095164' ========================2018-06-29 13:53:04======================== SELECT idx FROM macs WHERE mac_addr = '7085C22BC8BFE8B7B5E1' AND app_code = '045' ========================2018-06-29 13:53:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253210' ========================2018-06-29 13:53:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253210' ========================2018-06-29 13:53:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253210', '7085C22BC8BFE8B7B5E1', '045', '김과장', '90', '1920', '1080', 'qq7095164', '한국방화문[이화정]', '977868007926' ) ========================2018-06-29 16:27:17======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JSR3CCD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00089FF4CEB352BFB5D0 sCDKey = 116617546847 sName = DESKTOP-JSR3CCD ========================2018-06-29 16:27: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 = '116617546847' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-29 16:27:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wooritools' ========================2018-06-29 16:27:17======================== SELECT idx FROM macs WHERE mac_addr = '00089FF4CEB352BFB5D0' AND app_code = '046' ========================2018-06-29 16:27:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253207' ========================2018-06-29 16:27:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253207' ========================2018-06-29 16:27: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 ( '253207', '00089FF4CEB352BFB5D0', '046', 'DESKTOP-JSR3CCD', '110', '1920', '1080', 'wooritools', '우리종합공구[김민재]', '116617546847' ) ========================2018-06-29 16:27:22======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JSR3CCD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00089FF4CEB352BFB5D0 sCDKey = 116617546847 sName = DESKTOP-JSR3CCD ========================2018-06-29 16:27:22======================== 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 = '116617546847' AND r.app_code = '046' AND r.app_block = 0