========================2023-09-11 09:13:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-057TLNJ parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8BBC1683A3824B8A83C sCDKey = 054682511349 sName = DESKTOP-057TLNJ ========================2023-09-11 09:13:46======================== 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 = '054682511349' AND r.app_code = '039' AND r.app_block = 0 ========================2023-09-11 09:13:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khh1131' ========================2023-09-11 09:13:46======================== SELECT idx FROM macs WHERE mac_addr = 'D8BBC1683A3824B8A83C' AND app_code = '039' ========================2023-09-11 09:13:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '393441' ========================2023-09-11 09:13:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '393441' ========================2023-09-11 09:13:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '393441', 'D8BBC1683A3824B8A83C', '039', 'DESKTOP-057TLNJ', '110', '1536', '864', 'khh1131', '신명산업분체[유수일]', '054682511349' ) ========================2023-09-11 09:13:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-057TLNJ parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D8BBC1683A3824B8A83C sCDKey = 054682511349 sName = DESKTOP-057TLNJ ========================2023-09-11 09:13: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 = '054682511349' AND r.app_code = '039' AND r.app_block = 0 ========================2023-09-11 09:19:18======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-8NKA9MJVTTI parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 588694F926FA78F86FC9 sCDKey = 081094221129 sName = WIN-8NKA9MJVTTI ========================2023-09-11 09:19:18======================== 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 = '081094221129' AND r.app_code = '046' AND r.app_block = 0 ========================2023-09-11 09:19:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodlife0223' ========================2023-09-11 09:19:18======================== SELECT idx FROM macs WHERE mac_addr = '588694F926FA78F86FC9' AND app_code = '046' ========================2023-09-11 09:19:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '393475' ========================2023-09-11 09:19:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '393475' ========================2023-09-11 09:19:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '393475', '588694F926FA78F86FC9', '046', 'WIN-8NKA9MJVTTI', '90', '1024', '768', 'goodlife0223', '조은생활유통[안성진]', '081094221129' ) ========================2023-09-11 09:26:24======================== noteurl_start parm_app_code = 046 parm_pc_name = 5600G-230911 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 819 parm_user_mac = 9C6B00250D5AB0AF860E sCDKey = 975677425073 sName = 5600G-230911 ========================2023-09-11 09:26:24======================== 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 = '975677425073' AND r.app_code = '046' AND r.app_block = 0 ========================2023-09-11 09:26:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ami2881' ========================2023-09-11 09:26:24======================== SELECT idx FROM macs WHERE mac_addr = '9C6B00250D5AB0AF860E' AND app_code = '046' ========================2023-09-11 09:26:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '393440' ========================2023-09-11 09:26:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '393440' ========================2023-09-11 09:26:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '393440', '9C6B00250D5AB0AF860E', '046', '5600G-230911', '110', '1024', '819', 'ami2881', '아미상사[이재훈]', '975677425073' ) ========================2023-09-11 14:33:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-I02S0SJ parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 047C16BC1165D22880A4 sCDKey = 662276173401 sName = DESKTOP-I02S0SJ ========================2023-09-11 14:33: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 = '662276173401' AND r.app_code = '039' AND r.app_block = 0 ========================2023-09-11 14:33:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yys97' ========================2023-09-11 14:33:04======================== SELECT idx FROM macs WHERE mac_addr = '047C16BC1165D22880A4' AND app_code = '039' ========================2023-09-11 14:33:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '393504' ========================2023-09-11 14:33:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '393504' ========================2023-09-11 14:33: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 ( '393504', '047C16BC1165D22880A4', '039', 'DESKTOP-I02S0SJ', '110', '1600', '900', 'yys97', '주식회사 씨앤팩[김지율]', '662276173401' ) ========================2023-09-11 20:06:17======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4S37B9F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DC60472B0F9D050 sCDKey = 698508722265 sName = DESKTOP-4S37B9F ========================2023-09-11 20:06: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 = '698508722265' AND r.app_code = '046' AND r.app_block = 0 ========================2023-09-11 20:06:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sungho2244' ========================2023-09-11 20:06:18======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DC60472B0F9D050' AND app_code = '046' ========================2023-09-11 20:06:18======================== 값이 없을 경우 ========================2023-09-11 20:07:01======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4S37B9F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DC60472B0F9D050 sCDKey = 698508722265 sName = DESKTOP-4S37B9F ========================2023-09-11 20:07: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 = '698508722265' AND r.app_code = '046' AND r.app_block = 0 ========================2023-09-11 20:07:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sungho2244' ========================2023-09-11 20:07:02======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DC60472B0F9D050' AND app_code = '046' ========================2023-09-11 20:07:02======================== 값이 없을 경우 ========================2023-09-11 20:08:29======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4S37B9F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DC60472B0F9D050 sCDKey = 698508722265 sName = DESKTOP-4S37B9F ========================2023-09-11 20:08:29======================== 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 = '698508722265' AND r.app_code = '046' AND r.app_block = 0 ========================2023-09-11 20:08:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sungho2244' ========================2023-09-11 20:08:30======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DC60472B0F9D050' AND app_code = '046' ========================2023-09-11 20:08:30======================== 값이 없을 경우 ========================2023-09-11 20:11:47======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-4S37B9F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DC60472B0F9D050 sCDKey = 698508722265 sName = DESKTOP-4S37B9F ========================2023-09-11 20:11:47======================== 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 = '698508722265' AND r.app_code = '046' AND r.app_block = 0 ========================2023-09-11 20:11:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sungho2244' ========================2023-09-11 20:11:47======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DC60472B0F9D050' AND app_code = '046' ========================2023-09-11 20:11:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '393538' ========================2023-09-11 20:11:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '393538' ========================2023-09-11 20:11:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '393538', '1C1B0DC60472B0F9D050', '046', 'DESKTOP-4S37B9F', '110', '1920', '1080', 'sungho2244', '서울공구마트[이성호]', '698508722265' )