========================2024-09-27 09:04:24======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 6C2995210BC4A2F8D244 sCDKey = 6C2995210BC4 sName = USER ========================2024-09-27 09:04:24======================== 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 = '6C2995210BC4' AND r.app_code = '039' AND r.app_block = 0 ========================2024-09-27 09:04:50======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 6C2995210BC4A2F8D244 sCDKey = 211075783847 sName = USER ========================2024-09-27 09:04:50======================== 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 = '211075783847' AND r.app_code = '039' AND r.app_block = 0 ========================2024-09-27 09:04:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wellbiz1' ========================2024-09-27 09:04:50======================== SELECT idx FROM macs WHERE mac_addr = '6C2995210BC4A2F8D244' AND app_code = '039' ========================2024-09-27 09:04:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '153077' ========================2024-09-27 09:04:55======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 6C2995210BC4A2F8D244 sCDKey = 211075783847 sName = USER ========================2024-09-27 09:04:55======================== 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 = '211075783847' AND r.app_code = '039' AND r.app_block = 0 ========================2024-09-27 09:04:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wellbiz1' ========================2024-09-27 09:04:55======================== SELECT idx FROM macs WHERE mac_addr = '6C2995210BC4A2F8D244' AND app_code = '039' ========================2024-09-27 09:04:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '153077' ========================2024-09-27 09:04:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '153077' ========================2024-09-27 09:04:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '153077' ========================2024-09-27 09:04:56======================== UPDATE mac_detail SET pc_name = 'USER', os_type = '110', user_id = 'wellbiz1', user_name = '성호물산[김종수]', screen_w = '1536', screen_h = '864', cdkey = '211075783847' WHERE mac_idx = '153077' ========================2024-09-27 09:04:56======================== UPDATE mac_detail SET pc_name = 'USER', os_type = '110', user_id = 'wellbiz1', user_name = '성호물산[김종수]', screen_w = '1536', screen_h = '864', cdkey = '211075783847' WHERE mac_idx = '153077' ========================2024-09-27 10:00:13======================== noteurl_start parm_app_code = 051 parm_pc_name = 20NB00026 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 023B7B140261287010FD sCDKey = 003401679376 sName = SOC인프라 ========================2024-09-27 10:00:13======================== 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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2024-09-27 10:00:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2024-09-27 10:00:13======================== SELECT idx FROM macs WHERE mac_addr = '023B7B140261287010FD' AND app_code = '051' ========================2024-09-27 10:00:13======================== 값이 없을 경우 ========================2024-09-27 10:01:10======================== noteurl_start parm_app_code = 051 parm_pc_name = 20NB00026 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 023B7B140261287010FD sCDKey = 003401679376 sName = 20NB00026 ========================2024-09-27 10:01: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2024-09-27 10:01:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2024-09-27 10:01:10======================== SELECT idx FROM macs WHERE mac_addr = '023B7B140261287010FD' AND app_code = '051' ========================2024-09-27 10:01:10======================== 값이 없을 경우 ========================2024-09-27 10:04:21======================== noteurl_start parm_app_code = 051 parm_pc_name = 20NB00026 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 023B7B140261287010FD sCDKey = 003401679376 sName = 20NB00026 ========================2024-09-27 10:04: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2024-09-27 10:04:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2024-09-27 10:04:21======================== SELECT idx FROM macs WHERE mac_addr = '023B7B140261287010FD' AND app_code = '051' ========================2024-09-27 10:04:21======================== 값이 없을 경우 ========================2024-09-27 10:05:19======================== noteurl_start parm_app_code = 051 parm_pc_name = 20NB00026 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 023B7B140261287010FD sCDKey = 003401679376 sName = 20NB00026 ========================2024-09-27 10:05:19======================== 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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2024-09-27 10:05:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2024-09-27 10:05:19======================== SELECT idx FROM macs WHERE mac_addr = '023B7B140261287010FD' AND app_code = '051' ========================2024-09-27 10:05:19======================== 값이 없을 경우 ========================2024-09-27 14:17:58======================== noteurl_start parm_app_code = 051 parm_pc_name = 20NB00026 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 706655046317287010FD sCDKey = 003401679376 sName = 20NB00026 ========================2024-09-27 14:17:58======================== 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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2024-09-27 14:17:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2024-09-27 14:17:58======================== SELECT idx FROM macs WHERE mac_addr = '706655046317287010FD' AND app_code = '051' ========================2024-09-27 14:17:58======================== 값이 없을 경우 ========================2024-09-27 14:18:07======================== noteurl_start parm_app_code = 051 parm_pc_name = 20NB00026 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 706655046317287010FD sCDKey = 003401679376 sName = 20NB00026 ========================2024-09-27 14:18:07======================== 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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2024-09-27 14:18:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2024-09-27 14:18:07======================== SELECT idx FROM macs WHERE mac_addr = '706655046317287010FD' AND app_code = '051' ========================2024-09-27 14:18:07======================== 값이 없을 경우 ========================2024-09-27 14:19:23======================== noteurl_start parm_app_code = 051 parm_pc_name = 20NB00026 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 706655046317287010FD sCDKey = 003401679376 sName = 20NB00026 ========================2024-09-27 14:19: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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2024-09-27 14:19:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2024-09-27 14:19:23======================== SELECT idx FROM macs WHERE mac_addr = '706655046317287010FD' AND app_code = '051' ========================2024-09-27 14:19:23======================== 값이 없을 경우 ========================2024-09-27 14:21:24======================== noteurl_start parm_app_code = 051 parm_pc_name = 20NB00026 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 706655046317287010FD sCDKey = 003401679376 sName = 20NB00026 ========================2024-09-27 14:21:24======================== 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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2024-09-27 14:21:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skinfosec' ========================2024-09-27 14:21:24======================== SELECT idx FROM macs WHERE mac_addr = '706655046317287010FD' AND app_code = '051' ========================2024-09-27 14:21:24======================== 값이 없을 경우 ========================2024-09-27 16:19:34======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-COTNCFO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8BBC1DF02B9B6035710 sCDKey = 962572983389 sName = DESKTOP-COTNCFO ========================2024-09-27 16:19:34======================== 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 = '962572983389' AND r.app_code = '046' AND r.app_block = 0 ========================2024-09-27 16:19:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dongatoy7' ========================2024-09-27 16:19:34======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC1DF02B9B6035710' AND app_code = '046' ========================2024-09-27 16:19:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '411497' ========================2024-09-27 16:19:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '411497' ========================2024-09-27 16:19:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '411497', 'D8BBC1DF02B9B6035710', '046', 'DESKTOP-COTNCFO', '110', '1920', '1080', 'dongatoy7', '동아완구[윤대종]', '962572983389' ) ========================2024-09-27 16:44:58======================== noteurl_start parm_app_code = 047 parm_pc_name = WIN11-01 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CFDA15DD9EBC4DD991A sCDKey = 171544760033 sName = WIN11-01 ========================2024-09-27 16:44:58======================== 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 = '171544760033' AND r.app_code = '047' AND r.app_block = 0 ========================2024-09-27 16:44:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'diami' ========================2024-09-27 16:44:58======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15DD9EBC4DD991A' AND app_code = '047' ========================2024-09-27 16:44:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '411361' ========================2024-09-27 16:44:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '411361' ========================2024-09-27 16:44:58======================== UPDATE mac_detail SET pc_name = 'WIN11-01', os_type = '�쐢�룄�슦 10', user_id = 'diami', user_name = '(주)샤인위드[김미원]', screen_w = '0', screen_h = '0', cdkey = '171544760033' WHERE mac_idx = '411361' ========================2024-09-27 16:47:11======================== noteurl_start parm_app_code = 047 parm_pc_name = POS1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF73462EB24478B762 sCDKey = 171544760033 sName = POS1 ========================2024-09-27 16:47: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 = '171544760033' AND r.app_code = '047' AND r.app_block = 0 ========================2024-09-27 16:47:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'diami' ========================2024-09-27 16:47:11======================== SELECT idx FROM macs WHERE mac_addr = '50AF73462EB24478B762' AND app_code = '047' ========================2024-09-27 16:47:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '410949' ========================2024-09-27 16:47:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '410949' ========================2024-09-27 16:47:11======================== UPDATE mac_detail SET pc_name = 'POS1', os_type = '�쐢�룄�슦 10', user_id = 'diami', user_name = '(주)샤인위드[김미원]', screen_w = '0', screen_h = '0', cdkey = '171544760033' WHERE mac_idx = '410949'