========================2021-12-17 09:21:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VCEES5Q parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D0509981AAA6B639C420 sCDKey = 340958508106 sName = DESKTOP-VCEES5Q ========================2021-12-17 09:21: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 = '340958508106' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-17 09:21:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhkdxo14' ========================2021-12-17 09:21:14======================== SELECT idx FROM macs WHERE mac_addr = 'D0509981AAA6B639C420' AND app_code = '039' ========================2021-12-17 09:21:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356610' ========================2021-12-17 09:21:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356610' ========================2021-12-17 09:21: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 ( '356610', 'D0509981AAA6B639C420', '039', 'DESKTOP-VCEES5Q', '110', '1680', '1050', 'rhkdxo14', '(주)신평양찹쌀순대[최재민]', '340958508106' ) ========================2021-12-17 16:20:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DELL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 747827AD41F7468A46F6 sCDKey = 422114683375 sName = DELL ========================2021-12-17 16:20: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 = '422114683375' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-17 16:20:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'id4love' ========================2021-12-17 16:20:23======================== SELECT idx FROM macs WHERE mac_addr = '747827AD41F7468A46F6' AND app_code = '039' ========================2021-12-17 16:20:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356643' ========================2021-12-17 16:20:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356643' ========================2021-12-17 16:20: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 ( '356643', '747827AD41F7468A46F6', '039', 'DELL', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375' ) ========================2021-12-17 16:41:59======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-Q1671TK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8BBC119715890C13917 sCDKey = 936245283016 sName = DESKTOP-Q1671TK ========================2021-12-17 16:41:59======================== 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 = '936245283016' AND r.app_code = '046' AND r.app_block = 0 ========================2021-12-17 16:41:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeong4023' ========================2021-12-17 16:41:59======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC119715890C13917' AND app_code = '046' ========================2021-12-17 16:41:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343680' ========================2021-12-17 16:41:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343680' ========================2021-12-17 16:41:59======================== UPDATE mac_detail SET pc_name = 'DESKTOP-Q1671TK', os_type = '110', user_id = 'jeong4023', user_name = '[김태정]', screen_w = '1920', screen_h = '1080', cdkey = '936245283016' WHERE mac_idx = '343680' ========================2021-12-17 17:14:22======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-K51BEBG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E8F4088FD4506442996A sCDKey = 110521565865 sName = DESKTOP-K51BEBG ========================2021-12-17 17:14:22======================== 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 = '110521565865' AND r.app_code = '048' AND r.app_block = 0 ========================2021-12-17 17:18:22======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-K51BEBG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E8F4088FD4506442996A sCDKey = 389590212593 sName = DESKTOP-K51BEBG ========================2021-12-17 17:18:22======================== 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 = '389590212593' AND r.app_code = '048' AND r.app_block = 0 ========================2021-12-17 17:18:37======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-K51BEBG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E8F4088FD4506442996A sCDKey = 389590212593 sName = DESKTOP-K51BEBG ========================2021-12-17 17:18: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 = '389590212593' AND r.app_code = '048' AND r.app_block = 0 ========================2021-12-17 18:42:08======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF73358BEAEE2B1141 sCDKey = 767095042850 sName = DESKTOP-IR4BE71 ========================2021-12-17 18:42: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 = '767095042850' AND r.app_code = '047' AND r.app_block = 0 ========================2021-12-17 18:42:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'emekorea' ========================2021-12-17 18:42:08======================== SELECT idx FROM macs WHERE mac_addr = '50AF73358BEAEE2B1141' AND app_code = '047' ========================2021-12-17 18:42:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356662' ========================2021-12-17 18:42:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356662' ========================2021-12-17 18:42:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '356662', '50AF73358BEAEE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'emekorea', '이엠이코리아[김덕인]', '767095042850' ) ========================2021-12-17 18:42:26======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF73358BEAEE2B1141 sCDKey = 767095042850 sName = DESKTOP-IR4BE71 ========================2021-12-17 18:42: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 = '767095042850' AND r.app_code = '047' AND r.app_block = 0