========================2020-12-14 10:29:37======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-201211 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 18C04D63ABAAFCF1C9CB sCDKey = 279590377480 sName = USER-201211 ========================2020-12-14 10:29:37======================== 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 = '279590377480' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-14 10:29:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pgw8056' ========================2020-12-14 10:29:37======================== SELECT idx FROM macs WHERE mac_addr = '18C04D63ABAAFCF1C9CB' AND app_code = '039' ========================2020-12-14 10:29:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '332308' ========================2020-12-14 10:29:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '332308' ========================2020-12-14 10:29:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '332308', '18C04D63ABAAFCF1C9CB', '039', 'USER-201211', '110', '1280', '1024', 'pgw8056', '서부에너지[박경원]', '279590377480' ) ========================2020-12-14 11:49:41======================== noteurl_start parm_app_code = 045 parm_pc_name = USER-O3JOE6D3CI parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = B8975A1302FF4829E001 sCDKey = 106359188512 sName = USER-O3JOE6D3CI ========================2020-12-14 11:49: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 = '106359188512' AND r.app_code = '045' AND r.app_block = 0 ========================2020-12-14 11:49:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cp2201' ========================2020-12-14 11:49:41======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A1302FF4829E001' AND app_code = '045' ========================2020-12-14 11:49:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '332318' ========================2020-12-14 11:49:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '332318' ========================2020-12-14 11:49:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '332318', 'B8975A1302FF4829E001', '045', 'USER-O3JOE6D3CI', '110', '2560', '1440', 'cp2201', '주식회사 지얼[주훈석]', '106359188512' ) ========================2020-12-14 14:27:13======================== noteurl_start parm_app_code = 039 parm_pc_name = A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = ACB57D9441D1C29FFA49 sCDKey = 507493827944 sName = A ========================2020-12-14 14:27:13======================== 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 = '507493827944' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-14 14:27:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunguard' ========================2020-12-14 14:27:13======================== SELECT idx FROM macs WHERE mac_addr = 'ACB57D9441D1C29FFA49' AND app_code = '039' ========================2020-12-14 14:27:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '143009' ========================2020-12-14 14:27:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '143009' ========================2020-12-14 14:27:13======================== UPDATE mac_detail SET pc_name = 'A', os_type = '110', user_id = 'sunguard', user_name = '(주)썬가드광학[황경미]', screen_w = '1920', screen_h = '1080', cdkey = '507493827944' WHERE mac_idx = '143009' ========================2020-12-14 17:13:09======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301646867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:13: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 = '301646867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:13:30======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:13: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:13:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:13:31======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:13:31======================== 값이 없을 경우 ========================2020-12-14 17:13:57======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:13: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:13:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:13:57======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:13:57======================== 값이 없을 경우 ========================2020-12-14 17:14:33======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:14:33======================== 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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:14:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:14:34======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:14:34======================== 값이 없을 경우 ========================2020-12-14 17:14:48======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:14: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:14:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:14:48======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:14:48======================== 값이 없을 경우 ========================2020-12-14 17:15:00======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:15: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:15:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:15:00======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:15:00======================== 값이 없을 경우 ========================2020-12-14 17:17:05======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:17:05======================== 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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:17:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:17:05======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:17:05======================== 값이 없을 경우 ========================2020-12-14 17:17:14======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:17: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:17:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:17:14======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:17:14======================== 값이 없을 경우 ========================2020-12-14 17:17:35======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = 경기도사격테마파크 ========================2020-12-14 17:17: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:17:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:17:35======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:17:35======================== 값이 없을 경우 ========================2020-12-14 17:17:38======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = 경기도사격테마파크 ========================2020-12-14 17:17: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:17:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:17:38======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:17:38======================== 값이 없을 경우 ========================2020-12-14 17:17:40======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = 경기도사격테마파크 ========================2020-12-14 17:17: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:17:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:17:40======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:17:40======================== 값이 없을 경우 ========================2020-12-14 17:19:24======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 301676867685 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:19: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 = '301676867685' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:19:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:19:24======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:19:24======================== 값이 없을 경우 ========================2020-12-14 17:21:48======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 996624473773 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:21: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 = '996624473773' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:21:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:21:48======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:21:48======================== 값이 없을 경우 ========================2020-12-14 17:42:39======================== noteurl_start parm_app_code = 050 parm_pc_name = WINDOWS-3MFC7I4 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = B05CDAA674E406307D6B sCDKey = 996624473773 sName = WINDOWS-3MFC7I4 ========================2020-12-14 17:42: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 = '996624473773' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-14 17:42:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'admin6056' ========================2020-12-14 17:42:39======================== SELECT idx FROM macs WHERE mac_addr = 'B05CDAA674E406307D6B' AND app_code = '050' ========================2020-12-14 17:42:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '332360' ========================2020-12-14 17:42:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '332360' ========================2020-12-14 17:42:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '332360', 'B05CDAA674E406307D6B', '050', 'WINDOWS-3MFC7I4', '109', '1536', '864', 'admin6056', '경기도사격테마파크[모강섭]', '996624473773' )