========================2019-08-16 10:59:23======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-UPQOE1T parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2A0D3D0C64CD187 sCDKey = 000013578077 sName = 서버PC ========================2019-08-16 10:59:23======================== 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 = '000013578077' AND r.app_code = '051' AND r.app_block = 0 ========================2019-08-16 10:59:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2007' ========================2019-08-16 10:59:23======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A0D3D0C64CD187' AND app_code = '051' ========================2019-08-16 10:59:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293180' ========================2019-08-16 10:59:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293180' ========================2019-08-16 10:59:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293180', '7085C2A0D3D0C64CD187', '051', '서버PC', '109', '1920', '1080', 'blc2007', '주식회사 브레인콘텐츠[주식회사 브레인콘텐츠]', '000013578077' ) ========================2019-08-16 11:02:43======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-M70996K parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C26DE110383B3AD8 sCDKey = 000013578077 sName = 클라이언트PC ========================2019-08-16 11:02: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 = '000013578077' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-16 11:04:28======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-M70996K parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C26DE110383B3AD8 sCDKey = 000013578077 sName = 클라이언트PC ========================2019-08-16 11:04: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 = '000013578077' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-16 11:12:43======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-M70996K parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C26DE110383B3AD8 sCDKey = 000013578077 sName = DESKTOP-M70996K ========================2019-08-16 11:12: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 = '000013578077' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-16 11:13:37======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-M70996K parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C26DE110383B3AD8 sCDKey = 000013578077 sName = DESKTOP-M70996K ========================2019-08-16 11:13: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 = '000013578077' AND r.app_code = '051' AND r.app_block = 0 ========================2019-08-16 11:13:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2007' ========================2019-08-16 11:13:37======================== SELECT idx FROM macs WHERE mac_addr = '7085C26DE110383B3AD8' AND app_code = '051' ========================2019-08-16 11:13:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293187' ========================2019-08-16 11:13:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293187' ========================2019-08-16 11:13: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 ( '293187', '7085C26DE110383B3AD8', '051', 'DESKTOP-M70996K', '109', '1920', '1080', 'blc2007', '주식회사 브레인콘텐츠[주식회사 브레인콘텐츠]', '000013578077' ) ========================2019-08-16 11:13:39======================== noteurl_start parm_app_code = 051 parm_pc_name = DESKTOP-M70996K parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C26DE110383B3AD8 sCDKey = 000013578077 sName = DESKTOP-M70996K ========================2019-08-16 11: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 = '000013578077' AND r.app_code = '051' AND r.app_block = 0 ========================2019-08-16 13:25:31======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-6OS4ABC parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 185E0F7E7656B2EA0B66 sCDKey = 620427153299 sName = DESKTOP-6OS4ABC ========================2019-08-16 13:25:31======================== 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 = '620427153299' AND r.app_code = '045' AND r.app_block = 0 ========================2019-08-16 13:25:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ysgwak77' ========================2019-08-16 13:25:31======================== SELECT idx FROM macs WHERE mac_addr = '185E0F7E7656B2EA0B66' AND app_code = '045' ========================2019-08-16 13:25:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293333' ========================2019-08-16 13:25:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293333' ========================2019-08-16 13:25:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293333', '185E0F7E7656B2EA0B66', '045', 'DESKTOP-6OS4ABC', '110', '1536', '864', 'ysgwak77', '귀뚜라미보일러여천대리점[곽시영]', '620427153299' ) ========================2019-08-16 13:42:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 13:42:25======================== 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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 13:42:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 13:42:25======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 13:42:25======================== 값이 없을 경우 ========================2019-08-16 13:42:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 13:42: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 13:42:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 13:42:29======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 13:42:29======================== 값이 없을 경우 ========================2019-08-16 13:42:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 13: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 13:42:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 13:42:39======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 13:42:39======================== 값이 없을 경우 ========================2019-08-16 13:42:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 13:42: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 13:42:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 13:42:52======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 13:42:52======================== 값이 없을 경우 ========================2019-08-16 13:43:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 13:43: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 13:43:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 13:43:18======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 13:43:18======================== 값이 없을 경우 ========================2019-08-16 13:43:27======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 13:43:27======================== 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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 13:43:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 13:43:27======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 13:43:27======================== 값이 없을 경우 ========================2019-08-16 13:48:06======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 13:48:06======================== 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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 13:48:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 13:48:06======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 13:48:06======================== 값이 없을 경우 ========================2019-08-16 13:53:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 13:53: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 13:53:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 13:53:48======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 13:53:48======================== 값이 없을 경우 ========================2019-08-16 14:00:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF49C41C9A0C6349D sCDKey = 757959864664 sName = DESKTOP-501EC1S ========================2019-08-16 14:00: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:00:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:00:09======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF49C41C9A0C6349D' AND app_code = '039' ========================2019-08-16 14:00:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271510' ========================2019-08-16 14:00:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271510' ========================2019-08-16 14:00:09======================== UPDATE mac_detail SET pc_name = 'DESKTOP-501EC1S', os_type = '110', user_id = 'kdle64', user_name = '성진산업[이갑동]', screen_w = '1920', screen_h = '1080', cdkey = '757959864664' WHERE mac_idx = '271510' ========================2019-08-16 14:00:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = 123 ========================2019-08-16 14:00: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:00:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:00:14======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 14:00:14======================== 값이 없을 경우 ========================2019-08-16 14:02:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 14:02:21======================== 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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:02:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:02:21======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 14:02:21======================== 값이 없을 경우 ========================2019-08-16 14:06:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 14: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:06:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:06:17======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 14:06:17======================== 값이 없을 경우 ========================2019-08-16 14:06:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 14:06: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:06:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:06:35======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 14:06:35======================== 값이 없을 경우 ========================2019-08-16 14:07:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 757959864664 sName = DESKTOP-Q7M2BED ========================2019-08-16 14:07: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 = '757959864664' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:07:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:07:47======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 14:07:47======================== 값이 없을 경우 ========================2019-08-16 14:08:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 958659904813 sName = DESKTOP-Q7M2BED ========================2019-08-16 14:08: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 = '958659904813' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:08:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:08:39======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 14:08:39======================== 값이 없을 경우 ========================2019-08-16 14:09:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 5E5620524153CCF096F6 sCDKey = 958659904813 sName = DESKTOP-Q7M2BED ========================2019-08-16 14:09: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 = '958659904813' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:09:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:09:52======================== SELECT idx FROM macs WHERE mac_addr = '5E5620524153CCF096F6' AND app_code = '039' ========================2019-08-16 14:09:52======================== 값이 없을 경우 ========================2019-08-16 14:14:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B8975A5B08F6CCF096F6 sCDKey = 958659904813 sName = DESKTOP-Q7M2BED ========================2019-08-16 14:14: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 = '958659904813' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:14:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:14:01======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A5B08F6CCF096F6' AND app_code = '039' ========================2019-08-16 14:14:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293332' ========================2019-08-16 14:14:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293332' ========================2019-08-16 14:14: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 ( '293332', 'B8975A5B08F6CCF096F6', '039', 'DESKTOP-Q7M2BED', '110', '1680', '1050', 'kdle64', '성진산업[이갑동]', '958659904813' ) ========================2019-08-16 14:14:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 982920524153A0C6349D sCDKey = 958659904813 sName = DESKTOP-501EC1S ========================2019-08-16 14: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 = '958659904813' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:14:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:14:33======================== SELECT idx FROM macs WHERE mac_addr = '982920524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:14:33======================== 값이 없을 경우 ========================2019-08-16 14:14:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 982920524153A0C6349D sCDKey = 958659904813 sName = DESKTOP-501EC1S ========================2019-08-16 14:14: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 = '958659904813' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:14:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:14:51======================== SELECT idx FROM macs WHERE mac_addr = '982920524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:14:51======================== 값이 없을 경우 ========================2019-08-16 14:15:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 982920524153A0C6349D sCDKey = 958659904813 sName = DESKTOP-501EC1S ========================2019-08-16 14:15: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 = '958659904813' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:15:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:15:03======================== SELECT idx FROM macs WHERE mac_addr = '982920524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:15:03======================== 값이 없을 경우 ========================2019-08-16 14:16:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 982920524153A0C6349D sCDKey = 958659904813 sName = DESKTOP-501EC1S ========================2019-08-16 14:16: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 = '958659904813' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:16:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:16:33======================== SELECT idx FROM macs WHERE mac_addr = '982920524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:16:33======================== 값이 없을 경우 ========================2019-08-16 14:21:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B82420524153A0C6349D sCDKey = 754413204267 sName = DESKTOP-501EC1S ========================2019-08-16 14:21: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 = '754413204267' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:21:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:21:00======================== SELECT idx FROM macs WHERE mac_addr = 'B82420524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:21:00======================== 값이 없을 경우 ========================2019-08-16 14:21:10======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B82420524153A0C6349D sCDKey = 754413204267 sName = DESKTOP-501EC1S ========================2019-08-16 14:21:10======================== 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 = '754413204267' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:21:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:21:10======================== SELECT idx FROM macs WHERE mac_addr = 'B82420524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:21:10======================== 값이 없을 경우 ========================2019-08-16 14:22:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B82420524153A0C6349D sCDKey = 754413204267 sName = DESKTOP-501EC1S ========================2019-08-16 14:22:50======================== 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 = '754413204267' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:22:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:22:50======================== SELECT idx FROM macs WHERE mac_addr = 'B82420524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:22:50======================== 값이 없을 경우 ========================2019-08-16 14:30:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0E2720524153A0C6349D sCDKey = 754413204267 sName = DESKTOP-501EC1S ========================2019-08-16 14:30: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 = '754413204267' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:30:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:30:53======================== SELECT idx FROM macs WHERE mac_addr = '0E2720524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:30:53======================== 값이 없을 경우 ========================2019-08-16 14:35:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-501EC1S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0E2720524153A0C6349D sCDKey = 754413204267 sName = DESKTOP-501EC1S ========================2019-08-16 14:35: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 = '754413204267' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:35:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:35:44======================== SELECT idx FROM macs WHERE mac_addr = '0E2720524153A0C6349D' AND app_code = '039' ========================2019-08-16 14:35:44======================== 값이 없을 경우 ========================2019-08-16 14:40:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-Q7M2BED parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = B8975A5B08F6CCF096F6 sCDKey = 754413204267 sName = DESKTOP-Q7M2BED ========================2019-08-16 14:40:20======================== 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 = '754413204267' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-16 14:40:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdle64' ========================2019-08-16 14:40:20======================== SELECT idx FROM macs WHERE mac_addr = 'B8975A5B08F6CCF096F6' AND app_code = '039' ========================2019-08-16 14:40:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293332' ========================2019-08-16 14:40:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293332' ========================2019-08-16 14:40:20======================== UPDATE mac_detail SET pc_name = 'DESKTOP-Q7M2BED', os_type = '110', user_id = 'kdle64', user_name = '성진산업[이갑동]', screen_w = '1680', screen_h = '1050', cdkey = '754413204267' WHERE mac_idx = '293332'