One of the limitations (to my knowledge) within ConfigMgr's console, is the ability to cross views easily in reference to the SQL DB.
I've wanted, for awhile, to be able to take a User Collection, and generate a Device Collection that are the Primary devices those users are set to.
This is what I've come up with so far as a new view in SQL.
I also popped this together, a list of all users, and their assigned Primary Devices.
Next, I'll put together a little PowerShell function to get this list of Devices, and then place them in a Collection.
Now I fully expect to be shown how this is something do-able in one or two simple clicks within the console. :)