Thank you very much. Works well.

I'm using PowerShell as well but not with the CMS. How does that work? I'd be appreciative of that information and a copy of your script if you don't mind....

The only way I see to do this is to create a linked server and write the individual results into the table using a linked server.

Thank you for creating/sharing this script! I'm a new DBA and I spend hours restoring from production to test and haven't been able to figure out how to script this....