Sure you can easily do this with a SQL query and therefore with PowerShell too.I haven't come up with a way for this yet. I know I can export all the devices and the collections separately. Is there a way in SCCM to export all the devices we have with all the collections they are in?