========================2021-12-23 10:05:05======================== noteurl_start parm_app_code = 046 parm_pc_name = JSN11200502 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1594628E9863D760 sCDKey = 978058460342 sName = JSN11200502 ========================2021-12-23 10:05:05======================== 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 = '978058460342' AND r.app_code = '046' AND r.app_block = 0 ========================2021-12-23 10:05:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eunjib1020' ========================2021-12-23 10:05:05======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1594628E9863D760' AND app_code = '046' ========================2021-12-23 10:05:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356915' ========================2021-12-23 10:05:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356915' ========================2021-12-23 10:05:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '356915', 'A8A1594628E9863D760', '046', 'JSN11200502', '110', '1920', '1080', 'eunjib1020', '해태은진[송진호]', '978058460342' ) ========================2021-12-23 10:16:43======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 24F5AAAD55704463B463 sCDKey = 324153203620 sName = USER ========================2021-12-23 10:16:43======================== 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 = '324153203620' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-23 10:16:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjm6020' ========================2021-12-23 10:16:43======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAAD55704463B463' AND app_code = '039' ========================2021-12-23 10:16:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251054' ========================2021-12-23 10:16:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251054' ========================2021-12-23 10:16:43======================== UPDATE mac_detail SET pc_name = 'USER', os_type = '110', user_id = 'sjm6020', user_name = '남춘천크레인[박재균]', screen_w = '1440', screen_h = '900', cdkey = '324153203620' WHERE mac_idx = '251054' ========================2021-12-23 10:19:09======================== noteurl_start parm_app_code = 039 parm_pc_name = PC11 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3085A994CF91F294168E sCDKey = 513015286313 sName = PC11 ========================2021-12-23 10:19: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 = '513015286313' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-23 10:19:21======================== noteurl_start parm_app_code = 039 parm_pc_name = PC11 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3085A994CF91F294168E sCDKey = 513015286313 sName = PC11 ========================2021-12-23 10:19: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 = '513015286313' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-23 10:19:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'zw2211' ========================2021-12-23 10:19:21======================== SELECT idx FROM macs WHERE mac_addr = '3085A994CF91F294168E' AND app_code = '039' ========================2021-12-23 10:19:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356089' ========================2021-12-23 10:19:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356089' ========================2021-12-23 10:19:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '356089', '3085A994CF91F294168E', '039', 'PC11', '90', '1920', '1080', 'zw2211', '정원테크[라희주]', '513015286313' ) ========================2021-12-23 11:45:41======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-AUUGFB9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AF0E69D3BB8 sCDKey = 755061866111 sName = DESKTOP-AUUGFB9 ========================2021-12-23 11:45: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 = '755061866111' AND r.app_code = '046' AND r.app_block = 0 ========================2021-12-23 11:45:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hyein1127' ========================2021-12-23 11:45:41======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E69D3BB8' AND app_code = '046' ========================2021-12-23 11:45:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '349130' ========================2021-12-23 11:45:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '349130' ========================2021-12-23 11:45:41======================== UPDATE mac_detail SET pc_name = 'DESKTOP-AUUGFB9', os_type = '110', user_id = 'hyein1127', user_name = '[황혜인]', screen_w = '1920', screen_h = '1080', cdkey = '755061866111' WHERE mac_idx = '349130' ========================2021-12-23 13:56:10======================== noteurl_start parm_app_code = 039 parm_pc_name = YURA-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99812351A4A23ED1 sCDKey = 792270009777 sName = YURA-PC ========================2021-12-23 13:56: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 = '792270009777' AND r.app_code = '039' AND r.app_block = 0 ========================2021-12-23 13:56:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jk2014421' ========================2021-12-23 13:56:10======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99812351A4A23ED1' AND app_code = '039' ========================2021-12-23 13:56:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '356939' ========================2021-12-23 13:56:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '356939' ========================2021-12-23 13:56: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 ( '356939', 'B42E99812351A4A23ED1', '039', 'YURA-PC', '110', '1920', '1080', 'jk2014421', '제이케이디자인주식회사[인선희]', '792270009777' ) ========================2021-12-23 13:56:16======================== noteurl_start parm_app_code = 039 parm_pc_name = YURA-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99812351A4A23ED1 sCDKey = 792270009777 sName = YURA-PC ========================2021-12-23 13:56:16======================== 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 = '792270009777' AND r.app_code = '039' AND r.app_block = 0