========================2019-10-16 06:37:37======================== noteurl_start parm_app_code = 048 parm_pc_name = 1층우 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DC6D4E0E960714 sCDKey = 434133617514 sName = 1층우 ========================2019-10-16 06:37: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-10-16 06:37:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-10-16 06:37:37======================== SELECT idx FROM macs WHERE mac_addr = '988389DC6D4E0E960714' AND app_code = '048' ========================2019-10-16 06:37:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281844' ========================2019-10-16 06:37:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281844' ========================2019-10-16 06:37:37======================== UPDATE mac_detail SET pc_name = '1층우', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '281844' ========================2019-10-16 06:37:44======================== noteurl_start parm_app_code = 048 parm_pc_name = 1층우 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 988389DC6D4E0E960714 sCDKey = 434133617514 sName = 1층우 ========================2019-10-16 06:37:44======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-10-16 06:37:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-10-16 06:37:44======================== SELECT idx FROM macs WHERE mac_addr = '988389DC6D4E0E960714' AND app_code = '048' ========================2019-10-16 06:37:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '281844' ========================2019-10-16 06:37:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '281844' ========================2019-10-16 06:37:44======================== UPDATE mac_detail SET pc_name = '1층우', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '281844' ========================2019-10-16 11:13:50======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-2018 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C5C8E792760BE6E6749 sCDKey = 015399708251 sName = WIN7-2018 ========================2019-10-16 11:13: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 = '015399708251' AND r.app_code = '039' AND r.app_block = 0 ========================2019-10-16 11:13:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qncshan' ========================2019-10-16 11:13:50======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E792760BE6E6749' AND app_code = '039' ========================2019-10-16 11:13:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '300367' ========================2019-10-16 11:13:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '300367' ========================2019-10-16 11:13: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 ( '300367', '9C5C8E792760BE6E6749', '039', 'WIN7-2018', '90', '1920', '1080', 'qncshan', '주식회사 성한[김남균]', '015399708251' ) ========================2019-10-16 14:34:57======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-I44GJTU parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 1831BFBB74F92299786E sCDKey = 735832194513 sName = DESKTOP-I44GJTU ========================2019-10-16 14:34:57======================== 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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2019-10-16 14:36:23======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-I44GJTU parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 1831BFBB74F92299786E sCDKey = 735832194513 sName = DESKTOP-BH0O ========================2019-10-16 14:36: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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2019-10-16 14:36:35======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-I44GJTU parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 1831BFBB74F92299786E sCDKey = 735832194513 sName = EO3 ========================2019-10-16 14:36: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 = '735832194513' AND r.app_code = '046' AND r.app_block = 0 ========================2019-10-16 16:20:20======================== noteurl_start parm_app_code = 039 parm_pc_name = PC1 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5CFC8952C4AB2135 sCDKey = 902109466259 sName = PC1 ========================2019-10-16 16:20: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 = '902109466259' AND r.app_code = '039' AND r.app_block = 0 ========================2019-10-16 16:20:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee1236' ========================2019-10-16 16:20:20======================== SELECT idx FROM macs WHERE mac_addr = '408D5CFC8952C4AB2135' AND app_code = '039' ========================2019-10-16 16:20:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '193371' ========================2019-10-16 16:20:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '193371' ========================2019-10-16 16:20: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 ( '193371', '408D5CFC8952C4AB2135', '039', 'PC1', '90', '1600', '900', 'lee1236', '동훈상사[이정훈]', '902109466259' )