Database
[{"systemName":"ABC","systemUsageAttrs":[{"cpuUsage":30,"memUsage":40,"isActive":false},{"cpuUsage":88.2,"memUsage":33.5,"isActive":false}]},{"systemName":"DEF","systemUsageAttrs":[{"cpuUsage":30,"memUsage":40,"isActive":false},{"cpuUsage":88.2,"memUsage":33.5,"isActive":true}]},{"systemName":"GHI","systemUsageAttrs":[{"cpuUsage":30,"memUsage":40,"isActive":true},{"cpuUsage":88.2,"memUsage":33.5,"isActive":true}]}]
Query
db.collection.find({"systemUsageAttrs":{"$not":{"$elemMatch":{"isActive":{$nin:[false]}}}}})