========================2020-08-10 09:35:47======================== noteurl_start parm_app_code = 039 parm_pc_name = YUHAN-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050994D78EB9A3274BE sCDKey = 676167886789 sName = YUHAN-PC ========================2020-08-10 09:35: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 = '676167886789' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-10 09:35:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yhthkim' ========================2020-08-10 09:35:47======================== SELECT idx FROM macs WHERE mac_addr = 'D050994D78EB9A3274BE' AND app_code = '039' ========================2020-08-10 09:35:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323677' ========================2020-08-10 09:35:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323677' ========================2020-08-10 09:35: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 ( '323677', 'D050994D78EB9A3274BE', '039', 'YUHAN-PC', '110', '1920', '1080', 'yhthkim', '유한종합유통[김태형]', '676167886789' ) ========================2020-08-10 10:28:10======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CV19T0E parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAEC82CE12A3E273 sCDKey = 999859363809 sName = DESKTOP-CV19T0E ========================2020-08-10 10:28: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 = '999859363809' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-10 10:28:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nkh10710' ========================2020-08-10 10:28:10======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEC82CE12A3E273' AND app_code = '039' ========================2020-08-10 10:28:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '192926' ========================2020-08-10 10:28:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '192926' ========================2020-08-10 10:28:10======================== UPDATE mac_detail SET pc_name = 'DESKTOP-CV19T0E', os_type = '110', user_id = 'nkh10710', user_name = '벧엘콘테이너[나광훈]', screen_w = '1920', screen_h = '1080', cdkey = '999859363809' WHERE mac_idx = '192926' ========================2020-08-10 17:04:12======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 28E3476F73484A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2020-08-10 17:04:12======================== 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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2020-08-10 17:04:18======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 28E3476F73484A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2020-08-10 17:04: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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2020-08-10 17:04:48======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 28E3476F73484A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2020-08-10 17:04: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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2020-08-10 17:05:31======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 28E3476F73484A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2020-08-10 17:05: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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2020-08-10 17:05:56======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 28E3476F73484A97C7E2 sCDKey = 487017981012 sName = MSDN-SPECIAL ========================2020-08-10 17:05: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 = '487017981012' AND r.app_code = '046' AND r.app_block = 0 ========================2020-08-10 17:06:16======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 28E3476F73484A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2020-08-10 17:06:16======================== 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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2020-08-10 17:12:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-200810 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2F226C8E644B437 sCDKey = 060411488524 sName = DESKTOP-200810 ========================2020-08-10 17:12: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 = '060411488524' AND r.app_code = '039' AND r.app_block = 0 ========================2020-08-10 17:12:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k2missinyou' ========================2020-08-10 17:12:32======================== SELECT idx FROM macs WHERE mac_addr = '7085C2F226C8E644B437' AND app_code = '039' ========================2020-08-10 17:12:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323760' ========================2020-08-10 17:12:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323760' ========================2020-08-10 17:12:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '323760', '7085C2F226C8E644B437', '039', 'DESKTOP-200810', '110', '1920', '1080', 'k2missinyou', '스마일치과기공소[곽주신]', '060411488524' ) ========================2020-08-10 17:42:04======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-SPECIAL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 28E3476F73484A97C7E2 sCDKey = 573190698474 sName = MSDN-SPECIAL ========================2020-08-10 17:42: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 = '573190698474' AND r.app_code = '046' AND r.app_block = 0 ========================2020-08-10 17:42:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'groutmart' ========================2020-08-10 17:42:05======================== SELECT idx FROM macs WHERE mac_addr = '28E3476F73484A97C7E2' AND app_code = '046' ========================2020-08-10 17:42:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '247742' ========================2020-08-10 17:42:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '247742' ========================2020-08-10 17:42:05======================== UPDATE mac_detail SET pc_name = 'MSDN-SPECIAL', os_type = '110', user_id = 'groutmart', user_name = '크린앤네이처[줄눈마트]', screen_w = '1920', screen_h = '1080', cdkey = '573190698474' WHERE mac_idx = '247742'