========================2019-07-25 09:17:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-T5EUFQU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23B6D92100DE358 sCDKey = 629919060342 sName = DESKTOP-T5EUFQU ========================2019-07-25 09:17: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 = '629919060342' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-25 09:17:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nmj4513' ========================2019-07-25 09:17:18======================== SELECT idx FROM macs WHERE mac_addr = '7085C23B6D92100DE358' AND app_code = '039' ========================2019-07-25 09:17:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291590' ========================2019-07-25 09:17:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291590' ========================2019-07-25 09:17: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 ( '291590', '7085C23B6D92100DE358', '039', 'DESKTOP-T5EUFQU', '110', '1920', '1080', 'nmj4513', '진주상회[나명주]', '629919060342' ) ========================2019-07-25 09:55:23======================== noteurl_start parm_app_code = 046 parm_pc_name = A03-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 7085C20BC8FC3AF6C411 sCDKey = 369853832250 sName = A03-PC ========================2019-07-25 09:55: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 = '369853832250' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-25 09:55:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gijang09' ========================2019-07-25 09:55:23======================== SELECT idx FROM macs WHERE mac_addr = '7085C20BC8FC3AF6C411' AND app_code = '046' ========================2019-07-25 09:55:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291597' ========================2019-07-25 09:55:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291597' ========================2019-07-25 09:55:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '291597', '7085C20BC8FC3AF6C411', '046', 'A03-PC', '90', '1280', '1024', 'gijang09', '기장종합공구[신성진]', '369853832250' ) ========================2019-07-25 11:54:37======================== noteurl_start parm_app_code = 039 parm_pc_name = LEE parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A644ADEC0611F13 sCDKey = 943551094481 sName = LEE ========================2019-07-25 11:54: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 = '943551094481' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-25 11:54:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kaf0303' ========================2019-07-25 11:54:37======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A644ADEC0611F13' AND app_code = '039' ========================2019-07-25 11:54:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '48195' ========================2019-07-25 11:54:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '48195' ========================2019-07-25 11:54:37======================== UPDATE mac_detail SET pc_name = 'LEE', os_type = '90', user_id = 'kaf0303', user_name = '한도시스템(주)[임문희]', screen_w = '1920', screen_h = '1080', cdkey = '943551094481' WHERE mac_idx = '48195' ========================2019-07-25 13:16:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-66K09AA parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D435DB4A07D282E907 sCDKey = 679451271644 sName = DESKTOP-66K09AA ========================2019-07-25 13:16:25======================== 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 = '679451271644' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-25 13:16:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'snchem' ========================2019-07-25 13:16:25======================== SELECT idx FROM macs WHERE mac_addr = '74D435DB4A07D282E907' AND app_code = '039' ========================2019-07-25 13:16:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '288207' ========================2019-07-25 13:16:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '288207' ========================2019-07-25 13:16:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '288207', '74D435DB4A07D282E907', '039', 'DESKTOP-66K09AA', '110', '1920', '1080', 'snchem', '주식회사 에스엔드씨[유승준]', '679451271644' ) ========================2019-07-25 13:16:36======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-66K09AA parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D435DB4A07D282E907 sCDKey = 679451271644 sName = DESKTOP-66K09AA ========================2019-07-25 13:16:36======================== 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 = '679451271644' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-25 16:24:17======================== noteurl_start parm_app_code = 046 parm_pc_name = SMJ-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 10C37B4A68E274E91699 sCDKey = 400094721734 sName = SMJ-PC ========================2019-07-25 16:24: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 = '400094721734' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-25 16:24:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gktehr' ========================2019-07-25 16:24:17======================== SELECT idx FROM macs WHERE mac_addr = '10C37B4A68E274E91699' AND app_code = '046' ========================2019-07-25 16:24:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '291652' ========================2019-07-25 16:24:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '291652' ========================2019-07-25 16:24: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 ( '291652', '10C37B4A68E274E91699', '046', 'SMJ-PC', '90', '1366', '768', 'gktehr', '울산핫도그[박수미]', '400094721734' )