[{"_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":{"$count":{}},"types":{"$addToSet":{"$toInt":"$type"}}}},{"$set":{"url":"$_id","_id":"$$REMOVE"}}])