========================2022-04-05 10:18:15======================== noteurl_start parm_app_code = 046 parm_pc_name = EVATION1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C707E30EA590C77 sCDKey = 519127891100 sName = EVATION1 ========================2022-04-05 10:18:15======================== 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 = '519127891100' AND r.app_code = '046' AND r.app_block = 0 ========================2022-04-05 10:32:31======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-L4LLJD1 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691FA00D6F6D89116 sCDKey = 049624493773 sName = DESKTOP-L4LLJD1 ========================2022-04-05 10:32:31======================== 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 = '049624493773' AND r.app_code = '051' AND r.app_block = 0 ========================2022-04-05 10:32:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdsoon0402' ========================2022-04-05 10:32:31======================== SELECT idx FROM macs WHERE mac_addr = '94C691FA00D6F6D89116' AND app_code = '051' ========================2022-04-05 10:32:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334003' ========================2022-04-05 10:32:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334003' ========================2022-04-05 10:32:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334003', '94C691FA00D6F6D89116', '051', 'DESKTOP-L4LLJD1', '109', '1920', '1080', 'kdsoon0402', '대전평생교육진흥원[대전평생교육진흥원]', '049624493773' ) ========================2022-04-05 10:42:44======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00E04C97C2E220251C2 sCDKey = 531412677223 sName = POS-PC ========================2022-04-05 10:42:44======================== 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 = '531412677223' AND r.app_code = '046' AND r.app_block = 0 ========================2022-04-05 10:42:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wonmusic' ========================2022-04-05 10:42:44======================== SELECT idx FROM macs WHERE mac_addr = '00E04C97C2E220251C2' AND app_code = '046' ========================2022-04-05 10:42:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '364608' ========================2022-04-05 10:42:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '364608' ========================2022-04-05 10:42:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '364608', '00E04C97C2E220251C2', '046', 'POS-PC', '90', '1024', '768', 'wonmusic', '원뮤직[함영옥]', '531412677223' ) ========================2022-04-05 15:15:58======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-4SV3P0BJ parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F4B30100726FCAF4FAFB sCDKey = 552775474875 sName = LAPTOP-4SV3P0BJ ========================2022-04-05 15:15: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 = '552775474875' AND r.app_code = '039' AND r.app_block = 0 ========================2022-04-05 15:15:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dsms130221' ========================2022-04-05 15:15:58======================== SELECT idx FROM macs WHERE mac_addr = 'F4B30100726FCAF4FAFB' AND app_code = '039' ========================2022-04-05 15:15:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '364631' ========================2022-04-05 15:15:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '364631' ========================2022-04-05 15:15: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 ( '364631', 'F4B30100726FCAF4FAFB', '039', 'LAPTOP-4SV3P0BJ', '110', '1536', '864', 'dsms130221', '대상물산[김인배]', '552775474875' ) ========================2022-04-05 16:41:09======================== noteurl_start parm_app_code = 051 parm_pc_name = GUYOUNGKIM parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389A27BD276FA6DA2 sCDKey = 144271475147 sName = GUYOUNGKIM ========================2022-04-05 16:41:09======================== 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 = '144271475147' AND r.app_code = '051' AND r.app_block = 0 ========================2022-04-05 16:41:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bavarian1' ========================2022-04-05 16:41:10======================== SELECT idx FROM macs WHERE mac_addr = '988389A27BD276FA6DA2' AND app_code = '051' ========================2022-04-05 16:41:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '364641' ========================2022-04-05 16:41:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '364641' ========================2022-04-05 16:41:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '364641', '988389A27BD276FA6DA2', '051', 'GUYOUNGKIM', '109', '1920', '1080', 'bavarian1', '바바리안모터스[김성근]', '144271475147' ) ========================2022-04-05 17:08:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RHVL1L8 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838940143BF8332091 sCDKey = 880547373888 sName = DESKTOP-RHVL1L8 ========================2022-04-05 17:08: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 = '880547373888' AND r.app_code = '039' AND r.app_block = 0 ========================2022-04-05 17:08:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onelife3' ========================2022-04-05 17:08:45======================== SELECT idx FROM macs WHERE mac_addr = '98838940143BF8332091' AND app_code = '039' ========================2022-04-05 17:08:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236760' ========================2022-04-05 17:08:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236760' ========================2022-04-05 17:08:45======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RHVL1L8', os_type = '110', user_id = 'onelife3', user_name = '[이영숙]', screen_w = '1920', screen_h = '1080', cdkey = '880547373888' WHERE mac_idx = '236760'