========================2023-12-15 10:33:45======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-AH31BA8 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7C8334BEBB272E9C88F1 sCDKey = 871701488798 sName = DESKTOP-AH31BA8 ========================2023-12-15 10:33:45======================== 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 = '871701488798' AND r.app_code = '046' AND r.app_block = 0 ========================2023-12-15 10:46:53======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-AH31BA8 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7C8334BEBB272E9C88F1 sCDKey = 871701488798 sName = DESKTOP-AH31BA8 ========================2023-12-15 10:46: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 = '871701488798' AND r.app_code = '046' AND r.app_block = 0 ========================2023-12-15 10:46:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youngnim0902' ========================2023-12-15 10:46:53======================== SELECT idx FROM macs WHERE mac_addr = '7C8334BEBB272E9C88F1' AND app_code = '046' ========================2023-12-15 10:46:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '397654' ========================2023-12-15 10:46:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '397654' ========================2023-12-15 10:46: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 ( '397654', '7C8334BEBB272E9C88F1', '046', 'DESKTOP-AH31BA8', '110', '1920', '1080', 'youngnim0902', '영신공구[최병욱]', '871701488798' ) ========================2023-12-15 10:48:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-OO91D5A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 588694F978BF484945E4 sCDKey = 448884805486 sName = DESKTOP-OO91D5A ========================2023-12-15 10:48:21======================== 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 = '448884805486' AND r.app_code = '039' AND r.app_block = 0 ========================2023-12-15 10:48:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mak13581' ========================2023-12-15 10:48:21======================== SELECT idx FROM macs WHERE mac_addr = '588694F978BF484945E4' AND app_code = '039' ========================2023-12-15 10:48:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '397655' ========================2023-12-15 10:48:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '397655' ========================2023-12-15 10:48:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '397655', '588694F978BF484945E4', '039', 'DESKTOP-OO91D5A', '110', '1920', '1080', 'mak13581', '엠에이케이[엠에이케이]', '448884805486' ) ========================2023-12-15 11:50:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-J6CKG78 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 047C16D380A6E0C496C2 sCDKey = 015585144082 sName = DESKTOP-J6CKG78 ========================2023-12-15 11:50:40======================== 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 = '015585144082' AND r.app_code = '046' AND r.app_block = 0 ========================2023-12-15 11:50:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daekwangfp' ========================2023-12-15 11:50:40======================== SELECT idx FROM macs WHERE mac_addr = '047C16D380A6E0C496C2' AND app_code = '046' ========================2023-12-15 11:50:40======================== 값이 없을 경우 ========================2023-12-15 11:51:22======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-J6CKG78 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 047C16D380A6E0C496C2 sCDKey = 015585144082 sName = DESKTOP-J6CKG78 ========================2023-12-15 11:51: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 = '015585144082' AND r.app_code = '046' AND r.app_block = 0 ========================2023-12-15 11:51:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daekwangfp' ========================2023-12-15 11:51:22======================== SELECT idx FROM macs WHERE mac_addr = '047C16D380A6E0C496C2' AND app_code = '046' ========================2023-12-15 11:51:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '397665' ========================2023-12-15 11:51:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '397665' ========================2023-12-15 11:51:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '397665', '047C16D380A6E0C496C2', '046', 'DESKTOP-J6CKG78', '110', '1920', '1080', 'daekwangfp', '대광농자재[한명섭]', '015585144082' ) ========================2023-12-15 18:55:22======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 28E347210A984363042 sCDKey = 17509686ADMI sName = ========================2023-12-15 18:55: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 = '17509686ADMI' AND r.app_code = '046' AND r.app_block = 0 ========================2023-12-15 18:55:29======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 28E347210A984363042 sCDKey = 17509686ADMI sName = 허정 ========================2023-12-15 18:55:29======================== 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 = '17509686ADMI' AND r.app_code = '046' AND r.app_block = 0 ========================2023-12-15 18:56:35======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 28E347210A984363042 sCDKey = 17509686ADMI sName = 허정 ========================2023-12-15 18:56:35======================== 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 = '17509686ADMI' AND r.app_code = '046' AND r.app_block = 0