========================2021-07-02 09:54:00======================== noteurl_start parm_app_code = 047 parm_pc_name = ANNA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E4C291AEB sCDKey = 111127166188 sName = ANNA ========================2021-07-02 09:54:00======================== 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 = '111127166188' AND r.app_code = '047' AND r.app_block = 0 ========================2021-07-02 09:54:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyein1127' ========================2021-07-02 09:54:00======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E4C291AEB' AND app_code = '047' ========================2021-07-02 09:54:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '341229' ========================2021-07-02 09:54:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '341229' ========================2021-07-02 09:54:00======================== UPDATE mac_detail SET pc_name = 'ANNA', os_type = '�쐢�룄�슦 10', user_id = 'hyein1127', user_name = '[황혜인]', screen_w = '0', screen_h = '0', cdkey = '111127166188' WHERE mac_idx = '341229' ========================2021-07-02 14:07:27======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 6C2995210BC4D073EC79 sCDKey = 211075783847 sName = USER ========================2021-07-02 14:07:27======================== 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 = '211075783847' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-02 14:07:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wellbiz1' ========================2021-07-02 14:07:27======================== SELECT idx FROM macs WHERE mac_addr = '6C2995210BC4D073EC79' AND app_code = '039' ========================2021-07-02 14:07:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '346663' ========================2021-07-02 14:07:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '346663' ========================2021-07-02 14:07:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '346663', '6C2995210BC4D073EC79', '039', 'USER', '110', '1536', '864', 'wellbiz1', '성호물산[김종수]', '211075783847' ) ========================2021-07-02 15:23:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KP19RJ9 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 00E04C680527AC404189 sCDKey = 251108264133 sName = DESKTOP-KP19RJ9 ========================2021-07-02 15:23:47======================== 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 = '251108264133' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-02 15:23:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eunn2048' ========================2021-07-02 15:23:47======================== SELECT idx FROM macs WHERE mac_addr = '00E04C680527AC404189' AND app_code = '039' ========================2021-07-02 15:23:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '346655' ========================2021-07-02 15:23:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '346655' ========================2021-07-02 15:23:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '346655', '00E04C680527AC404189', '039', 'DESKTOP-KP19RJ9', '110', '1536', '864', 'eunn2048', 'SKS페인트(주)[김은영]', '251108264133' ) ========================2021-07-02 17:12:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-59JJ2OE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E549C8CCDD7CC77E56 sCDKey = 023096251886 sName = DESKTOP-59JJ2OE ========================2021-07-02 17:12:14======================== 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 = '023096251886' AND r.app_code = '039' AND r.app_block = 0 ========================2021-07-02 17:12:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'copier760' ========================2021-07-02 17:12:14======================== SELECT idx FROM macs WHERE mac_addr = '50E549C8CCDD7CC77E56' AND app_code = '039' ========================2021-07-02 17:12:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '346533' ========================2021-07-02 17:12:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '346533' ========================2021-07-02 17:12:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '346533', '50E549C8CCDD7CC77E56', '039', 'DESKTOP-59JJ2OE', '110', '1920', '1080', 'copier760', '하얀세상[강희원]', '023096251886' ) ========================2021-07-02 18:15:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4OQTO4D parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2C86F603DE36F sCDKey = 446034020345 sName = IJKIM-PC ========================2021-07-02 18:15: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 = '446034020345' AND r.app_code = '039' AND r.app_block = 0