So, on our internal network, I have added my MongoDB Server as server IP:27017 in forwarding destinations in IBM QRadar hosted on a remote server. So basically, IBM QRadar will be forwarding a JSON payload (array of JSON objects) over TCP to my MongoDB Server on server IP:27017
I need to write this data into a MongoDB collection. What is the best way to achieve this? This needs to be done in the way I have mentioned. I don’t want to manually export JSON files from QRadar and then import them into MongoDB.
Currently, I’ve added the remote server IP in the bind-IP list in mongod.cfg file so that MongoDB listens to connections coming from remote clients. I can currently see -
Blockquote 2110 61.498272 IP1 IP2 TCP 54 27017 → 53964 [RST, ACK] Seq=1 Ack=1 Win=0 Len=0
where IP2 is the MongoDB Server and IP1 is the QRadar Console.
I need to use MongoDB to dump raw data logs generated by QRadar and then aggregate it based on requirements. I have mistakenly copied the Wireshark log without PSH.