Hi @Pauciloquent ,
The script you mentioned can be located over here Microsoft.Exchange.2010.Reports.Script (DataWarehouseScript).
Now I believe since the SCOM 2007 and Exchange 2010 are quite old, there have been quite a lot of changes in both the Exchange management pack and the SCOM databases (DB & DW), which makes me pretty confident that this script won't work "as is" and will have to be rewritten.
The script is quite long and would require some expertise in SQL and Exchange to rewrite, this is not something we can do in these forums unfortunately.
If you have any DBA/Exchange specialists in your company, you should check with them.
You could also always ask the subject matter experts in the Exchange and SQL Server forums over here:
SQL Server forum
https://video2.skills-academy.com/en-us/answers/topics/sql-server-transact-sql.html
Exchange forum
https://video2.skills-academy.com/en-us/answers/topics/office-exchange-server-administration.html
----------
(If the reply was helpful please don't forget to accept as answer, thank you)
Best regards,
Leon