========================2021-02-05 10:46:00======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-S0MVM12 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7420F4FC2E5F4F3D sCDKey = 300171682637 sName = DESKTOP-S0MVM12 ========================2021-02-05 10:46:00======================== 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 = '300171682637' AND r.app_code = '047' AND r.app_block = 0 ========================2021-02-05 10:46:12======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-S0MVM12 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7420F4FC2E5F4F3D sCDKey = 300171082637 sName = DESKTOP-S0MVM12 ========================2021-02-05 10:46: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 = '300171082637' AND r.app_code = '047' AND r.app_block = 0 ========================2021-02-05 10:47:24======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-S0MVM12 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7420F4FC2E5F4F3D sCDKey = 300171682637 sName = DESKTOP-S0MVM12 ========================2021-02-05 10:47:24======================== 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 = '300171682637' AND r.app_code = '047' AND r.app_block = 0 ========================2021-02-05 10:53:40======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-S0MVM12 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7420F4FC2E5F4F3D sCDKey = 300171682637 sName = DESKTOP-S0MVM12 ========================2021-02-05 10:53:40======================== 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 = '300171682637' AND r.app_code = '047' AND r.app_block = 0 ========================2021-02-05 10:54:24======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-S0MVM12 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7420F4FC2E5F4F3D sCDKey = 300171682637 sName = DESKTOP-S0MVM12 ========================2021-02-05 10:54:24======================== 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 = '300171682637' AND r.app_code = '047' AND r.app_block = 0 ========================2021-02-05 11:24:54======================== noteurl_start parm_app_code = 050 parm_pc_name = 관리부-PC parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A15953895CF411A0ED sCDKey = 358796420363 sName = 관리부-PC ========================2021-02-05 11:24:54======================== 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 = '358796420363' AND r.app_code = '050' AND r.app_block = 0 ========================2021-02-05 11:24:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'elecsco7' ========================2021-02-05 11:24:54======================== SELECT idx FROM macs WHERE mac_addr = 'A8A15953895CF411A0ED' AND app_code = '050' ========================2021-02-05 11:24:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336510' ========================2021-02-05 11:24:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '336510' ========================2021-02-05 11:24:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '336510', 'A8A15953895CF411A0ED', '050', '관리부-PC', '109', '1920', '1080', 'elecsco7', '(주)일렉스[박재룡]', '358796420363' ) ========================2021-02-05 15:03:06======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6F7910AE33FA8 sCDKey = 883382762416 sName = SAMSUNG-PC ========================2021-02-05 15:03: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 = '883382762416' AND r.app_code = '039' AND r.app_block = 0 ========================2021-02-05 15:03:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'olum5186' ========================2021-02-05 15:03:06======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6F7910AE33FA8' AND app_code = '039' ========================2021-02-05 15:03:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '336535' ========================2021-02-05 15:03:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '336535' ========================2021-02-05 15:03:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '336535', 'E8039A6F7910AE33FA8', '039', 'SAMSUNG-PC', '90', '1920', '1080', 'olum5186', '제주오름수산[이웅희]', '883382762416' ) ========================2021-02-05 17:10:46======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GO8STMH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E902FF976DBC9E9 sCDKey = 342918991698 sName = DESKTOP-GO8STMH ========================2021-02-05 17:10:46======================== 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 = '342918991698' AND r.app_code = '046' AND r.app_block = 0 ========================2021-02-05 17:10:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jun9317718' ========================2021-02-05 17:10:46======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E902FF976DBC9E9' AND app_code = '046' ========================2021-02-05 17:10:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313008' ========================2021-02-05 17:10:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313008' ========================2021-02-05 17:10:46======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GO8STMH', os_type = '110', user_id = 'jun9317718', user_name = '한농연농자재영농조합법인[전종석]', screen_w = '1920', screen_h = '1080', cdkey = '342918991698' WHERE mac_idx = '313008'