========================2021-06-21 09:55:25======================== noteurl_start parm_app_code = 046 parm_pc_name = BST-POS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA43A7055A0DA1136 sCDKey = 131563965794 sName = BST-POS ========================2021-06-21 09:55:25======================== 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 = '131563965794' AND r.app_code = '046' AND r.app_block = 0 ========================2021-06-21 09:55:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'astros729' ========================2021-06-21 09:55:25======================== SELECT idx FROM macs WHERE mac_addr = '68EDA43A7055A0DA1136' AND app_code = '046' ========================2021-06-21 09:55:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '345691' ========================2021-06-21 09:55:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '345691' ========================2021-06-21 09:55:25======================== UPDATE mac_detail SET pc_name = 'BST-POS', os_type = '110', user_id = 'astros729', user_name = '단지유통[박인수]', screen_w = '1024', screen_h = '768', cdkey = '131563965794' WHERE mac_idx = '345691' ========================2021-06-21 11:18:44======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-VSJLFRD parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = F80DAC10358C162AF0F6 sCDKey = 212845321133 sName = DESKTOP-VSJLFRD ========================2021-06-21 11:18:44======================== 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 = '212845321133' AND r.app_code = '046' AND r.app_block = 0 ========================2021-06-21 11:18:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeil0989' ========================2021-06-21 11:18:44======================== SELECT idx FROM macs WHERE mac_addr = 'F80DAC10358C162AF0F6' AND app_code = '046' ========================2021-06-21 11:18:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '343649' ========================2021-06-21 11:18:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '343649' ========================2021-06-21 11:18:44======================== UPDATE mac_detail SET pc_name = 'DESKTOP-VSJLFRD', os_type = '110', user_id = 'jeil0989', user_name = '제일기계공구[오대환]', screen_w = '3440', screen_h = '1440', cdkey = '212845321133' WHERE mac_idx = '343649' ========================2021-06-21 14:48:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-H0BA62H parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E840F25742146CD201A4 sCDKey = 700099590579 sName = DESKTOP-H0BA62H ========================2021-06-21 14:48:09======================== 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 = '700099590579' AND r.app_code = '039' AND r.app_block = 0 ========================2021-06-21 14:48:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhss0011' ========================2021-06-21 14:48:09======================== SELECT idx FROM macs WHERE mac_addr = 'E840F25742146CD201A4' AND app_code = '039' ========================2021-06-21 14:48:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '345806' ========================2021-06-21 14:48:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '345806' ========================2021-06-21 14:48:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '345806', 'E840F25742146CD201A4', '039', 'DESKTOP-H0BA62H', '110', '1920', '1080', 'jhss0011', '영진타일[지희섭]', '700099590579' ) ========================2021-06-21 22:16:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6ON0JCM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0862663251CFAAE93085 sCDKey = 74D4358F96CA sName = DESKTOP-6ON0JCM ========================2021-06-21 22:16: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 = '74D4358F96CA' AND r.app_code = '039' AND r.app_block = 0 ========================2021-06-21 22:16:22======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6ON0JCM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0862663251CFAAE93085 sCDKey = 893947322630 sName = DESKTOP-6ON0JCM ========================2021-06-21 22:16:22======================== 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 = '893947322630' AND r.app_code = '039' AND r.app_block = 0 ========================2021-06-21 22:27:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6ON0JCM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0862663251CFAAE93085 sCDKey = 893947322630 sName = DESKTOP-6ON0JCM ========================2021-06-21 22:27:38======================== 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 = '893947322630' AND r.app_code = '039' AND r.app_block = 0