========================2019-01-08 10:22:03======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-20190103UKD parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002522DE52FDF41E8DF4 sCDKey = 336231475440 sName = WIN-20190103UKD ========================2019-01-08 10:22: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 = '336231475440' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-08 10:22:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ich0040' ========================2019-01-08 10:22:03======================== SELECT idx FROM macs WHERE mac_addr = '002522DE52FDF41E8DF4' AND app_code = '039' ========================2019-01-08 10:22:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273342' ========================2019-01-08 10:22:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273342' ========================2019-01-08 10:22:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '273342', '002522DE52FDF41E8DF4', '039', 'WIN-20190103UKD', '90', '1920', '1080', 'ich0040', '그린원[임채헌]', '336231475440' ) ========================2019-01-08 11:11:18======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC02 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C20A3DD916D84972 sCDKey = 368335700167 sName = USER-PC02 ========================2019-01-08 11:11: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 = '368335700167' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-08 11:11:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kim71882' ========================2019-01-08 11:11:18======================== SELECT idx FROM macs WHERE mac_addr = '7085C20A3DD916D84972' AND app_code = '046' ========================2019-01-08 11:11:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273276' ========================2019-01-08 11:11:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273276' ========================2019-01-08 11:11: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 ( '273276', '7085C20A3DD916D84972', '046', 'USER-PC02', '90', '1920', '1080', 'kim71882', 'TK종합상사[이종훈]', '368335700167' ) ========================2019-01-08 11:34:08======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B42E99127B33649CB52F sCDKey = 590496194321 sName = USER-PC ========================2019-01-08 11:34: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 = '590496194321' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-08 11:34:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dudwls8964' ========================2019-01-08 11:34:08======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99127B33649CB52F' AND app_code = '039' ========================2019-01-08 11:34:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273354' ========================2019-01-08 11:34:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273354' ========================2019-01-08 11:34: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 ( '273354', 'B42E99127B33649CB52F', '039', 'USER-PC', '90', '1680', '1050', 'dudwls8964', '영진플랜트[박철수]', '590496194321' ) ========================2019-01-08 13:50:29======================== noteurl_start parm_app_code = 039 parm_pc_name = JHS parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6DD8656264AD17 sCDKey = 188538452662 sName = JHS ========================2019-01-08 13:50: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 = '188538452662' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-08 13:50:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qhtjd4873' ========================2019-01-08 13:50:29======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6DD8656264AD17' AND app_code = '039' ========================2019-01-08 13:50:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273381' ========================2019-01-08 13:50:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273381' ========================2019-01-08 13:50:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '273381', 'E8039A6DD8656264AD17', '039', 'JHS', '90', '1920', '1080', 'qhtjd4873', '주식획사 보성[전인영]', '188538452662' ) ========================2019-01-08 16:47:50======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E57A0193278935B sCDKey = 068475284698 sName = USER-PC ========================2019-01-08 16:47: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 = '068475284698' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-08 16:47:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'whaudghks71' ========================2019-01-08 16:47:50======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E57A0193278935B' AND app_code = '039' ========================2019-01-08 16:47:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273418' ========================2019-01-08 16:47:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273418' ========================2019-01-08 16:47:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '273418', 'E0D55E57A0193278935B', '039', 'USER-PC', '90', '1920', '1080', 'whaudghks71', '민영[조명환]', '068475284698' )