========================2021-07-08 12:34:08======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-MKLPF7O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 705DCCF21C3BB8A2ABE6 sCDKey = 720431735714 sName = DESKTOP-MKLPF7O ========================2021-07-08 12: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 = '720431735714' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-08 12:34:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tyw2323' ========================2021-07-08 12:34:08======================== SELECT idx FROM macs WHERE mac_addr = '705DCCF21C3BB8A2ABE6' AND app_code = '047' ========================2021-07-08 12:34:08======================== 값이 없을 경우 ========================2021-07-08 13:15:04======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-FHKJ2CO parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00089FD9767F5270E8EB sCDKey = 111526567771 sName = DESKTOP-FHKJ2CO ========================2021-07-08 13:15: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 = '111526567771' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-08 13:15:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'indong09' ========================2021-07-08 13:15:04======================== SELECT idx FROM macs WHERE mac_addr = '00089FD9767F5270E8EB' AND app_code = '046' ========================2021-07-08 13:15:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347069' ========================2021-07-08 13:15:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '347069' ========================2021-07-08 13:15: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 ( '347069', '00089FD9767F5270E8EB', '046', 'DESKTOP-FHKJ2CO', '110', '1680', '1050', 'indong09', '인동철물공구상사[장성준]', '111526567771' ) ========================2021-07-08 13:15:07======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-FHKJ2CO parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00089FD9767F5270E8EB sCDKey = 111526567771 sName = DESKTOP-FHKJ2CO ========================2021-07-08 13:15:07======================== 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 = '111526567771' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-08 15:37:17======================== noteurl_start parm_app_code = 039 parm_pc_name = KD82 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0068EBA6F244769B00C4 sCDKey = 146845660413 sName = KD82 ========================2021-07-08 15:37: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 = '146845660413' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-08 15:37:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kd4052' ========================2021-07-08 15:37:17======================== SELECT idx FROM macs WHERE mac_addr = '0068EBA6F244769B00C4' AND app_code = '039' ========================2021-07-08 15:37:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347089' ========================2021-07-08 15:37:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '347089' ========================2021-07-08 15:37: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 ( '347089', '0068EBA6F244769B00C4', '039', 'KD82', '110', '1920', '1080', 'kd4052', '극동타이어[정막래]', '146845660413' ) ========================2021-07-08 15:38:34======================== noteurl_start parm_app_code = 046 parm_pc_name = TODAM-MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30AF727E1AE49397 sCDKey = 874699831873 sName = TODAM-MAIN ========================2021-07-08 15:38: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 = '874699831873' AND r.app_code = '046' AND r.app_block = 0 ========================2021-07-08 15:38:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'todamls' ========================2021-07-08 15:38:34======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30AF727E1AE49397' AND app_code = '046' ========================2021-07-08 15:38:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250267' ========================2021-07-08 15:38:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250267' ========================2021-07-08 15:38:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250267', 'F44D30AF727E1AE49397', '046', 'TODAM-MAIN', '110', '1920', '1080', 'todamls', '토담물류[유대웅]', '874699831873' )