========================2020-11-11 09:20:02======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6OMSG5B parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 18C04D6396FC5AA316CA sCDKey = 038061735489 sName = DESKTOP-6OMSG5B ========================2020-11-11 09:20: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 = '038061735489' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-11 09:20:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ehdwlsxpzm' ========================2020-11-11 09:20:02======================== SELECT idx FROM macs WHERE mac_addr = '18C04D6396FC5AA316CA' AND app_code = '039' ========================2020-11-11 09:20:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329841' ========================2020-11-11 09:20:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329841' ========================2020-11-11 09:20: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 ( '329841', '18C04D6396FC5AA316CA', '039', 'DESKTOP-6OMSG5B', '110', '2560', '1440', 'ehdwlsxpzm', '동진테크[김진구]', '038061735489' ) ========================2020-11-11 09:20:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6OMSG5B parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 18C04D6396FC5AA316CA sCDKey = 038061735489 sName = DESKTOP-6OMSG5B ========================2020-11-11 09:20: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 = '038061735489' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-11 09:20:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ehdwlsxpzm' ========================2020-11-11 09:20:14======================== SELECT idx FROM macs WHERE mac_addr = '18C04D6396FC5AA316CA' AND app_code = '039' ========================2020-11-11 09:20:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329841' ========================2020-11-11 09:20:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329841' ========================2020-11-11 09:20:14======================== UPDATE mac_detail SET pc_name = 'DESKTOP-6OMSG5B', os_type = '110', user_id = 'ehdwlsxpzm', user_name = '동진테크[김진구]', screen_w = '2560', screen_h = '1440', cdkey = '038061735489' WHERE mac_idx = '329841' ========================2020-11-11 09:51:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FTSRN4J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 702C1F3A11D63E0208CB sCDKey = 772176789257 sName = DESKTOP-FTSRN4J ========================2020-11-11 09:51: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 = '772176789257' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-11 09:51:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ryuej' ========================2020-11-11 09:51:03======================== SELECT idx FROM macs WHERE mac_addr = '702C1F3A11D63E0208CB' AND app_code = '039' ========================2020-11-11 09:51:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329867' ========================2020-11-11 09:51:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329867' ========================2020-11-11 09:51: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 ( '329867', '702C1F3A11D63E0208CB', '039', 'DESKTOP-FTSRN4J', '110', '1920', '1080', 'ryuej', '정인케미칼[류은정]', '772176789257' ) ========================2020-11-11 10:15:22======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 503EAA2D7B2AEE2B1141 sCDKey = 588524411493 sName = DESKTOP-IR4BE71 ========================2020-11-11 10:15: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 = '588524411493' AND r.app_code = '047' AND r.app_block = 0 ========================2020-11-11 10:15:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onemart2019' ========================2020-11-11 10:15:22======================== SELECT idx FROM macs WHERE mac_addr = '503EAA2D7B2AEE2B1141' AND app_code = '047' ========================2020-11-11 10:15:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306393' ========================2020-11-11 10:15:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306393' ========================2020-11-11 10:15:22======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IR4BE71', os_type = '�쐢�룄�슦 10', user_id = 'onemart2019', user_name = 'ONEmart[송웅]', screen_w = '0', screen_h = '0', cdkey = '588524411493' WHERE mac_idx = '306393' ========================2020-11-11 10:15:28======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 503EAA2D7B2AEE2B1141 sCDKey = 588524411493 sName = DESKTOP-IR4BE71 ========================2020-11-11 10:15:28======================== 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 = '588524411493' AND r.app_code = '047' AND r.app_block = 0 ========================2020-11-11 10:15:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'onemart2019' ========================2020-11-11 10:15:28======================== SELECT idx FROM macs WHERE mac_addr = '503EAA2D7B2AEE2B1141' AND app_code = '047' ========================2020-11-11 10:15:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '306393' ========================2020-11-11 10:15:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '306393' ========================2020-11-11 10:15:28======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IR4BE71', os_type = '�쐢�룄�슦 10', user_id = 'onemart2019', user_name = 'ONEmart[송웅]', screen_w = '0', screen_h = '0', cdkey = '588524411493' WHERE mac_idx = '306393' ========================2020-11-11 11:10:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-ATHSOF6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF47ECA795EB58006 sCDKey = 772176789257 sName = DESKTOP-ATHSOF6 ========================2020-11-11 11:10:01======================== 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 = '772176789257' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-11 11:10:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ryuej' ========================2020-11-11 11:10:01======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF47ECA795EB58006' AND app_code = '039' ========================2020-11-11 11:10:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285493' ========================2020-11-11 11:10:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285493' ========================2020-11-11 11:10:01======================== UPDATE mac_detail SET pc_name = 'DESKTOP-ATHSOF6', os_type = '110', user_id = 'ryuej', user_name = '정인케미칼[류은정]', screen_w = '1920', screen_h = '1080', cdkey = '772176789257' WHERE mac_idx = '285493' ========================2020-11-11 11:11:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FTSRN4J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 702C1F3A11D63E0208CB sCDKey = 658491740825 sName = DESKTOP-FTSRN4J ========================2020-11-11 11:11: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 = '658491740825' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-11 11:11:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'this0528' ========================2020-11-11 11:11:09======================== SELECT idx FROM macs WHERE mac_addr = '702C1F3A11D63E0208CB' AND app_code = '039' ========================2020-11-11 11:11:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329867' ========================2020-11-11 11:11:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329867' ========================2020-11-11 11:11:09======================== UPDATE mac_detail SET pc_name = 'DESKTOP-FTSRN4J', os_type = '110', user_id = 'this0528', user_name = '거성비앤씨[김정섭]', screen_w = '1920', screen_h = '1080', cdkey = '658491740825' WHERE mac_idx = '329867' ========================2020-11-11 15:57:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LLI0S51 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7427EAD66BD04AF4499C sCDKey = 684740599153 sName = DESKTOP-LLI0S51 ========================2020-11-11 15:57: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 = '684740599153' AND r.app_code = '039' AND r.app_block = 0 ========================2020-11-11 15:57:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ildong4040' ========================2020-11-11 15:57:00======================== SELECT idx FROM macs WHERE mac_addr = '7427EAD66BD04AF4499C' AND app_code = '039' ========================2020-11-11 15:57:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329921' ========================2020-11-11 15:57:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329921' ========================2020-11-11 15:57: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 ( '329921', '7427EAD66BD04AF4499C', '039', 'DESKTOP-LLI0S51', '110', '1920', '1080', 'ildong4040', '일동특수나사[이규민]', '684740599153' )