========================2022-03-29 09:08:31======================== noteurl_start parm_app_code = 045 parm_pc_name = 장연정-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = AC81120DA64C1AE49CAC sCDKey = 414922505537 sName = 장연정-PC ========================2022-03-29 09:08:31======================== 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 = '414922505537' AND r.app_code = '045' AND r.app_block = 0 ========================2022-03-29 09:08:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'apackace' ========================2022-03-29 09:08:31======================== SELECT idx FROM macs WHERE mac_addr = 'AC81120DA64C1AE49CAC' AND app_code = '045' ========================2022-03-29 09:08:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248252' ========================2022-03-29 09:08:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248252' ========================2022-03-29 09:08:31======================== UPDATE mac_detail SET pc_name = '장연정-PC', os_type = '90', user_id = 'apackace', user_name = '에이스포장자재(주)[조성민]', screen_w = '1280', screen_h = '800', cdkey = '414922505537' WHERE mac_idx = '248252' ========================2022-03-29 09:38:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BL8HG0S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E916B637780A3F77 sCDKey = 131853021088 sName = DESKTOP-BL8HG0S ========================2022-03-29 09:38:57======================== 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 = '131853021088' AND r.app_code = '039' AND r.app_block = 0 ========================2022-03-29 09:38:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyfc1004' ========================2022-03-29 09:38:57======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E916B637780A3F77' AND app_code = '039' ========================2022-03-29 09:38:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '364106' ========================2022-03-29 09:38:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '364106' ========================2022-03-29 09:38:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '364106', '8CB0E916B637780A3F77', '039', 'DESKTOP-BL8HG0S', '110', '1920', '1080', 'hyfc1004', '(주)한영식품[이수정]', '131853021088' ) ========================2022-03-29 10:16:02======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-GUBBKSU parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = C809A87F7970E66458F sCDKey = 002237082777 sName = DESKTOP-GUBBKSU ========================2022-03-29 10:16: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 = '002237082777' AND r.app_code = '045' AND r.app_block = 0 ========================2022-03-29 10:16:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eunfish' ========================2022-03-29 10:16:02======================== SELECT idx FROM macs WHERE mac_addr = 'C809A87F7970E66458F' AND app_code = '045' ========================2022-03-29 10:16:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '364109' ========================2022-03-29 10:16:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '364109' ========================2022-03-29 10:16:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '364109', 'C809A87F7970E66458F', '045', 'DESKTOP-GUBBKSU', '110', '1536', '864', 'eunfish', '주식회사 다솔낚시마트[최홍식]', '002237082777' ) ========================2022-03-29 14:37:41======================== noteurl_start parm_app_code = 047 parm_pc_name = COUNTER parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BCEE7B8D3FB05AC18129 sCDKey = 374153147566 sName = COUNTER ========================2022-03-29 14:37:41======================== 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 = '374153147566' AND r.app_code = '047' AND r.app_block = 0 ========================2022-03-29 14:41:11======================== noteurl_start parm_app_code = 047 parm_pc_name = COUNTER parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BCEE7B8D3FB05AC18129 sCDKey = 374153147566 sName = COUNTER ========================2022-03-29 14:41:11======================== 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 = '374153147566' AND r.app_code = '047' AND r.app_block = 0 ========================2022-03-29 14:41:59======================== noteurl_start parm_app_code = 047 parm_pc_name = COUNTER parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BCEE7B8D3FB05AC18129 sCDKey = 374153147566 sName = COUNTER ========================2022-03-29 14: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 = '374153147566' AND r.app_code = '047' AND r.app_block = 0 ========================2022-03-29 14:50:10======================== noteurl_start parm_app_code = 047 parm_pc_name = COUNTER parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BCEE7B8D3FB05AC18129 sCDKey = 374153147566 sName = COUNTER ========================2022-03-29 14:50:10======================== 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 = '374153147566' AND r.app_code = '047' AND r.app_block = 0 ========================2022-03-29 14:50:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'joytomin' ========================2022-03-29 14:50:10======================== SELECT idx FROM macs WHERE mac_addr = 'BCEE7B8D3FB05AC18129' AND app_code = '047' ========================2022-03-29 14:50:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282627' ========================2022-03-29 14:50:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282627' ========================2022-03-29 14:50:10======================== UPDATE mac_detail SET pc_name = 'COUNTER', os_type = '�쐢�룄�슦 10', user_id = 'joytomin', user_name = '드럼코리아[박민식]', screen_w = '0', screen_h = '0', cdkey = '374153147566' WHERE mac_idx = '282627'