========================2020-06-26 09:06:57======================== noteurl_start parm_app_code = 047 parm_pc_name = Workstation parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18C04D212A6F73DE091F sCDKey = 278112997938 sName = Workstation ========================2020-06-26 09:06: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 = '278112997938' AND r.app_code = '047' AND r.app_block = 0 ========================2020-06-26 09:06:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ppple1' ========================2020-06-26 09:06:57======================== SELECT idx FROM macs WHERE mac_addr = '18C04D212A6F73DE091F' AND app_code = '047' ========================2020-06-26 09:06:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320548' ========================2020-06-26 09:06:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320548' ========================2020-06-26 09:06:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320548', '18C04D212A6F73DE091F', '047', 'Workstation', '�쐢�룄�슦 10', '0', '0', 'ppple1', '영기수산[박영기]', '278112997938' ) ========================2020-06-26 11:14:57======================== noteurl_start parm_app_code = 047 parm_pc_name = 우리종합상사-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 842B2BA871DA8C3FEF5B sCDKey = 251807600224 sName = 우리종합상사-PC ========================2020-06-26 11:14: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 = '251807600224' AND r.app_code = '047' AND r.app_block = 0 ========================2020-06-26 11:14:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jjjjjanng' ========================2020-06-26 11:14:57======================== SELECT idx FROM macs WHERE mac_addr = '842B2BA871DA8C3FEF5B' AND app_code = '047' ========================2020-06-26 11:14:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257747' ========================2020-06-26 11:14:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257747' ========================2020-06-26 11:14:57======================== UPDATE mac_detail SET pc_name = '우리종합상사-PC', os_type = '�쐢�룄�슦 7', user_id = 'jjjjjanng', user_name = '우리종합상사[장민규]', screen_w = '0', screen_h = '0', cdkey = '251807600224' WHERE mac_idx = '257747' ========================2020-06-26 14:48:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-45SOOM2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA144C4B96C042FFAB sCDKey = 204297080946 sName = 2층 ========================2020-06-26 14:48:35======================== 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 = '204297080946' AND r.app_code = '047' AND r.app_block = 0 ========================2020-06-26 14:48:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ulsanwood' ========================2020-06-26 14:48:35======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA144C4B96C042FFAB' AND app_code = '047' ========================2020-06-26 14:48:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320585' ========================2020-06-26 14:48:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320585' ========================2020-06-26 14:48:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320585', 'FCAA144C4B96C042FFAB', '047', '2층', '�쐢�룄�슦 10', '0', '0', 'ulsanwood', '연암철물공구종합상사[박동진]', '204297080946' )