========================2020-08-06 09:09:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DSUI5LS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 382C4A6443D5EC6C72E0 sCDKey = 707603618662 sName = DESKTOP-DSUI5LS ========================2020-08-06 09:09:34======================== 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 = '707603618662' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-06 09:09:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'csm1372' ========================2020-08-06 09:09:34======================== SELECT idx FROM macs WHERE mac_addr = '382C4A6443D5EC6C72E0' AND app_code = '039' ========================2020-08-06 09:09:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323492' ========================2020-08-06 09:09:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323492' ========================2020-08-06 09:09:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '323492', '382C4A6443D5EC6C72E0', '039', 'DESKTOP-DSUI5LS', '110', '1920', '1080', 'csm1372', '창신기공[김동중]', '707603618662' ) ========================2020-08-06 10:31:37======================== noteurl_start parm_app_code = 050 parm_pc_name = 사무처2 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C7BEF4B565038C5B0BD sCDKey = 511349429034 sName = 사무처2 ========================2020-08-06 10:31:37======================== 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 = '511349429034' AND r.app_code = '050' AND r.app_block = 0 ========================2020-08-06 10:31:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'iccu' ========================2020-08-06 10:31:37======================== SELECT idx FROM macs WHERE mac_addr = '9C7BEF4B565038C5B0BD' AND app_code = '050' ========================2020-08-06 10:31:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323507' ========================2020-08-06 10:31:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323507' ========================2020-08-06 10:31:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '323507', '9C7BEF4B565038C5B0BD', '050', '사무처2', '109', '1920', '1080', 'iccu', '인천가톨릭대학교[명호진]', '511349429034' ) ========================2020-08-06 10:31:47======================== noteurl_start parm_app_code = 050 parm_pc_name = 사무처2 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C7BEF4B565038C5B0BD sCDKey = 511349429034 sName = 사무처2 ========================2020-08-06 10:31:47======================== 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 = '511349429034' AND r.app_code = '050' AND r.app_block = 0 ========================2020-08-06 10:45:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5GEBMBU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04D22EC8D84E3EE49 sCDKey = 617218682863 sName = DESKTOP-5GEBMBU ========================2020-08-06 10:45: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 = '617218682863' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-06 10:45:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ysgear311' ========================2020-08-06 10:45:09======================== SELECT idx FROM macs WHERE mac_addr = '18C04D22EC8D84E3EE49' AND app_code = '039' ========================2020-08-06 10:45:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323514' ========================2020-08-06 10:45:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323514' ========================2020-08-06 10:45: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 ( '323514', '18C04D22EC8D84E3EE49', '039', 'DESKTOP-5GEBMBU', '110', '1920', '1080', 'ysgear311', '(주)피티코리아[유창열]', '617218682863' ) ========================2020-08-06 14:10:35======================== noteurl_start parm_app_code = 039 parm_pc_name = SN1-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 2C56DC3E2AA4AAB0C179 sCDKey = 409636375789 sName = 동부세차장 ========================2020-08-06 14:10:35======================== 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 = '409636375789' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-06 14:10:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'zebra998' ========================2020-08-06 14:10:35======================== SELECT idx FROM macs WHERE mac_addr = '2C56DC3E2AA4AAB0C179' AND app_code = '039' ========================2020-08-06 14:10:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323537' ========================2020-08-06 14:10:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323537' ========================2020-08-06 14:10:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '323537', '2C56DC3E2AA4AAB0C179', '039', '동부세차장', '90', '1680', '1050', 'zebra998', '동부자동차부분세차정비공업사[김영숙]', '409636375789' ) ========================2020-08-06 17:35:11======================== noteurl_start parm_app_code = 039 parm_pc_name = BAEK01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5A5883E1803C7C9 sCDKey = 035701543380 sName = BAEK01 ========================2020-08-06 17:35:11======================== 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 = '035701543380' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-06 17:35:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bk4jji' ========================2020-08-06 17:35:11======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5A5883E1803C7C9' AND app_code = '039' ========================2020-08-06 17:35:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323564' ========================2020-08-06 17:35:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323564' ========================2020-08-06 17:35:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '323564', 'C03FD5A5883E1803C7C9', '039', 'BAEK01', '110', '1920', '1080', 'bk4jji', '백경사[조주일]', '035701543380' )