========================2020-03-17 07:47:22======================== noteurl_start parm_app_code = 039 parm_pc_name = SHIN-KU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAD8F2B44107691 sCDKey = 805594285382 sName = 티피솔루션 ========================2020-03-17 07:47: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 = '805594285382' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 07:47:48======================== noteurl_start parm_app_code = 039 parm_pc_name = SHIN-KU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAD8F2B44107691 sCDKey = 805594285382 sName = (주)티피솔루션 ========================2020-03-17 07:47: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 = '805594285382' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 07:48:17======================== noteurl_start parm_app_code = 039 parm_pc_name = SHIN-KU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAD8F2B44107691 sCDKey = 805594285382 sName = (주)티피솔루션 ========================2020-03-17 07:48:17======================== 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 = '805594285382' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 07:48:53======================== noteurl_start parm_app_code = 039 parm_pc_name = SHIN-KU parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAD8F2B44107691 sCDKey = 480620601698 sName = SHIN-KU ========================2020-03-17 07:48:53======================== 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 ========================2020-03-17 07:48:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tpsol2505' ========================2020-03-17 07:48:53======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAD8F2B44107691' AND app_code = '039' ========================2020-03-17 07:48:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '154553' ========================2020-03-17 07:48:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '154553' ========================2020-03-17 07:48:53======================== UPDATE mac_detail SET pc_name = 'SHIN-KU', os_type = '110', user_id = 'tpsol2505', user_name = '(주)티피솔루션[길은주]', screen_w = '1920', screen_h = '1080', cdkey = '480620601698' WHERE mac_idx = '154553' ========================2020-03-17 15:44:58======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-72R6QQJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E7A7DE72C3B0EF4 sCDKey = 434202397812 sName = DESKTOP-72R6QQJ ========================2020-03-17 15:44:58======================== 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 = '434202397812' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 15:44:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'shinjoongw' ========================2020-03-17 15:44:58======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E7A7DE72C3B0EF4' AND app_code = '039' ========================2020-03-17 15:44:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272015' ========================2020-03-17 15:44:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272015' ========================2020-03-17 15:44:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272015', 'E0D55E7A7DE72C3B0EF4', '039', 'DESKTOP-72R6QQJ', '110', '1920', '1080', 'shinjoongw', 'Sinwonmedi[신종욱]', '434202397812' ) ========================2020-03-17 16:22:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22: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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 16:22:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksoaha' ========================2020-03-17 16:22:35======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE2072B16B0F106' AND app_code = '039' ========================2020-03-17 16:22:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313217' ========================2020-03-17 16:22:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313217' ========================2020-03-17 16:22: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 ( '313217', '24F5AAE2072B16B0F106', '039', 'DESKTOP-RUB7NE6', '110', '1920', '1080', 'ksoaha', '천호크레인[김용태]', '022587272901' ) ========================2020-03-17 16:22:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22: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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 16:22:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22: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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 16:22:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22: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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 16:22:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22:44======================== 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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 16:22:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22:44======================== 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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 16:22:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22:52======================== 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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 16:22:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22:53======================== 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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-17 16:22:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RUB7NE6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAE2072B16B0F106 sCDKey = 022587272901 sName = DESKTOP-RUB7NE6 ========================2020-03-17 16:22: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 = '022587272901' AND r.app_code = '039' AND r.app_block = 0