구르는 돌에는 이끼가 끼지 않는다

# 생성 INDEX 조회
db.getCollection('[컬렉션명]').getIndexes()
db.getCollection('[컬렉션명]').getIndexes()
db.getCollection('[컬렉션명]').getIndexes()

#생성 INDEX 제거
db.getCollection('[컬렉션명]').dropIndexes() //_id INDEX를 제외한 모든 INDEX 제거
db.getCollection('[컬렉션명]').dropIndex("name":"body_host_ip_1_body_key_1") //지정된 INDEX 제거

#INDEX 생성 쿼리
db.getCollection('[컬렉션명]').createIndex( { "body_event_time": 1 } )
db.getCollection('[컬렉션명]').createIndex( { "body_host_ip": 1 } )
db.getCollection('[컬렉션명]').createIndex( { "body_uid": 1, "body_ses":1 } )
db.getCollection('[컬렉션명]').createIndex( { "body_key": 1 } )
db.getCollection('[컬렉션명]').createIndex( { "header_msg": 1 } )
db.getCollection('[컬렉션명]').createIndex( { "body_name": 1 } )
db.getCollection('[컬렉션명]').createIndex( { "header_message:type": 1 } )

db.getCollection('[컬렉션명]').createIndex({"external_ids.0": 1 })
db.getCollection('[컬렉션명]').createIndex({"platforms.0": 1 })

db.getCollection('[컬렉션명]').createIndex({"attack_group": 1, "external_id": 1 })

//컬렉션 초기화
MongoCollection<Document> auditLogCol = mongoTemplate.getCollection("AUDIT_LOG");

//where 조건 쿼리
BasicDBObject dateTermQuery = MogoDBUtil.getDateTermFindQuery("body_event_time", vo.getStartDate(), vo.getEndDate());
dateTermQuery.put("body_host_ip", vo.getHostIp());
        
List<BasicDBObject> uidQueryList = new ArrayList<BasicDBObject>();

//$match 부분 초기화
BasicDBObject matchQuery = new BasicDBObject("$match", dateTermQuery);
//$group 부분 추기화
BasicDBObject groupUidQuery = new BasicDBObject("$group", new BasicDBObject("_id", "$body_uid"));
		
uidQueryList.add(matchQuery);
uidQueryList.add(groupUidQuery);
//aggregate 요청
List<Document> uidList = auditLogCol.aggregate(uidQueryList).into(new ArrayList<>());

mongoexport -d DB_HT -c MITRE_ATTACK --pretty -o [파일경로]].json --port 27017

mongoimport --db DB_HT --collection MITRE_ATTACK_GROUP --drop --type csv --headerline --host "localhost:27017" --file "[파일경로].csv"