========================2023-11-13 09:19:08======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-231113 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B0416F0C730BE0FD6639 sCDKey = 975677425073 sName = POS2-231113 ========================2023-11-13 09:19:08======================== 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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2023-11-13 09:19:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2023-11-13 09:19:08======================== SELECT idx FROM macs WHERE mac_addr = 'B0416F0C730BE0FD6639' AND app_code = '046' ========================2023-11-13 09:19:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '396103' ========================2023-11-13 09:19:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '396103' ========================2023-11-13 09:19:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '396103', 'B0416F0C730BE0FD6639', '046', 'POS2-231113', '110', '1024', '768', 'ami2881', '아미상사[이재훈]', '975677425073' ) ========================2023-11-13 10:11:32======================== noteurl_start parm_app_code = 047 parm_pc_name = 콜센터5 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F7414EE1DF294DE36 sCDKey = 278126570271 sName = 콜센터3 ========================2023-11-13 10:11:32======================== 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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2023-11-13 10:11:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2023-11-13 10:11:32======================== SELECT idx FROM macs WHERE mac_addr = 'F02F7414EE1DF294DE36' AND app_code = '047' ========================2023-11-13 10:11:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '359327' ========================2023-11-13 10:11:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '359327' ========================2023-11-13 10:11:32======================== UPDATE mac_detail SET pc_name = '콜센터3', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '359327' ========================2023-11-13 10:14:59======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NRI9392 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C6B0019B4F71C345D9A sCDKey = 639589834082 sName = DESKTOP-NRI9392 ========================2023-11-13 10:14:59======================== 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 ========================2023-11-13 10:14:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'abjkr47' ========================2023-11-13 10:14:59======================== SELECT idx FROM macs WHERE mac_addr = '9C6B0019B4F71C345D9A' AND app_code = '039' ========================2023-11-13 10:14:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '396071' ========================2023-11-13 10:14:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '396071' ========================2023-11-13 10:14:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '396071', '9C6B0019B4F71C345D9A', '039', 'DESKTOP-NRI9392', '110', '1920', '1080', 'abjkr47', '대명 시스템 공조[안병주]', '639589834082' ) ========================2023-11-13 13:02:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-B2NDK23 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 047C16DA32D5B04A453F sCDKey = 559191818720 sName = DESKTOP-B2NDK23 ========================2023-11-13 13:02: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 = '559191818720' AND r.app_code = '039' AND r.app_block = 0 ========================2023-11-13 13:02:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'armyman127' ========================2023-11-13 13:02:48======================== SELECT idx FROM macs WHERE mac_addr = '047C16DA32D5B04A453F' AND app_code = '039' ========================2023-11-13 13:02:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '396117' ========================2023-11-13 13:02:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '396117' ========================2023-11-13 13:02: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 ( '396117', '047C16DA32D5B04A453F', '039', 'DESKTOP-B2NDK23', '110', '1920', '1080', 'armyman127', '진성공업[김진철]', '559191818720' )