========================2020-07-03 10:35:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-7SQV8EV parm_os_type = 109 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B42E99F6F90BD8286289 sCDKey = 166431885453 sName = DESKTOP-7SQV8EV ========================2020-07-03 10:35:51======================== 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 = '166431885453' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-03 10:35:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chilsung4312' ========================2020-07-03 10:35:52======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99F6F90BD8286289' AND app_code = '039' ========================2020-07-03 10:35:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320998' ========================2020-07-03 10:35:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320998' ========================2020-07-03 10:35:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320998', 'B42E99F6F90BD8286289', '039', 'DESKTOP-7SQV8EV', '109', '1680', '1050', 'chilsung4312', '칠성에너지[성기욱]', '166431885453' ) ========================2020-07-03 13:14:20======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B8AEEDA44180846BB25F sCDKey = 217223037343 sName = OFFICE-PC ========================2020-07-03 13:14: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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-03 13:14:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunjin677' ========================2020-07-03 13:14:20======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDA44180846BB25F' AND app_code = '039' ========================2020-07-03 13:14:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294578' ========================2020-07-03 13:14:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294578' ========================2020-07-03 13:14:20======================== UPDATE mac_detail SET pc_name = 'OFFICE-PC', os_type = '110', user_id = 'sunjin677', user_name = '선진FS[김형희]', screen_w = '1280', screen_h = '1024', cdkey = '217223037343' WHERE mac_idx = '294578' ========================2020-07-03 13:14:26======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B8AEEDA44180846BB25F sCDKey = 217223037343 sName = OFFICE-PC ========================2020-07-03 13:14:26======================== 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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-03 13:33:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5SA3U8I parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EBB36C1883D9100 sCDKey = 585397753358 sName = DESKTOP-5SA3U8I ========================2020-07-03 13:33: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 = '585397753358' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-03 13:33:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mihiki' ========================2020-07-03 13:33:04======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EBB36C1883D9100' AND app_code = '039' ========================2020-07-03 13:33:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321066' ========================2020-07-03 13:33:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '321066' ========================2020-07-03 13:33: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 ( '321066', 'E0D55EBB36C1883D9100', '039', 'DESKTOP-5SA3U8I', '110', '1920', '1080', 'mihiki', '(주)이레산업[김경남]', '585397753358' ) ========================2020-07-03 13:41:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-U9UJ11E parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C69131B184D0A6EB13 sCDKey = 564342661899 sName = DESKTOP-U9UJ11E ========================2020-07-03 13:41:53======================== 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 = '564342661899' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-03 13:41:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dsoa275512' ========================2020-07-03 13:41:53======================== SELECT idx FROM macs WHERE mac_addr = '94C69131B184D0A6EB13' AND app_code = '039' ========================2020-07-03 13:41:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321068' ========================2020-07-03 13:41:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '321068' ========================2020-07-03 13:41:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '321068', '94C69131B184D0A6EB13', '039', 'DESKTOP-U9UJ11E', '110', '1920', '1080', 'dsoa275512', '대성종합시스템[정인식]', '564342661899' )