========================2023-01-12 10:07:09======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-OP1H365 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 54BF647A93F2980CCA23 sCDKey = 984684865924 sName = DESKTOP-OP1H365 ========================2023-01-12 10:07:09======================== 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 = '984684865924' AND r.app_code = '046' AND r.app_block = 0 ========================2023-01-12 10:19:15======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-OP1H365 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 54BF647A93F2980CCA23 sCDKey = 984684865924 sName = DESKTOP-OP1H365 ========================2023-01-12 10:19:15======================== 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 = '984684865924' AND r.app_code = '046' AND r.app_block = 0 ========================2023-01-12 10:19:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daewon0305' ========================2023-01-12 10:19:15======================== SELECT idx FROM macs WHERE mac_addr = '54BF647A93F2980CCA23' AND app_code = '046' ========================2023-01-12 10:19:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '380594' ========================2023-01-12 10:19:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '380594' ========================2023-01-12 10:19:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '380594', '54BF647A93F2980CCA23', '046', 'DESKTOP-OP1H365', '110', '1920', '1080', 'daewon0305', '대원산업[성시훈]', '984684865924' ) ========================2023-01-12 14:39:02======================== noteurl_start parm_app_code = 050 parm_pc_name = SKAI-YB-MAIN parm_os_type = 109 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 50EBF6994CA964A6A30E sCDKey = 858865714604 sName = SKAI-YB-MAIN ========================2023-01-12 14:39:02======================== 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 = '858865714604' AND r.app_code = '050' AND r.app_block = 0 ========================2023-01-12 14:39:17======================== noteurl_start parm_app_code = 050 parm_pc_name = SKAI-YB-MAIN parm_os_type = 109 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 50EBF6994CA964A6A30E sCDKey = 858865714604 sName = SKAI-YB-MAIN ========================2023-01-12 14:39: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 = '858865714604' AND r.app_code = '050' AND r.app_block = 0 ========================2023-01-12 14:39:48======================== noteurl_start parm_app_code = 050 parm_pc_name = SKAI-YB-MAIN parm_os_type = 109 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 50EBF6994CA964A6A30E sCDKey = 858865714604 sName = SKAI-YB-MAIN ========================2023-01-12 14:39:48======================== 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 = '858865714604' AND r.app_code = '050' AND r.app_block = 0 ========================2023-01-12 14:40:25======================== noteurl_start parm_app_code = 050 parm_pc_name = SKAI-YB-MAIN parm_os_type = 109 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 50EBF6994CA964A6A30E sCDKey = 858865714604 sName = SKAI-YB-MAIN ========================2023-01-12 14:40: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 = '858865714604' AND r.app_code = '050' AND r.app_block = 0 ========================2023-01-12 14:40:43======================== noteurl_start parm_app_code = 050 parm_pc_name = SKAI-YB-MAIN parm_os_type = 109 parm_screen_w = 2560 parm_screen_h = 1080 parm_user_mac = 50EBF6994CA964A6A30E sCDKey = 858865714604 sName = ybmoon ========================2023-01-12 14:40:43======================== 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 = '858865714604' AND r.app_code = '050' AND r.app_block = 0 ========================2023-01-12 15:07:12======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-NM3I2ES parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B33805721F9969 sCDKey = 959868911114 sName = DESKTOP-NM3I2ES ========================2023-01-12 15:07:12======================== 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 = '959868911114' AND r.app_code = '047' AND r.app_block = 0 ========================2023-01-12 15:07:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vndwls3450' ========================2023-01-12 15:07:12======================== SELECT idx FROM macs WHERE mac_addr = '581122B33805721F9969' AND app_code = '047' ========================2023-01-12 15:07:12======================== 값이 없을 경우 ========================2023-01-12 15:08:22======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-NM3I2ES parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B33805721F9969 sCDKey = 959868911114 sName = DESKTOP-NM3I2ES ========================2023-01-12 15:08: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 = '959868911114' AND r.app_code = '047' AND r.app_block = 0 ========================2023-01-12 15:08:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vndwls3450' ========================2023-01-12 15:08:22======================== SELECT idx FROM macs WHERE mac_addr = '581122B33805721F9969' AND app_code = '047' ========================2023-01-12 15:08:22======================== 값이 없을 경우 ========================2023-01-12 15:12:29======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-NM3I2ES parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B33805721F9969 sCDKey = 959868911114 sName = DESKTOP-NM3I2ES ========================2023-01-12 15:12: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 = '959868911114' AND r.app_code = '047' AND r.app_block = 0 ========================2023-01-12 15:12:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vndwls3450' ========================2023-01-12 15:12:29======================== SELECT idx FROM macs WHERE mac_addr = '581122B33805721F9969' AND app_code = '047' ========================2023-01-12 15:12:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '380633' ========================2023-01-12 15:12:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '380633' ========================2023-01-12 15:12:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '380633', '581122B33805721F9969', '047', 'DESKTOP-NM3I2ES', '�쐢�룄�슦 10', '0', '0', 'vndwls3450', '풍진기업[김동안]', '959868911114' ) ========================2023-01-12 15:30:05======================== noteurl_start parm_app_code = 045 parm_pc_name = parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9B7BF8C01EB83 sCDKey = 983362382847 sName = 한동진 ========================2023-01-12 15:30:05======================== 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 = '983362382847' AND r.app_code = '045' AND r.app_block = 0 ========================2023-01-12 15:30:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bestseller12' ========================2023-01-12 15:30:05======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7BF8C01EB83' AND app_code = '045' ========================2023-01-12 15:30:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '380635' ========================2023-01-12 15:30:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '380635' ========================2023-01-12 15:30:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '380635', 'F44D30B9B7BF8C01EB83', '045', '한동진', '110', '1920', '1080', 'bestseller12', 'AZ입맛[한동진]', '983362382847' )