========================2020-09-21 09:08:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0KPC parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B42E99B0B2B9EAC7695A sCDKey = 203810624338 sName = DESKTOP-0KPC ========================2020-09-21 09:08:13======================== 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 = '203810624338' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-21 09:08:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yey1755' ========================2020-09-21 09:08:13======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99B0B2B9EAC7695A' AND app_code = '039' ========================2020-09-21 09:08:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326626' ========================2020-09-21 09:08:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '326626' ========================2020-09-21 09:08:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '326626', 'B42E99B0B2B9EAC7695A', '039', 'DESKTOP-0KPC', '110', '1680', '1050', 'yey1755', '(유)무주철강골재[이은영]', '203810624338' ) ========================2020-09-21 10:31:42======================== noteurl_start parm_app_code = 046 parm_pc_name = WINDOWS-DK7THEF parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = BC5FF4DF4E56CCB87DEB sCDKey = 021095732276 sName = WINDOWS-DK7THEF ========================2020-09-21 10:31:42======================== 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 = '021095732276' AND r.app_code = '046' AND r.app_block = 0 ========================2020-09-21 10:31:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'manyeon4217' ========================2020-09-21 10:31:42======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4DF4E56CCB87DEB' AND app_code = '046' ========================2020-09-21 10:31:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326596' ========================2020-09-21 10:31:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '326596' ========================2020-09-21 10:31:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '326596', 'BC5FF4DF4E56CCB87DEB', '046', 'WINDOWS-DK7THEF', '90', '1680', '1050', 'manyeon4217', '만연종합유통[김균태]', '021095732276' ) ========================2020-09-21 13:42:03======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B341AEFA5AEEAC82D sCDKey = 513019903755 sName = WIN7-PC ========================2020-09-21 13:42: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 = '513019903755' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-21 13:42:29======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B341AEFA5AEEAC82D sCDKey = 513019903755 sName = DESKTOP-ICA2 ========================2020-09-21 13:42: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 = '513019903755' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-21 14:43:28======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TSIO1U3 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A4C3F0759B94C43CB1DC sCDKey = 230362309828 sName = DESKTOP-TSIO1U3 ========================2020-09-21 14:43: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 = '230362309828' AND r.app_code = '047' AND r.app_block = 0 ========================2020-09-21 14:43:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jclocal' ========================2020-09-21 14:43:28======================== SELECT idx FROM macs WHERE mac_addr = 'A4C3F0759B94C43CB1DC' AND app_code = '047' ========================2020-09-21 14:43:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307171' ========================2020-09-21 14:43:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '307171' ========================2020-09-21 14:43:28======================== UPDATE mac_detail SET pc_name = 'DESKTOP-TSIO1U3', os_type = '�쐢�룄�슦 10', user_id = 'jclocal', user_name = '제천로컬푸드협동조합[김현주]', screen_w = '0', screen_h = '0', cdkey = '230362309828' WHERE mac_idx = '307171' ========================2020-09-21 15:23:23======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B341AEFA5AEEAC82D sCDKey = 513019903755 sName = WIN7-PC ========================2020-09-21 15:23: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 = '513019903755' AND r.app_code = '039' AND r.app_block = 0 ========================2020-09-21 15:23:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ghddang292' ========================2020-09-21 15:23:23======================== SELECT idx FROM macs WHERE mac_addr = '902B341AEFA5AEEAC82D' AND app_code = '039' ========================2020-09-21 15:23:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '326584' ========================2020-09-21 15:23:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '326584' ========================2020-09-21 15:23: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 ( '326584', '902B341AEFA5AEEAC82D', '039', 'WIN7-PC', '90', '1920', '1080', 'ghddang292', '구커피[이규희]', '513019903755' )