========================2020-11-17 09:52:03======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-TJM815T parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 181DEA74497498225DA0 sCDKey = 434133617514 sName = DESKTOP-TJM815T ========================2020-11-17 09:52: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2020-11-17 09:52:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2020-11-17 09:52:03======================== SELECT idx FROM macs WHERE mac_addr = '181DEA74497498225DA0' AND app_code = '048' ========================2020-11-17 09:52:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330262' ========================2020-11-17 09:52:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330262' ========================2020-11-17 09:52: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 ( '330262', '181DEA74497498225DA0', '048', 'DESKTOP-TJM815T', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2020-11-17 10:23:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RNK63PL parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 382C4ABBFEC6148382D7 sCDKey = 559191818720 sName = DESKTOP-RNK63PL ========================2020-11-17 10:23: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 = '559191818720' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-17 10:23:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'armyman127' ========================2020-11-17 10:23:00======================== SELECT idx FROM macs WHERE mac_addr = '382C4ABBFEC6148382D7' AND app_code = '039' ========================2020-11-17 10:23:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330265' ========================2020-11-17 10:23:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330265' ========================2020-11-17 10:23:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330265', '382C4ABBFEC6148382D7', '039', 'DESKTOP-RNK63PL', '110', '1280', '1024', 'armyman127', '진성공업[김진철]', '559191818720' ) ========================2020-11-17 10:23:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RNK63PL parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 382C4ABBFEC6148382D7 sCDKey = 559191818720 sName = DESKTOP-RNK63PL ========================2020-11-17 10:23:04======================== 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 ========================2020-11-17 11:23:57======================== noteurl_start parm_app_code = 039 parm_pc_name = 셰다 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = F82819AB53D1BC134FE9 sCDKey = 683156263623 sName = 셰다 ========================2020-11-17 11:23:57======================== 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 ========================2020-11-17 11:23:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2020-11-17 11:23:57======================== SELECT idx FROM macs WHERE mac_addr = 'F82819AB53D1BC134FE9' AND app_code = '039' ========================2020-11-17 11:23:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330270' ========================2020-11-17 11:23:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330270' ========================2020-11-17 11:23:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330270', 'F82819AB53D1BC134FE9', '039', '셰다', '110', '1280', '720', 'bangchun', '한반도[이진석]', '683156263623' ) ========================2020-11-17 11:44:06======================== noteurl_start parm_app_code = 039 parm_pc_name = 사장님-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99E26FA9BC524518 sCDKey = 917355058631 sName = 사장님-PC ========================2020-11-17 11:44:06======================== 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 = '917355058631' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-17 11:44:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbelectro' ========================2020-11-17 11:44:06======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99E26FA9BC524518' AND app_code = '039' ========================2020-11-17 11:44:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330242' ========================2020-11-17 11:44:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330242' ========================2020-11-17 11:44:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330242', 'B42E99E26FA9BC524518', '039', '사장님-PC', '110', '1920', '1080', 'jbelectro', '제이앤비[김선택]', '917355058631' ) ========================2020-11-17 11:55:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-EHUURF9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6045CB209521B85D7646 sCDKey = 917355058631 sName = DESKTOP-EHUURF9 ========================2020-11-17 11:55: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 = '917355058631' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-17 11:55:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jbelectro' ========================2020-11-17 11:55:38======================== SELECT idx FROM macs WHERE mac_addr = '6045CB209521B85D7646' AND app_code = '039' ========================2020-11-17 11:55:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '227667' ========================2020-11-17 11:55:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '227667' ========================2020-11-17 11:55:38======================== UPDATE mac_detail SET pc_name = 'DESKTOP-EHUURF9', os_type = '110', user_id = 'jbelectro', user_name = '제이앤비[김선택]', screen_w = '1920', screen_h = '1080', cdkey = '917355058631' WHERE mac_idx = '227667' ========================2020-11-17 14:59:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RII2D2O parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D0509995B2DD8E61DACC sCDKey = 136998638248 sName = DESKTOP-RII2D2O ========================2020-11-17 14:59:51======================== 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 = '136998638248' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-17 14:59:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dlaghgus' ========================2020-11-17 14:59:52======================== SELECT idx FROM macs WHERE mac_addr = 'D0509995B2DD8E61DACC' AND app_code = '039' ========================2020-11-17 14:59:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330294' ========================2020-11-17 14:59:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330294' ========================2020-11-17 14:59:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330294', 'D0509995B2DD8E61DACC', '039', 'DESKTOP-RII2D2O', '110', '1920', '1080', 'dlaghgus', '한국가구[임호현]', '136998638248' ) ========================2020-11-17 16:16:41======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-GF8EULV parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 144F8A04A18214E50927 sCDKey = 094475644696 sName = DESKTOP-GF8EULV ========================2020-11-17 16:16: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 = '094475644696' AND r.app_code = '045' AND r.app_block = 0 ========================2020-11-17 16:16:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'saehansystem' ========================2020-11-17 16:16:41======================== SELECT idx FROM macs WHERE mac_addr = '144F8A04A18214E50927' AND app_code = '045' ========================2020-11-17 16:16:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '265234' ========================2020-11-17 16:16:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '265234' ========================2020-11-17 16:16:41======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GF8EULV', os_type = '110', user_id = 'saehansystem', user_name = '새한시스템[김대중]', screen_w = '1536', screen_h = '864', cdkey = '094475644696' WHERE mac_idx = '265234' ========================2020-11-17 16:16:48======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-GF8EULV parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 144F8A04A18214E50927 sCDKey = 094475644696 sName = DESKTOP-GF8EULV ========================2020-11-17 16:16: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 = '094475644696' AND r.app_code = '045' AND r.app_block = 0 ========================2020-11-17 16:16:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'saehansystem' ========================2020-11-17 16:16:48======================== SELECT idx FROM macs WHERE mac_addr = '144F8A04A18214E50927' AND app_code = '045' ========================2020-11-17 16:16:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '265234' ========================2020-11-17 16:16:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '265234' ========================2020-11-17 16:16:48======================== UPDATE mac_detail SET pc_name = 'DESKTOP-GF8EULV', os_type = '110', user_id = 'saehansystem', user_name = '새한시스템[김대중]', screen_w = '1536', screen_h = '864', cdkey = '094475644696' WHERE mac_idx = '265234' ========================2020-11-17 16:30:15======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-UPHP79M parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838997C1BED8ECB2C2 sCDKey = 656810893084 sName = DESKTOP-UPHP79M ========================2020-11-17 16: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 = '656810893084' AND r.app_code = '045' AND r.app_block = 0 ========================2020-11-17 16:30:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mill4' ========================2020-11-17 16:30:15======================== SELECT idx FROM macs WHERE mac_addr = '98838997C1BED8ECB2C2' AND app_code = '045' ========================2020-11-17 16:30:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330306' ========================2020-11-17 16:30:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330306' ========================2020-11-17 16:30:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330306', '98838997C1BED8ECB2C2', '045', 'DESKTOP-UPHP79M', '110', '1920', '1080', 'mill4', '주식회사 태강[안선옥]', '656810893084' ) ========================2020-11-17 16:54:04======================== noteurl_start parm_app_code = 046 parm_pc_name = MH parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = D8CB8AAE0EC3749443CA sCDKey = 999998270083 sName = MH ========================2020-11-17 16:54:04======================== 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 = '999998270083' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-17 16:54:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mang7718' ========================2020-11-17 16:54:04======================== SELECT idx FROM macs WHERE mac_addr = 'D8CB8AAE0EC3749443CA' AND app_code = '046' ========================2020-11-17 16:54:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '176952' ========================2020-11-17 16:54:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '176952' ========================2020-11-17 16:54:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '176952', 'D8CB8AAE0EC3749443CA', '046', 'MH', '110', '1440', '900', 'mang7718', '맹호상사[김경록]', '999998270083' ) ========================2020-11-17 16:55:11======================== noteurl_start parm_app_code = 046 parm_pc_name = OWNER parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D02788D0A7106AA53162 sCDKey = 999998270083 sName = OWNER ========================2020-11-17 16:55: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 = '999998270083' AND r.app_code = '046' AND r.app_block = 0 ========================2020-11-17 16:55:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mang7718' ========================2020-11-17 16:55:11======================== SELECT idx FROM macs WHERE mac_addr = 'D02788D0A7106AA53162' AND app_code = '046' ========================2020-11-17 16:55:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261230' ========================2020-11-17 16:55:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261230' ========================2020-11-17 16:55: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 ( '261230', 'D02788D0A7106AA53162', '046', 'OWNER', '110', '1600', '900', 'mang7718', '맹호상사[김경록]', '999998270083' )