[{"_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([{$project:{type:1,urls:{$reduce:{input:"$iocs",initialValue:[],in:{$concatArrays:["$$value","$$this.urls.url"]}}}}},{$unwind:"$urls"},{$group:{_id:"$urls",type:{$addToSet:"$type"},count:{$sum:1}}},{$project:{url:"$_id",count:1,type:1}}])