========================2024-12-16 10:21:22======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-6H4I7AL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B52012DD397AA3083B sCDKey = 678246845474 sName = DESKTOP-6H4I7AL ========================2024-12-16 10:21: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 = '678246845474' AND r.app_code = '046' AND r.app_block = 0 ========================2024-12-16 10:21:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'anbinnakdo' ========================2024-12-16 10:21:22======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52012DD397AA3083B' AND app_code = '046' ========================2024-12-16 10:21:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414824' ========================2024-12-16 10:21:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '414824' ========================2024-12-16 10:21: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 ( '414824', 'F4B52012DD397AA3083B', '046', 'DESKTOP-6H4I7AL', '110', '1920', '1080', 'anbinnakdo', '마니푸드[박현석]', '678246845474' ) ========================2024-12-16 11:05:03======================== noteurl_start parm_app_code = 047 parm_pc_name = 원진2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B79F53BCF5C6D0 sCDKey = 769778698282 sName = 원진2 ========================2024-12-16 11:05:03======================== 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 = '769778698282' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-16 11:05:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tj0989' ========================2024-12-16 11:05:03======================== SELECT idx FROM macs WHERE mac_addr = '581122B79F53BCF5C6D0' AND app_code = '047' ========================2024-12-16 11:05:03======================== 값이 없을 경우 ========================2024-12-16 11:05:41======================== noteurl_start parm_app_code = 047 parm_pc_name = 원진2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B79F53BCF5C6D0 sCDKey = 769778698282 sName = 원진2 ========================2024-12-16 11:05: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 = '769778698282' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-16 11:05:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tj0989' ========================2024-12-16 11:05:42======================== SELECT idx FROM macs WHERE mac_addr = '581122B79F53BCF5C6D0' AND app_code = '047' ========================2024-12-16 11:05:42======================== 값이 없을 경우 ========================2024-12-16 11:08:00======================== noteurl_start parm_app_code = 047 parm_pc_name = 원진2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B79F53BCF5C6D0 sCDKey = 769778698282 sName = 원진2 ========================2024-12-16 11:08:00======================== 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 = '769778698282' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-16 11:08:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tj0989' ========================2024-12-16 11:08:00======================== SELECT idx FROM macs WHERE mac_addr = '581122B79F53BCF5C6D0' AND app_code = '047' ========================2024-12-16 11:08:00======================== 값이 없을 경우 ========================2024-12-16 11:08:35======================== noteurl_start parm_app_code = 047 parm_pc_name = 원진2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B79F53BCF5C6D0 sCDKey = 769778698282 sName = 원진2 ========================2024-12-16 11:08: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 = '769778698282' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-16 11:08:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tj0989' ========================2024-12-16 11:08:35======================== SELECT idx FROM macs WHERE mac_addr = '581122B79F53BCF5C6D0' AND app_code = '047' ========================2024-12-16 11:08:35======================== 값이 없을 경우 ========================2024-12-16 11:13:36======================== noteurl_start parm_app_code = 047 parm_pc_name = 원진2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B79F53BCF5C6D0 sCDKey = 769778698282 sName = 원진2 ========================2024-12-16 11:13:36======================== 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 = '769778698282' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-16 11:13:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tj0989' ========================2024-12-16 11:13:37======================== SELECT idx FROM macs WHERE mac_addr = '581122B79F53BCF5C6D0' AND app_code = '047' ========================2024-12-16 11:13:37======================== 값이 없을 경우 ========================2024-12-16 11:20:45======================== noteurl_start parm_app_code = 047 parm_pc_name = 원진2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122B79F53BCF5C6D0 sCDKey = 769778698282 sName = 원진2 ========================2024-12-16 11:20: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 = '769778698282' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-16 11:20:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tj0989' ========================2024-12-16 11:20:46======================== SELECT idx FROM macs WHERE mac_addr = '581122B79F53BCF5C6D0' AND app_code = '047' ========================2024-12-16 11:20:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414829' ========================2024-12-16 11:20:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '414829' ========================2024-12-16 11:20:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '414829', '581122B79F53BCF5C6D0', '047', '원진2', '�쐢�룄�슦 10', '0', '0', 'tj0989', '(주)태진산업[조해원]', '769778698282' ) ========================2024-12-16 11:27:52======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GK9HLTD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CCBBE6D2EB9D66C sCDKey = 502265866049 sName = DESKTOP-GK9HLTD ========================2024-12-16 11:27:52======================== 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 = '502265866049' AND r.app_code = '046' AND r.app_block = 0 ========================2024-12-16 11:27:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hch2860' ========================2024-12-16 11:27:52======================== SELECT idx FROM macs WHERE mac_addr = '408D5CCBBE6D2EB9D66C' AND app_code = '046' ========================2024-12-16 11:27:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '391842' ========================2024-12-16 11:27:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '391842' ========================2024-12-16 11:27:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '391842', '408D5CCBBE6D2EB9D66C', '046', 'DESKTOP-GK9HLTD', '110', '1920', '1080', 'hch2860', '주식회사 뜰아래[한철희]', '502265866049' ) ========================2024-12-16 12:31:52======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-BHC510C parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0D55E5055616A569C62 sCDKey = 769778698282 sName = DESKTOP-BHC510C ========================2024-12-16 12:31:52======================== 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 = '769778698282' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-16 12:31:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tj0989' ========================2024-12-16 12:31:52======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E5055616A569C62' AND app_code = '047' ========================2024-12-16 12:31:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414836' ========================2024-12-16 12:31:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '414836' ========================2024-12-16 12:31:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '414836', 'E0D55E5055616A569C62', '047', 'DESKTOP-BHC510C', '�쐢�룄�슦 10', '0', '0', 'tj0989', '(주)태진산업[조해원]', '769778698282' ) ========================2024-12-16 13:55:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-1PRTL29 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2D634BAEC3378F2 sCDKey = 620618697812 sName = DESKTOP-1PRTL29 ========================2024-12-16 13:55: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 = '620618697812' AND r.app_code = '046' AND r.app_block = 0 ========================2024-12-16 13:55:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k4074356' ========================2024-12-16 13:55:55======================== SELECT idx FROM macs WHERE mac_addr = '7085C2D634BAEC3378F2' AND app_code = '046' ========================2024-12-16 13:55:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '414842' ========================2024-12-16 13:55:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '414842' ========================2024-12-16 13:55:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '414842', '7085C2D634BAEC3378F2', '046', 'DESKTOP-1PRTL29', '110', '1920', '1080', 'k4074356', '주식회사배관공구24시[김귀한]', '620618697812' ) ========================2024-12-16 16:54:34======================== noteurl_start parm_app_code = 046 parm_pc_name = LSW-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AF0E742B96BD sCDKey = 659189021114 sName = LSW-PC ========================2024-12-16 16:54: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 = '659189021114' AND r.app_code = '046' AND r.app_block = 0 ========================2024-12-16 16:54:53======================== noteurl_start parm_app_code = 046 parm_pc_name = LSW-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AF0E742B96BD sCDKey = 659189021114 sName = LSW-PC ========================2024-12-16 16:54: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 = '659189021114' AND r.app_code = '046' AND r.app_block = 0 ========================2024-12-16 16:54:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hn53' ========================2024-12-16 16:54:53======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E742B96BD' AND app_code = '046' ========================2024-12-16 16:54:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '401203' ========================2024-12-16 16:54:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '401203' ========================2024-12-16 16:54:53======================== UPDATE mac_detail SET pc_name = 'LSW-PC', os_type = '110', user_id = 'hn53', user_name = '[이선우]', screen_w = '1920', screen_h = '1080', cdkey = '659189021114' WHERE mac_idx = '401203'