========================2019-09-03 10:49:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0SUVNEQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838980976ED64ED653 sCDKey = 160997774923 sName = DESKTOP-0SUVNEQ ========================2019-09-03 10:49: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 = '160997774923' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-03 10:49:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bjj3639' ========================2019-09-03 10:49:50======================== SELECT idx FROM macs WHERE mac_addr = '98838980976ED64ED653' AND app_code = '039' ========================2019-09-03 10:49:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294689' ========================2019-09-03 10:49:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294689' ========================2019-09-03 10:49: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 ( '294689', '98838980976ED64ED653', '039', 'DESKTOP-0SUVNEQ', '110', '1920', '1080', 'bjj3639', '보건의료기[신순엽]', '160997774923' ) ========================2019-09-03 11:08:30======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-T8MOUHGM parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A45220524153448AFDE8 sCDKey = 792641355244 sName = LAPTOP-T8MOUHGM ========================2019-09-03 11:08:30======================== 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 = '792641355244' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-03 11:08:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee5257' ========================2019-09-03 11:08:30======================== SELECT idx FROM macs WHERE mac_addr = 'A45220524153448AFDE8' AND app_code = '039' ========================2019-09-03 11:08:30======================== 값이 없을 경우 ========================2019-09-03 11:08:56======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-T8MOUHGM parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A45220524153448AFDE8 sCDKey = 792641355244 sName = LAPTOP-T8MOUHGM ========================2019-09-03 11:08:56======================== 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 = '792641355244' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-03 11:08:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee5257' ========================2019-09-03 11:08:56======================== SELECT idx FROM macs WHERE mac_addr = 'A45220524153448AFDE8' AND app_code = '039' ========================2019-09-03 11:08:56======================== 값이 없을 경우 ========================2019-09-03 11:10:24======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-T8MOUHGM parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A45220524153448AFDE8 sCDKey = 792641355244 sName = LAPTOP-T8MOUHGM ========================2019-09-03 11:10:24======================== 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 = '792641355244' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-03 11:10:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lee5257' ========================2019-09-03 11:10:24======================== SELECT idx FROM macs WHERE mac_addr = 'A45220524153448AFDE8' AND app_code = '039' ========================2019-09-03 11:10:24======================== 값이 없을 경우 ========================2019-09-03 11:28:38======================== noteurl_start parm_app_code = 039 parm_pc_name = A728 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 001CC0AC39127C513040 sCDKey = 291853185304 sName = A728 ========================2019-09-03 11:28:38======================== 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 = '291853185304' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-03 11:28:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ch11963' ========================2019-09-03 11:28:38======================== SELECT idx FROM macs WHERE mac_addr = '001CC0AC39127C513040' AND app_code = '039' ========================2019-09-03 11:28:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294644' ========================2019-09-03 11:28:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294644' ========================2019-09-03 11:28:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '294644', '001CC0AC39127C513040', '039', 'A728', '90', '1600', '900', 'ch11963', '신창코팅[최완규]', '291853185304' )