========================2020-05-13 13:08:58======================== noteurl_start parm_app_code = 048 parm_pc_name = PJH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 998129831603 sName = PJH ========================2020-05-13 13:08: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 = '998129831603' AND r.app_code = '048' AND r.app_block = 0 ========================2020-05-13 13:08:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youi92' ========================2020-05-13 13:08:58======================== SELECT idx FROM macs WHERE mac_addr = '7085C2B92617DABAE9EC' AND app_code = '048' ========================2020-05-13 13:08:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285999' ========================2020-05-13 13:08:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285999' ========================2020-05-13 13:08: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 ( '285999', '7085C2B92617DABAE9EC', '048', 'PJH', '�쐢�룄�슦 10', '0', '0', 'youi92', '[박주현]', '998129831603' ) ========================2020-05-13 13:12:38======================== noteurl_start parm_app_code = 048 parm_pc_name = PJH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 998129831603 sName = PJH ========================2020-05-13 13:12: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 = '998129831603' AND r.app_code = '048' AND r.app_block = 0 ========================2020-05-13 15:42:53======================== noteurl_start parm_app_code = 046 parm_pc_name = KCG-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D304C7862A6138453 sCDKey = 348936551094 sName = KCG-PC ========================2020-05-13 15:42: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 = '348936551094' AND r.app_code = '046' AND r.app_block = 0 ========================2020-05-13 15:42:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gyu1001' ========================2020-05-13 15:42:53======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304C7862A6138453' AND app_code = '046' ========================2020-05-13 15:42:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '209902' ========================2020-05-13 15:42:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '209902' ========================2020-05-13 15:42:53======================== UPDATE mac_detail SET pc_name = 'KCG-PC', os_type = '110', user_id = 'gyu1001', user_name = '창규식품[권창규]', screen_w = '1920', screen_h = '1080', cdkey = '348936551094' WHERE mac_idx = '209902' ========================2020-05-13 15:57:39======================== noteurl_start parm_app_code = 039 parm_pc_name = BINJAEHO7548 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D07E357FD97E280E9584 sCDKey = 147679503448 sName = BINJAEHO7548 ========================2020-05-13 15:57: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 = '147679503448' AND r.app_code = '039' AND r.app_block = 0 ========================2020-05-13 15:57:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tcl5240825' ========================2020-05-13 15:57:39======================== SELECT idx FROM macs WHERE mac_addr = 'D07E357FD97E280E9584' AND app_code = '039' ========================2020-05-13 15:57:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317136' ========================2020-05-13 15:57:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317136' ========================2020-05-13 15:57: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 ( '317136', 'D07E357FD97E280E9584', '039', 'BINJAEHO7548', '110', '1536', '864', 'tcl5240825', '태흥케이블조명[빈재호]', '147679503448' ) ========================2020-05-13 16:02:04======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = BC5FF4B17AF388D693C1 sCDKey = 147679503448 sName = MSDN-SPECIAL ========================2020-05-13 16:02: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 = '147679503448' AND r.app_code = '039' AND r.app_block = 0 ========================2020-05-13 16:02:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tcl5240825' ========================2020-05-13 16:02:04======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4B17AF388D693C1' AND app_code = '039' ========================2020-05-13 16:02:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '169311' ========================2020-05-13 16:02:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '169311' ========================2020-05-13 16:02: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 ( '169311', 'BC5FF4B17AF388D693C1', '039', 'MSDN-SPECIAL', '90', '1600', '900', 'tcl5240825', '태흥케이블조명[빈재호]', '147679503448' ) ========================2020-05-13 16:33:52======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-QU5479F70K parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 74D435CD4F264829E001 sCDKey = 210690492788 sName = USER-QU5479F70K ========================2020-05-13 16:33: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 = '210690492788' AND r.app_code = '039' AND r.app_block = 0 ========================2020-05-13 16:33:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljm1515' ========================2020-05-13 16:33:52======================== SELECT idx FROM macs WHERE mac_addr = '74D435CD4F264829E001' AND app_code = '039' ========================2020-05-13 16:33:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315622' ========================2020-05-13 16:33:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315622' ========================2020-05-13 16:33:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315622', '74D435CD4F264829E001', '039', 'USER-QU5479F70K', '110', '1600', '900', 'ljm1515', '개별화물[이정만]', '210690492788' )