If you ever need to do something similar in the future, the data explorer is really useful for that kind of thing. 
If you need help writing the query you can create a topic in the data & reporting category for some assistance.
2 Me gusta