Database
[{_id:ObjectId("6246ab45e95eac6c85726cfc"),imageName:"IMG_123456.jpg",eventTime:ISODate("2022-04-01T07:35:30.615Z"),deviceId:"48701ED21819"},{_id:ObjectId("6246ab45e95eac6c85726cf1"),imageName:"IMG_123456.jpg",eventTime:ISODate("2022-04-01T07:38:10.543Z"),deviceId:"58701ED21817"},{_id:ObjectId("6246ab45e95eac6c85726cf2"),imageName:"IMG_123456.jpg",eventTime:ISODate("2022-04-01T08:05:50.865Z"),deviceId:"48701ED21819"}]
Query
db.collection.aggregate([{"$group":{"_id":"$deviceId",imageName:{$first:"$imageName"},eventTime:{$max:"$eventTime"},deviceId:{$first:"$deviceId"},}}])