Get datetime of last successful login of each user – from logs collection<\/p>\n
\/\/ Requires official MongoShell 3.6+\r\ndb.getCollection(\"log\").aggregate(\r\n [\r\n {\r\n $match: {\r\n \"message\": { \"$eq\": \"USER_SUCCESS_LOGIN\" }\r\n }\r\n },\r\n {\r\n $sort: { timestamp: -1 }\r\n },\r\n {\r\n $lookup: {\r\n \"from\": \"users\",\r\n \"localField\": \"meta.user\",\r\n \"foreignField\": \"_id\",\r\n \"as\": \"user\"\r\n }\r\n },\r\n {\r\n $match: {\r\n \"user\": { $ne: [] }\r\n }\r\n },\r\n {\r\n $unwind: { path: \"$user\" }\r\n },\r\n {\r\n $project: {\r\n \"timestamp\": { $dateToString: { format: \"%Y-%m-%d %H:%M:%S:%L\", date: \"$timestamp\" }} ,\r\n \"message\": 1,\r\n \"userid\": \"$user._id\",\r\n \"firstName\": \"$user.firstName\",\r\n \"lastName\": \"$user.lastName\",\r\n }\r\n },\r\n {\r\n $group:\r\n {\r\n \"_id\": \"$userid\",\r\n \"firstName\": { $first: \"$firstName\" },\r\n \"lastName\": { $first: \"$lastName\" },\r\n \"lastLogin\": { $first: \"$timestamp\" }\r\n }\r\n }\r\n\r\n ],\r\n {\r\n \"allowDiskUse\": true\r\n }\r\n);\r\n<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Get datetime of last successful login of each user – from logs collection \/\/ Requires official MongoShell 3.6+ db.getCollection(„log”).aggregate( [ { $match: { „message”: { „$eq”: „USER_SUCCESS_LOGIN” } } }, { $sort: { timestamp: -1 } }, { $lookup: { „from”: „users”, „localField”: „meta.user”, „foreignField”: „_id”, „as”: „user” } },… Continue reading