========================2021-04-15 11:49:58======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00012E508C44CB6E14B sCDKey = 772906984559 sName = 대성 ========================2021-04-15 11:49: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 = '772906984559' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-15 11:49:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dse210407' ========================2021-04-15 11:49:58======================== SELECT idx FROM macs WHERE mac_addr = '00012E508C44CB6E14B' AND app_code = '039' ========================2021-04-15 11:49:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '341215' ========================2021-04-15 11:49:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '341215' ========================2021-04-15 11:49: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 ( '341215', '00012E508C44CB6E14B', '039', '대성', '110', '1920', '1080', 'dse210407', '대성[김영숙]', '772906984559' ) ========================2021-04-15 13:34:43======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TIO1TKQ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E4C291AEB sCDKey = 461609832074 sName = DESKTOP-TIO1TKQ ========================2021-04-15 13:34: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 = '461609832074' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-15 13:34:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tim2012' ========================2021-04-15 13:34:43======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E4C291AEB' AND app_code = '047' ========================2021-04-15 13:34:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '341229' ========================2021-04-15 13:34:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '341229' ========================2021-04-15 13:34:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '341229', 'F44D30B9AF0E4C291AEB', '047', 'DESKTOP-TIO1TKQ', '�쐢�룄�슦 10', '0', '0', 'tim2012', '(주)팀크리에이티브[홍범영]', '461609832074' ) ========================2021-04-15 13:41:53======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TIO1TKQ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E4C291AEB sCDKey = 461609832074 sName = DESKTOP-TIO1TKQ ========================2021-04-15 13:41: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 = '461609832074' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-15 13:41:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tim2012' ========================2021-04-15 13:41:53======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E4C291AEB' AND app_code = '047' ========================2021-04-15 13:41:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '341229' ========================2021-04-15 13:41:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '341229' ========================2021-04-15 13:41:53======================== UPDATE mac_detail SET pc_name = 'DESKTOP-TIO1TKQ', os_type = '�쐢�룄�슦 10', user_id = 'tim2012', user_name = '(주)팀크리에이티브[홍범영]', screen_w = '0', screen_h = '0', cdkey = '461609832074' WHERE mac_idx = '341229' ========================2021-04-15 13:42:18======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TIO1TKQ parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E4C291AEB sCDKey = 461609832074 sName = DESKTOP-TIO1TKQ ========================2021-04-15 13:42: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 = '461609832074' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-15 14:30:17======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8975AB9126144B5D3A3 sCDKey = 036041131888 sName = USER-PC ========================2021-04-15 14:30: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 = '036041131888' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-15 14:30:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'shalomjm' ========================2021-04-15 14:30:17======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AB9126144B5D3A3' AND app_code = '039' ========================2021-04-15 14:30:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '163124' ========================2021-04-15 14:30:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '163124' ========================2021-04-15 14:30:17======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'shalomjm', user_name = '하늘꽃향기[이정미]', screen_w = '1920', screen_h = '1080', cdkey = '036041131888' WHERE mac_idx = '163124' ========================2021-04-15 14:33:23======================== noteurl_start parm_app_code = 047 parm_pc_name = HJH-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 950224410979 sName = HJH-PC ========================2021-04-15 14:33: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 = '950224410979' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-15 14:33:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2021-04-15 14:33:23======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '047' ========================2021-04-15 14:33:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229613' ========================2021-04-15 14:33:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '229613' ========================2021-04-15 14:33:23======================== UPDATE mac_detail SET pc_name = 'HJH-PC', os_type = '�쐢�룄�슦 10', user_id = 'wogus36', user_name = '[황재현]', screen_w = '0', screen_h = '0', cdkey = '950224410979' WHERE mac_idx = '229613' ========================2021-04-15 16:24:27======================== noteurl_start parm_app_code = 039 parm_pc_name = LSH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245433345AC80F3AF1 sCDKey = 962266903565 sName = LSH-PC ========================2021-04-15 16:24: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 = '962266903565' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-15 16:24:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoonmin1121' ========================2021-04-15 16:24:27======================== SELECT idx FROM macs WHERE mac_addr = '00245433345AC80F3AF1' AND app_code = '039' ========================2021-04-15 16:24:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '257589' ========================2021-04-15 16:24:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '257589' ========================2021-04-15 16:24:27======================== UPDATE mac_detail SET pc_name = 'LSH-PC', os_type = '110', user_id = 'yoonmin1121', user_name = '[이수현]', screen_w = '1920', screen_h = '1080', cdkey = '962266903565' WHERE mac_idx = '257589'