[{"_id":{"$oid":"63b4993d0625ebe8b6f5b06e"},"iocs":[{"urls":[{"url":"7.1.5.2",}],},{"urls":[{"url":"https://l-ink.me/GeheimeBegierde",},{"url":"GeheimeBegierde.ch",}],},{"urls":[{"url":"https://l-ink.me/GeheimeBegierde",}],}],type:"2"},{"_id":{"$oid":"63b4993d0624ebe8b6f5b06e"},"iocs":[{"urls":[{"url":"7.1.5.2",}],},{"urls":[{"url":"https://l-ink.me/GeheimeBegierde",},{"url":"GeheimeBegierde.ch",}],},{"urls":[{"url":"https://l-ink.me/GeheimeBegierde",}],}],type:"3"},{"_id":{"$oid":"63b4993d0615ebe8b6f5b06e"},"iocs":[{"urls":[{"url":"www.google.com",}],},{"urls":[{"url":"abc.xyz",},{"url":"GeheimeBegierde.ch",}],},{"urls":[{"url":"https://123.12",}],}],type:"1"}]

db.collection.aggregate([{"$unwind":"$iocs"},{"$unwind":"$iocs.urls"},{"$group":{"_id":"$iocs.urls.url","count":{"$sum":1},"types":{"$addToSet":"$type"}}},{"$project":{url:"$_id",_id:0,types:1,count:1}},])