========================2020-01-28 09:27:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 00E063342D9CE2C0FB68 sCDKey = 513172174132 sName = DESKTOP ========================2020-01-28 09:27:12======================== 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 = '513172174132' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 09:27:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'marutapjs' ========================2020-01-28 09:27:12======================== SELECT idx FROM macs WHERE mac_addr = '00E063342D9CE2C0FB68' AND app_code = '039' ========================2020-01-28 09:27:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308987' ========================2020-01-28 09:27:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308987' ========================2020-01-28 09:27:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308987', '00E063342D9CE2C0FB68', '039', 'DESKTOP', '110', '1600', '900', 'marutapjs', '두영상사[팽종술]', '513172174132' ) ========================2020-01-28 09:58:25======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3052CB5082E75840AA52 sCDKey = 435708278063 sName = SEC-PC ========================2020-01-28 09:58:25======================== 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 = '435708278063' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 09:58:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sambodb' ========================2020-01-28 09:58:25======================== SELECT idx FROM macs WHERE mac_addr = '3052CB5082E75840AA52' AND app_code = '039' ========================2020-01-28 09:58:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '309094' ========================2020-01-28 09:58:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '309094' ========================2020-01-28 09:58:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '309094', '3052CB5082E75840AA52', '039', 'SEC-PC', '90', '1920', '1080', 'sambodb', '지엠전자통신[권철호]', '435708278063' ) ========================2020-01-28 15:13:17======================== noteurl_start parm_app_code = 039 parm_pc_name = USERA-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDF416E99A89C133 sCDKey = 545441335904 sName = USERA-PC ========================2020-01-28 15:13:17======================== 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 = '545441335904' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 15:13:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'vv09' ========================2020-01-28 15:13:17======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDF416E99A89C133' AND app_code = '039' ========================2020-01-28 15:13:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '309138' ========================2020-01-28 15:13:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '309138' ========================2020-01-28 15:13:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '309138', 'B8AEEDF416E99A89C133', '039', 'USERA-PC', '90', '1920', '1080', 'vv09', '영동유업[김은해]', '545441335904' ) ========================2020-01-28 16:15:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GLD3FB5 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 408D5CD399402E5A307A sCDKey = 680774956654 sName = DESKTOP-GLD3FB5 ========================2020-01-28 16:15: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 = '680774956654' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 16:15:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'in4847' ========================2020-01-28 16:15:45======================== SELECT idx FROM macs WHERE mac_addr = '408D5CD399402E5A307A' AND app_code = '039' ========================2020-01-28 16:15:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '309120' ========================2020-01-28 16:15:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '309120' ========================2020-01-28 16:15:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '309120', '408D5CD399402E5A307A', '039', 'DESKTOP-GLD3FB5', '110', '1920', '1200', 'in4847', '인기획[윤인희]', '680774956654' ) ========================2020-01-28 17:54:57======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59EC736FA sCDKey = 337888468455 sName = HSCHANG-N ========================2020-01-28 17:54:57======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 17:55:48======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59EC736FA sCDKey = 337888468455 sName = chs1080 ========================2020-01-28 17:55:48======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 17:56:22======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59EC736FA sCDKey = 337888468455 sName = HSCHANG-N ========================2020-01-28 17:56:22======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 18:03:10======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59EC736FA sCDKey = 337888468455 sName = HSCHANG-N ========================2020-01-28 18:03: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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 18:41:02======================== noteurl_start parm_app_code = 039 parm_pc_name = HSCHANG-N parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F29AF59EC736FA sCDKey = 337888468455 sName = HSCHANG-N ========================2020-01-28 18:41:02======================== 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 = '337888468455' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-28 18:41:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chs1080' ========================2020-01-28 18:41:02======================== SELECT idx FROM macs WHERE mac_addr = 'F8633F29AF59EC736FA' AND app_code = '039' ========================2020-01-28 18:41:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241380' ========================2020-01-28 18:41:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241380' ========================2020-01-28 18:41:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241380', 'F8633F29AF59EC736FA', '039', 'HSCHANG-N', '110', '1536', '864', 'chs1080', '장형석[장형석]', '337888468455' )