========================2022-12-23 12:59:31======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-146PCA6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 047C163E5E34CB5D26C sCDKey = 650377547494 sName = DESKTOP-146PCA6 ========================2022-12-23 12:59:31======================== 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 = '650377547494' AND r.app_code = '046' AND r.app_block = 0 ========================2022-12-23 12:59:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksm120415' ========================2022-12-23 12:59:31======================== SELECT idx FROM macs WHERE mac_addr = '047C163E5E34CB5D26C' AND app_code = '046' ========================2022-12-23 12:59:31======================== 값이 없을 경우 ========================2022-12-23 13:00:19======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-146PCA6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 047C163E5E34CB5D26C sCDKey = 650377547494 sName = DESKTOP-146PCA6 ========================2022-12-23 13:00:19======================== 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 = '650377547494' AND r.app_code = '046' AND r.app_block = 0 ========================2022-12-23 13:00:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksm120415' ========================2022-12-23 13:00:19======================== SELECT idx FROM macs WHERE mac_addr = '047C163E5E34CB5D26C' AND app_code = '046' ========================2022-12-23 13:00:19======================== 값이 없을 경우 ========================2022-12-23 13:01:39======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-146PCA6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 047C163E5E34CB5D26C sCDKey = 650377547494 sName = DESKTOP-146PCA6 ========================2022-12-23 13:01:39======================== 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 = '650377547494' AND r.app_code = '046' AND r.app_block = 0 ========================2022-12-23 13:01:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksm120415' ========================2022-12-23 13:01:39======================== SELECT idx FROM macs WHERE mac_addr = '047C163E5E34CB5D26C' AND app_code = '046' ========================2022-12-23 13:01:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '379378' ========================2022-12-23 13:01:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '379378' ========================2022-12-23 13:01:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '379378', '047C163E5E34CB5D26C', '046', 'DESKTOP-146PCA6', '110', '1920', '1080', 'ksm120415', '동양철물[김성만]', '650377547494' ) ========================2022-12-23 13:21:48======================== noteurl_start parm_app_code = 047 parm_pc_name = TITAN-S160 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975AFAB21C98613EF0 sCDKey = 919402986592 sName = 원푸드코퍼레이션 ========================2022-12-23 13:21: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 = '919402986592' AND r.app_code = '047' AND r.app_block = 0 ========================2022-12-23 13:21:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onehcm11' ========================2022-12-23 13:21:48======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AFAB21C98613EF0' AND app_code = '047' ========================2022-12-23 13:21:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '379354' ========================2022-12-23 13:21:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '379354' ========================2022-12-23 13:21: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 ( '379354', 'B8975AFAB21C98613EF0', '047', '원푸드코퍼레이션', '�쐢�룄�슦 7', '0', '0', 'onehcm11', '원푸드코퍼레이션-호치민[김형우]', '919402986592' ) ========================2022-12-23 14:19:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KDUVO54 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050990547C84878210E sCDKey = 339466362279 sName = DESKTOP-KDUVO54 ========================2022-12-23 14:19: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 = '339466362279' AND r.app_code = '039' AND r.app_block = 0 ========================2022-12-23 14:19:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jn3124' ========================2022-12-23 14:19:52======================== SELECT idx FROM macs WHERE mac_addr = 'D050990547C84878210E' AND app_code = '039' ========================2022-12-23 14:19:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '328330' ========================2022-12-23 14:19:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '328330' ========================2022-12-23 14:19:52======================== UPDATE mac_detail SET pc_name = 'DESKTOP-KDUVO54', os_type = '110', user_id = 'jn3124', user_name = '영진수출포장[엄장영]', screen_w = '1920', screen_h = '1080', cdkey = '339466362279' WHERE mac_idx = '328330' ========================2022-12-23 20:57:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-NJ5FVHQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 982CBCC5BC552E896764 sCDKey = 151317336230 sName = DESKTOP-NJ5FVHQ ========================2022-12-23 20:57:40======================== 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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0