========================2024-09-13 09:10:49======================== noteurl_start parm_app_code = 039 parm_pc_name = GUNWOO-PC6 parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = B0416F0F4355DE5D96DF sCDKey = 406189188512 sName = GUNWOO-PC6 ========================2024-09-13 09:10:49======================== 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 = '406189188512' AND r.app_code = '039' AND r.app_block = 0 ========================2024-09-13 09:11:28======================== noteurl_start parm_app_code = 039 parm_pc_name = GUNWOO-PC6 parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = B0416F0F4355DE5D96DF sCDKey = 406189188512 sName = GUNWOO-PC6 ========================2024-09-13 09:11:28======================== 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 = '406189188512' AND r.app_code = '039' AND r.app_block = 0 ========================2024-09-13 09:11:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs490' ========================2024-09-13 09:11:28======================== SELECT idx FROM macs WHERE mac_addr = 'B0416F0F4355DE5D96DF' AND app_code = '039' ========================2024-09-13 09:11:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '410963' ========================2024-09-13 09:11:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '410963' ========================2024-09-13 09:11:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '410963', 'B0416F0F4355DE5D96DF', '039', 'GUNWOO-PC6', '110', '3440', '1440', 'bs490', '주식회사 건우건설[부산지사]', '406189188512' ) ========================2024-09-13 11:03:42======================== noteurl_start parm_app_code = 048 parm_pc_name = BSY parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30BAE8C8F44E2DE1 sCDKey = 781128305474 sName = BSY ========================2024-09-13 11:03:42======================== 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 = '781128305474' AND r.app_code = '048' AND r.app_block = 0 ========================2024-09-13 11:03:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'diami' ========================2024-09-13 11:03:42======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30BAE8C8F44E2DE1' AND app_code = '048' ========================2024-09-13 11:03:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '410976' ========================2024-09-13 11:03:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '410976' ========================2024-09-13 11:03:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '410976', 'F44D30BAE8C8F44E2DE1', '048', 'BSY', '�쐢�룄�슦 10', '0', '0', 'diami', '(주)샤인위드[김미원]', '781128305474' ) ========================2024-09-13 13:30:04======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5993BVI parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B047E93B10782A05E004 sCDKey = 737496428461 sName = DESKTOP-5993BVI ========================2024-09-13 13:30:04======================== 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 = '737496428461' AND r.app_code = '047' AND r.app_block = 0 ========================2024-09-13 13:30:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sharon' ========================2024-09-13 13:30:04======================== SELECT idx FROM macs WHERE mac_addr = 'B047E93B10782A05E004' AND app_code = '047' ========================2024-09-13 13:30:04======================== 값이 없을 경우 ========================2024-09-13 13:31:01======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5993BVI parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B047E93B10782A05E004 sCDKey = 737496428461 sName = DESKTOP-5993BVI ========================2024-09-13 13:31:01======================== 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 = '737496428461' AND r.app_code = '047' AND r.app_block = 0 ========================2024-09-13 13:31:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sharon' ========================2024-09-13 13:31:01======================== SELECT idx FROM macs WHERE mac_addr = 'B047E93B10782A05E004' AND app_code = '047' ========================2024-09-13 13:31:01======================== 값이 없을 경우 ========================2024-09-13 13:35:01======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5993BVI parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B047E93B10782A05E004 sCDKey = 737496428461 sName = DESKTOP-5993BVI ========================2024-09-13 13:35:01======================== 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 = '737496428461' AND r.app_code = '047' AND r.app_block = 0 ========================2024-09-13 13:35:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sharon' ========================2024-09-13 13:35:01======================== SELECT idx FROM macs WHERE mac_addr = 'B047E93B10782A05E004' AND app_code = '047' ========================2024-09-13 13:35:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '410981' ========================2024-09-13 13:35:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '410981' ========================2024-09-13 13:35:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '410981', 'B047E93B10782A05E004', '047', 'DESKTOP-5993BVI', '�쐢�룄�슦 10', '0', '0', 'sharon', '샤론플라워랜드[김보필]', '737496428461' )