========================2021-10-27 11:04:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KKTHHJC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B5203AAF63CE46DA2F sCDKey = 480620601698 sName = DESKTOP-KKTHHJC ========================2021-10-27 11:04:56======================== 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 = '480620601698' AND r.app_code = '039' AND r.app_block = 0 ========================2021-10-27 11:09:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-KKTHHJC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B5203AAF63CE46DA2F sCDKey = 480620601698 sName = DESKTOP-KKTHHJC ========================2021-10-27 11:09: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 = '480620601698' AND r.app_code = '039' AND r.app_block = 0 ========================2021-10-27 11:09:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tpsol2505' ========================2021-10-27 11:09:01======================== SELECT idx FROM macs WHERE mac_addr = 'F4B5203AAF63CE46DA2F' AND app_code = '039' ========================2021-10-27 11:09:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353403' ========================2021-10-27 11:09:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353403' ========================2021-10-27 11:09:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353403', 'F4B5203AAF63CE46DA2F', '039', 'DESKTOP-KKTHHJC', '110', '1920', '1080', 'tpsol2505', '(주)티피솔루션[길은주]', '480620601698' ) ========================2021-10-27 15:22:40======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-J67DM34 parm_os_type = 110 parm_screen_w = 1418 parm_screen_h = 798 parm_user_mac = CAFF221B5E95FE2ADF7E sCDKey = 747413241531 sName = DESKTOP-J67DM34 ========================2021-10-27 15:22:40======================== 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 = '747413241531' AND r.app_code = '046' AND r.app_block = 0 ========================2021-10-27 15:22:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'damurak' ========================2021-10-27 15:22:40======================== SELECT idx FROM macs WHERE mac_addr = 'CAFF221B5E95FE2ADF7E' AND app_code = '046' ========================2021-10-27 15:22:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353442' ========================2021-10-27 15:22:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353442' ========================2021-10-27 15:22:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353442', 'CAFF221B5E95FE2ADF7E', '046', 'DESKTOP-J67DM34', '110', '1418', '798', 'damurak', '섬지친환경원예사[서종태]', '747413241531' ) ========================2021-10-27 15:24:38======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-5SACMQ7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23242A4F01E1112 sCDKey = 747413241531 sName = DESKTOP-5SACMQ7 ========================2021-10-27 15:24: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 = '747413241531' AND r.app_code = '046' AND r.app_block = 0 ========================2021-10-27 15:24:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'damurak' ========================2021-10-27 15:24:38======================== SELECT idx FROM macs WHERE mac_addr = '7085C23242A4F01E1112' AND app_code = '046' ========================2021-10-27 15:24:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '347762' ========================2021-10-27 15:24:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '347762' ========================2021-10-27 15:24:38======================== UPDATE mac_detail SET pc_name = 'DESKTOP-5SACMQ7', os_type = '110', user_id = 'damurak', user_name = '섬지친환경원예사[서종태]', screen_w = '1920', screen_h = '1080', cdkey = '747413241531' WHERE mac_idx = '347762' ========================2021-10-27 15:24:45======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-5SACMQ7 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23242A4F01E1112 sCDKey = 747413241531 sName = DESKTOP-5SACMQ7 ========================2021-10-27 15:24:45======================== 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 = '747413241531' AND r.app_code = '046' AND r.app_block = 0 ========================2021-10-27 15:33:34======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-GHTP11R parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF733844770EEF09AE sCDKey = 885264505848 sName = DESKTOP-GHTP11R ========================2021-10-27 15:33: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 = '885264505848' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-27 15:33:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mailo7' ========================2021-10-27 15:33:35======================== SELECT idx FROM macs WHERE mac_addr = '50AF733844770EEF09AE' AND app_code = '047' ========================2021-10-27 15:33:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353446' ========================2021-10-27 15:33:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353446' ========================2021-10-27 15:33: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 ( '353446', '50AF733844770EEF09AE', '047', 'DESKTOP-GHTP11R', '�쐢�룄�슦 10', '0', '0', 'mailo7', '송영훈[송영훈]', '885264505848' ) ========================2021-10-27 16:15:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6B072J4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E998C81353A5D30AD sCDKey = 985128471700 sName = DESKTOP-6B072J4 ========================2021-10-27 16:15:39======================== 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 = '985128471700' AND r.app_code = '039' AND r.app_block = 0 ========================2021-10-27 16:15:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'misyleejy' ========================2021-10-27 16:15:39======================== SELECT idx FROM macs WHERE mac_addr = 'B42E998C81353A5D30AD' AND app_code = '039' ========================2021-10-27 16:15:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307456' ========================2021-10-27 16:15:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '307456' ========================2021-10-27 16:15:39======================== UPDATE mac_detail SET pc_name = 'DESKTOP-6B072J4', os_type = '110', user_id = 'misyleejy', user_name = '삼보티에스[이지연]', screen_w = '1920', screen_h = '1080', cdkey = '985128471700' WHERE mac_idx = '307456' ========================2021-10-27 16:15:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6B072J4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E998C81353A5D30AD sCDKey = 985128471700 sName = DESKTOP-6B072J4 ========================2021-10-27 16:15:43======================== 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 = '985128471700' AND r.app_code = '039' AND r.app_block = 0 ========================2021-10-27 19:09:30======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-RE4UIPR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D8F3BC842CDBE6D23501 sCDKey = 416808923829 sName = 안양지점 ========================2021-10-27 19:09:30======================== 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 = '416808923829' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-27 19:09:38======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-RE4UIPR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D8F3BC842CDBE6D23501 sCDKey = 416808923829 sName = ========================2021-10-27 19:09: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 = '416808923829' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-27 19:10:09======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-RE4UIPR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D8F3BC842CDBE6D23501 sCDKey = 416808923829 sName = DESKTOP-RE4UIPR ========================2021-10-27 19:10: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 = '416808923829' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-27 19:10:28======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-RE4UIPR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D8F3BC842CDBE6D23501 sCDKey = 416808923829 sName = DESKTOP-RE4UIPR ========================2021-10-27 19:10: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 = '416808923829' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-27 19:13:39======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-RE4UIPR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = D8F3BC842CDBE6D23501 sCDKey = 416808923829 sName = hanbat ========================2021-10-27 19:13:39======================== 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 = '416808923829' AND r.app_code = '047' AND r.app_block = 0 ========================2021-10-27 23:51:34======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-PLELHC7 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F02F741C9D2F3E9D7023 sCDKey = 638942920623 sName = DESKTOP-PLELHC7 ========================2021-10-27 23:51: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 = '638942920623' AND r.app_code = '048' AND r.app_block = 0 ========================2021-10-27 23:51:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dcnet727812' ========================2021-10-27 23:51:34======================== SELECT idx FROM macs WHERE mac_addr = 'F02F741C9D2F3E9D7023' AND app_code = '048' ========================2021-10-27 23:51:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '348054' ========================2021-10-27 23:51:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '348054' ========================2021-10-27 23:51: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 ( '348054', 'F02F741C9D2F3E9D7023', '048', 'DESKTOP-PLELHC7', '�쐢�룄�슦 10', '0', '0', 'dcnet727812', '주식회사 디씨넷[강선정]', '638942920623' )