========================2018-07-10 09:10:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3ES47P9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9822EFB6FCF564863DDB sCDKey = 291728851301 sName = DESKTOP-3ES47P9 ========================2018-07-10 09:10: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 = '291728851301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-10 09:10:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'anayamy0418' ========================2018-07-10 09:10:08======================== SELECT idx FROM macs WHERE mac_addr = '9822EFB6FCF564863DDB' AND app_code = '039' ========================2018-07-10 09:10:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252527' ========================2018-07-10 09:10:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252527' ========================2018-07-10 09:10: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 ( '252527', '9822EFB6FCF564863DDB', '039', 'DESKTOP-3ES47P9', '110', '1920', '1080', 'anayamy0418', '주식회사 에센스[황명하]', '291728851301' ) ========================2018-07-10 10:50:41======================== noteurl_start parm_app_code = 047 parm_pc_name = USERF-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0B94DB683D104147788 sCDKey = 983203943257 sName = USERF-PC ========================2018-07-10 10:50:41======================== 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 = '983203943257' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-10 10:52:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-79R7DNP parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 76DF2CED2261F8A95364 sCDKey = 271272727084 sName = DESKTOP-79R7DNP ========================2018-07-10 10:52:20======================== 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 = '271272727084' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-10 10:52:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssbgoo' ========================2018-07-10 10:52:20======================== SELECT idx FROM macs WHERE mac_addr = '76DF2CED2261F8A95364' AND app_code = '039' ========================2018-07-10 10:52:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254201' ========================2018-07-10 10:52:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254201' ========================2018-07-10 10:52:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254201', '76DF2CED2261F8A95364', '039', 'DESKTOP-79R7DNP', '110', '1280', '720', 'ssbgoo', '영남복집[신순복]', '271272727084' ) ========================2018-07-10 10:54:11======================== noteurl_start parm_app_code = 047 parm_pc_name = USERF-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = E0B94DB683D104147788 sCDKey = 983203943257 sName = USERF-PC ========================2018-07-10 10:54: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 = '983203943257' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-10 10:54:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eleldkf14' ========================2018-07-10 10:54:11======================== SELECT idx FROM macs WHERE mac_addr = 'E0B94DB683D104147788' AND app_code = '047' ========================2018-07-10 10:54:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251254' ========================2018-07-10 10:54:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251254' ========================2018-07-10 10:54:11======================== UPDATE mac_detail SET pc_name = 'USERF-PC', os_type = '�쐢�룄�슦 7', user_id = 'eleldkf14', user_name = '한강[오현식]', screen_w = '0', screen_h = '0', cdkey = '983203943257' WHERE mac_idx = '251254' ========================2018-07-10 11:44:54======================== noteurl_start parm_app_code = 047 parm_pc_name = VHTM parm_os_type = �쐢�룄�슦 8 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C3AA264F3AED8ECD sCDKey = 853979398456 sName = VHTM ========================2018-07-10 11:44:54======================== 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 = '853979398456' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-10 11:44:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdy3445' ========================2018-07-10 11:44:54======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AA264F3AED8ECD' AND app_code = '047' ========================2018-07-10 11:44:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254212' ========================2018-07-10 11:44:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254212' ========================2018-07-10 11:44:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254212', '50B7C3AA264F3AED8ECD', '047', 'VHTM', '�쐢�룄�슦 8', '0', '0', 'kdy3445', '[대원]', '853979398456' ) ========================2018-07-10 11:45:00======================== noteurl_start parm_app_code = 047 parm_pc_name = VHTM parm_os_type = �쐢�룄�슦 8 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C3AA264F3AED8ECD sCDKey = 853979398456 sName = VHTM ========================2018-07-10 11:45:00======================== 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 = '853979398456' AND r.app_code = '047' AND r.app_block = 0 ========================2018-07-10 11:59:14======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-03 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 88366CF37C0024641C48 sCDKey = 683156263623 sName = HBDS-03 ========================2018-07-10 11:59:14======================== 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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-10 11:59:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2018-07-10 11:59:14======================== SELECT idx FROM macs WHERE mac_addr = '88366CF37C0024641C48' AND app_code = '039' ========================2018-07-10 11:59:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254130' ========================2018-07-10 11:59:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254130' ========================2018-07-10 11:59:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '254130', '88366CF37C0024641C48', '039', 'HBDS-03', '110', '1920', '1080', 'bangchun', '한반도[이진석]', '683156263623' ) ========================2018-07-10 14:16:02======================== noteurl_start parm_app_code = 039 parm_pc_name = KB01432248 parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = C8FF28BAF85BC0BAE4A8 sCDKey = 875134945466 sName = KB01432248 ========================2018-07-10 14:16:02======================== 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 = '875134945466' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-10 14:16:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sonhan1731' ========================2018-07-10 14:16:02======================== SELECT idx FROM macs WHERE mac_addr = 'C8FF28BAF85BC0BAE4A8' AND app_code = '039' ========================2018-07-10 14:16:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '253074' ========================2018-07-10 14:16:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '253074' ========================2018-07-10 14:16:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '253074', 'C8FF28BAF85BC0BAE4A8', '039', 'KB01432248', '90', '1366', '768', 'sonhan1731', '순한고기[최영]', '875134945466' ) ========================2018-07-10 14:17:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-79R7DNP parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 74DFBFEDBE3DF8A95364 sCDKey = 271272727084 sName = DESKTOP-79R7DNP ========================2018-07-10 14:17:03======================== 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 = '271272727084' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-10 14:17:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssbgoo' ========================2018-07-10 14:17:03======================== SELECT idx FROM macs WHERE mac_addr = '74DFBFEDBE3DF8A95364' AND app_code = '039' ========================2018-07-10 14:17:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '230383' ========================2018-07-10 14:17:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '230383' ========================2018-07-10 14:17:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '230383', '74DFBFEDBE3DF8A95364', '039', 'DESKTOP-79R7DNP', '110', '1280', '720', 'ssbgoo', '영남복집[신순복]', '271272727084' ) ========================2018-07-10 17:30:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-79R7DNP parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 76DF2CED2261F8A95364 sCDKey = 271272727084 sName = DESKTOP-79R7DNP ========================2018-07-10 17:30:15======================== 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 = '271272727084' AND r.app_code = '039' AND r.app_block = 0 ========================2018-07-10 17:30:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssbgoo' ========================2018-07-10 17:30:15======================== SELECT idx FROM macs WHERE mac_addr = '76DF2CED2261F8A95364' AND app_code = '039' ========================2018-07-10 17:30:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254201' ========================2018-07-10 17:30:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254201' ========================2018-07-10 17:30:15======================== UPDATE mac_detail SET pc_name = 'DESKTOP-79R7DNP', os_type = '110', user_id = 'ssbgoo', user_name = '영남복집[신순복]', screen_w = '1280', screen_h = '720', cdkey = '271272727084' WHERE mac_idx = '254201'