========================2023-07-17 11:20:11======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = B42E99D034C5BC2DBE12 sCDKey = 169591860148 sName = YANGJK ========================2023-07-17 11:20: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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2023-07-17 11:20:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjss064' ========================2023-07-17 11:20:11======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99D034C5BC2DBE12' AND app_code = '046' ========================2023-07-17 11:20:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '321015' ========================2023-07-17 11:20:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '321015' ========================2023-07-17 11:20:11======================== UPDATE mac_detail SET pc_name = 'YANGJK', os_type = '90', user_id = 'hjss064', user_name = '형제상사주식회사[양진규]', screen_w = '2560', screen_h = '1440', cdkey = '169591860148' WHERE mac_idx = '321015' ========================2023-07-17 14:12:29======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-AAANAMC parm_os_type = 109 parm_screen_w = 2048 parm_screen_h = 1152 parm_user_mac = A036BC587B696C3035B1 sCDKey = 466597956979 sName = DESKTOP-AAANAMC ========================2023-07-17 14: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 = '466597956979' AND r.app_code = '050' AND r.app_block = 0 ========================2023-07-17 14:12:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksl22' ========================2023-07-17 14:12:29======================== SELECT idx FROM macs WHERE mac_addr = 'A036BC587B696C3035B1' AND app_code = '050' ========================2023-07-17 14:12:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390753' ========================2023-07-17 14:12:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390753' ========================2023-07-17 14: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 ( '390753', 'A036BC587B696C3035B1', '050', 'DESKTOP-AAANAMC', '109', '2048', '1152', 'ksl22', '비스텔[이권수]', '466597956979' ) ========================2023-07-17 14:38:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6ET2O6U parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 982CBCC5BC55ECF9E43E sCDKey = 151317336230 sName = DESKTOP-6ET2O6U ========================2023-07-17 14:38:37======================== 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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-17 14:38:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yessal' ========================2023-07-17 14:38:38======================== SELECT idx FROM macs WHERE mac_addr = '982CBCC5BC55ECF9E43E' AND app_code = '039' ========================2023-07-17 14:38:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390710' ========================2023-07-17 14:38:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390710' ========================2023-07-17 14:38:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '390710', '982CBCC5BC55ECF9E43E', '039', 'DESKTOP-6ET2O6U', '110', '1536', '864', 'yessal', '제이에스테크[심재섭]', '151317336230' ) ========================2023-07-17 16:43:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-TPPKET3 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 18C04DC28D6550E3FB34 sCDKey = 550549105676 sName = DESKTOP-TPPKET3 ========================2023-07-17 16:43:33======================== 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 = '550549105676' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-17 16:43:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhdmf214' ========================2023-07-17 16:43:33======================== SELECT idx FROM macs WHERE mac_addr = '18C04DC28D6550E3FB34' AND app_code = '039' ========================2023-07-17 16:43:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359803' ========================2023-07-17 16:43:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359803' ========================2023-07-17 16:43:33======================== UPDATE mac_detail SET pc_name = 'DESKTOP-TPPKET3', os_type = '110', user_id = 'rhdmf214', user_name = '주)주은실업[김상호]', screen_w = '1366', screen_h = '768', cdkey = '550549105676' WHERE mac_idx = '359803' ========================2023-07-17 18:17:58======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-OO5T90R parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1C1B0D178E15AED34EC8 sCDKey = 319243365467 sName = DESKTOP-OO5T90R ========================2023-07-17 18: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 = '319243365467' AND r.app_code = '046' AND r.app_block = 0 ========================2023-07-17 18:17:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk0909' ========================2023-07-17 18:17:58======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D178E15AED34EC8' AND app_code = '046' ========================2023-07-17 18:17:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390773' ========================2023-07-17 18:17:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390773' ========================2023-07-17 18:17:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '390773', '1C1B0D178E15AED34EC8', '046', 'DESKTOP-OO5T90R', '110', '1680', '1050', 'kyk0909', '동양종합식품[김영국]', '319243365467' ) ========================2023-07-17 18:27:50======================== noteurl_start parm_app_code = 046 parm_pc_name = POS3 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E840F24627C626AF6234 sCDKey = 319243365467 sName = POS3 ========================2023-07-17 18:27: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 = '319243365467' AND r.app_code = '046' AND r.app_block = 0 ========================2023-07-17 18:27:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk0909' ========================2023-07-17 18:27:50======================== SELECT idx FROM macs WHERE mac_addr = 'E840F24627C626AF6234' AND app_code = '046' ========================2023-07-17 18:27:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '232399' ========================2023-07-17 18:27:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '232399' ========================2023-07-17 18:27:50======================== UPDATE mac_detail SET pc_name = 'POS3', os_type = '90', user_id = 'kyk0909', user_name = '동양종합식품[김영국]', screen_w = '1600', screen_h = '900', cdkey = '319243365467' WHERE mac_idx = '232399' ========================2023-07-17 18:45:28======================== noteurl_start parm_app_code = 046 parm_pc_name = SERVER parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E0D55E03E58E26AF6234 sCDKey = 319243365467 sName = SERVER ========================2023-07-17 18:45: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 = '319243365467' AND r.app_code = '046' AND r.app_block = 0 ========================2023-07-17 18:45:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk0909' ========================2023-07-17 18:45:28======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E03E58E26AF6234' AND app_code = '046' ========================2023-07-17 18:45:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '232384' ========================2023-07-17 18:45:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '232384' ========================2023-07-17 18:45:28======================== UPDATE mac_detail SET pc_name = 'SERVER', os_type = '90', user_id = 'kyk0909', user_name = '동양종합식품[김영국]', screen_w = '1600', screen_h = '900', cdkey = '319243365467' WHERE mac_idx = '232384'