========================2024-01-29 10:22:26======================== noteurl_start parm_app_code = 039 parm_pc_name = 대명시스템공조 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C6B0019B4F758A87E68 sCDKey = 639589834082 sName = 대명시스템공조 ========================2024-01-29 10:22:26======================== 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 = '639589834082' AND r.app_code = '039' AND r.app_block = 0 ========================2024-01-29 10:22:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'abjkr47' ========================2024-01-29 10:22:26======================== SELECT idx FROM macs WHERE mac_addr = '9C6B0019B4F758A87E68' AND app_code = '039' ========================2024-01-29 10:22:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '400153' ========================2024-01-29 10:22:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '400153' ========================2024-01-29 10:22:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '400153', '9C6B0019B4F758A87E68', '039', '대명시스템공조', '110', '1920', '1080', 'abjkr47', '대명 시스템 공조[안병주]', '639589834082' ) ========================2024-01-29 10:33:52======================== noteurl_start parm_app_code = 039 parm_pc_name = COM01 parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 50B7C3AAE46DE718FC70 sCDKey = 720357298336 sName = COM01 ========================2024-01-29 10:33: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 = '720357298336' AND r.app_code = '039' AND r.app_block = 0 ========================2024-01-29 10:33:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'almoco7844' ========================2024-01-29 10:33:52======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AAE46DE718FC70' AND app_code = '039' ========================2024-01-29 10:33:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '400237' ========================2024-01-29 10:33:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '400237' ========================2024-01-29 10:33: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 ( '400237', '50B7C3AAE46DE718FC70', '039', 'COM01', '110', '1360', '768', 'almoco7844', '(주)알모코[배한숙]', '720357298336' )