I'm looking to join the UsageReports to Users mongodb data. I would have thought the UserID field from UsageReports would align with the _id field in Users but it doesn't. Anyone have any thoughts here? By the way, I cannot link on serialNumber (email) from UsageReports because it is null in many cases.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |