========================2021-04-20 10:26:06======================== noteurl_start parm_app_code = 045 parm_pc_name = KCG-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D304C7862A6138453 sCDKey = 650376832061 sName = KCG-PC ========================2021-04-20 10:26:06======================== 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 = '650376832061' AND r.app_code = '045' AND r.app_block = 0 ========================2021-04-20 10:26:23======================== noteurl_start parm_app_code = 045 parm_pc_name = KCG-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D304C7862A6138453 sCDKey = 650376832061 sName = KCG-PC ========================2021-04-20 10:26: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 = '650376832061' AND r.app_code = '045' AND r.app_block = 0 ========================2021-04-20 10:26:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gyu1001' ========================2021-04-20 10:26:23======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304C7862A6138453' AND app_code = '045' ========================2021-04-20 10:26:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340231' ========================2021-04-20 10:26:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340231' ========================2021-04-20 10:26:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '340231', 'F44D304C7862A6138453', '045', 'KCG-PC', '110', '1920', '1080', 'gyu1001', '창규식품[권창규]', '650376832061' ) ========================2021-04-20 10:57:56======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF733795ABEE2B1141 sCDKey = 284617210806 sName = DESKTOP-IR4BE71 ========================2021-04-20 10:57:56======================== 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 = '284617210806' AND r.app_code = '046' AND r.app_block = 0 ========================2021-04-20 10:57:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samyang3446' ========================2021-04-20 10:57:56======================== SELECT idx FROM macs WHERE mac_addr = '50AF733795ABEE2B1141' AND app_code = '046' ========================2021-04-20 10:57:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '341518' ========================2021-04-20 10:57:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '341518' ========================2021-04-20 10:57:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '341518', '50AF733795ABEE2B1141', '046', 'DESKTOP-IR4BE71', '110', '1024', '768', 'samyang3446', '삼양상사[김명순]', '284617210806' ) ========================2021-04-20 11:43:34======================== noteurl_start parm_app_code = 047 parm_pc_name = OWNER-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0CA94A4C3540893C86A sCDKey = 840621804320 sName = OWNER-PC ========================2021-04-20 11:43: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 = '840621804320' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-20 11:43:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ecofarm89' ========================2021-04-20 11:43:35======================== SELECT idx FROM macs WHERE mac_addr = 'E0CA94A4C3540893C86A' AND app_code = '047' ========================2021-04-20 11:43:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '341525' ========================2021-04-20 11:43:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '341525' ========================2021-04-20 11:43: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 ( '341525', 'E0CA94A4C3540893C86A', '047', 'OWNER-PC', '�쐢�룄�슦 7', '0', '0', 'ecofarm89', ' 사료창고[석지훈]', '840621804320' )