Users with Multiple Devices Excluding Asset Statuses

Has anyone figured out how to show users with assets but exclude asset statuses? I am currently trying to show all users with multiple devices but exclude devices with the status of missing. I like the way the devices combine in the user explore view. The issue is you cannot combine asset statuses with users. If I try to do this on the asset explore side I cannot sort by multiple devices.