========================2021-05-11 11:22:54======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-BI01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC73327728DF2 sCDKey = 409643186656 sName = WIN-BI01 ========================2021-05-11 11:22: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 = '409643186656' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-11 11:23:37======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-BI01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC73327728DF2 sCDKey = 409643186656 sName = WIN-BI01 ========================2021-05-11 11:23:37======================== 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 = '409643186656' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-11 11:24:58======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-BI01 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AC73327728DF2 sCDKey = 409643186656 sName = WIN-BI01 ========================2021-05-11 11:24: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 = '409643186656' AND r.app_code = '046' AND r.app_block = 0 ========================2021-05-11 11:24:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs445' ========================2021-05-11 11:24:59======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AC73327728DF2' AND app_code = '046' ========================2021-05-11 11:24:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '176304' ========================2021-05-11 11:24:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '176304' ========================2021-05-11 11:24:59======================== UPDATE mac_detail SET pc_name = 'WIN-BI01', os_type = '64', user_id = 'bs445', user_name = '부일수산[부산지사]', screen_w = '1024', screen_h = '768', cdkey = '409643186656' WHERE mac_idx = '176304' ========================2021-05-11 14:10:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SESQJNM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 708BCD53E8CA4A0BD9BA sCDKey = 519302905301 sName = DESKTOP-SESQJNM ========================2021-05-11 14:10:49======================== 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 = '519302905301' AND r.app_code = '039' AND r.app_block = 0 ========================2021-05-11 14:10:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dogsuly' ========================2021-05-11 14:10:49======================== SELECT idx FROM macs WHERE mac_addr = '708BCD53E8CA4A0BD9BA' AND app_code = '039' ========================2021-05-11 14:10:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343049' ========================2021-05-11 14:10:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343049' ========================2021-05-11 14:10:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '343049', '708BCD53E8CA4A0BD9BA', '039', 'DESKTOP-SESQJNM', '110', '1920', '1080', 'dogsuly', '통일정밀[유재열]', '519302905301' )