========================2021-04-28 09:25:45======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-HR6KUMA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99416E38828DEC9B sCDKey = 678114550550 sName = DESKTOP-HR6KUMA ========================2021-04-28 09:25:45======================== 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 = '678114550550' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-28 09:25:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksb7925' ========================2021-04-28 09:25:45======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99416E38828DEC9B' AND app_code = '047' ========================2021-04-28 09:25:45======================== 값이 없을 경우 ========================2021-04-28 09:27:02======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-HR6KUMA parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99416E38828DEC9B sCDKey = 678114550550 sName = DESKTOP-HR6KUMA ========================2021-04-28 09:27: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 = '678114550550' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-28 09:27:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksb7925' ========================2021-04-28 09:27:02======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99416E38828DEC9B' AND app_code = '047' ========================2021-04-28 09:27:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342110' ========================2021-04-28 09:27:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342110' ========================2021-04-28 09:27: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 ( '342110', 'B42E99416E38828DEC9B', '047', 'DESKTOP-HR6KUMA', '�쐢�룄�슦 10', '0', '0', 'ksb7925', '(주)디앤유[고성배]', '678114550550' ) ========================2021-04-28 11:38:48======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E0D55E64ABDBD61CD5DD sCDKey = 590563984562 sName = OFFICE ========================2021-04-28 11:38: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 = '590563984562' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-28 11:38:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rnrwls0726' ========================2021-04-28 11:38:48======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E64ABDBD61CD5DD' AND app_code = '039' ========================2021-04-28 11:38:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342132' ========================2021-04-28 11:38:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342132' ========================2021-04-28 11:38:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '342132', 'E0D55E64ABDBD61CD5DD', '039', 'OFFICE', '110', '1600', '900', 'rnrwls0726', '의성정밀[변국진]', '590563984562' ) ========================2021-04-28 17:13:52======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-520FI8H parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E9999679AF2EC4AAF sCDKey = 670839643191 sName = DESKTOP-520FI8H ========================2021-04-28 17:13:52======================== 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 = '670839643191' AND r.app_code = '048' AND r.app_block = 0 ========================2021-04-28 17:13:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nok0401' ========================2021-04-28 17:13:52======================== SELECT idx FROM macs WHERE mac_addr = 'B42E9999679AF2EC4AAF' AND app_code = '048' ========================2021-04-28 17:13:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '342181' ========================2021-04-28 17:13:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '342181' ========================2021-04-28 17:13:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '342181', 'B42E9999679AF2EC4AAF', '048', 'DESKTOP-520FI8H', '�쐢�룄�슦 10', '0', '0', 'nok0401', '뉴원-K[이동규]', '670839643191' )