I'm in a MOSS 2007 environment and am looking to find a way to see where solutions listed in the stsamd -o enumsolutions are activated in site collections. How would I go aout finding out where these solutions/features are activated down to the site level?
Preupgradecheck tells you what's wrong, but it doesn't say where the issue lies. I used the enumallweb stsadm command in conjunction with the -includewebparts and -includesetupfiles switches to enum through all the site collections and subsites to find the offending features and setup files.
For the borken web parts, I could just go to the site listed and append contents=1 to the URL to delete the erred web part. The output also told me where the missing files were located. This appears to be a bug from the meeting templates as described here. I'm still tracing down a couple web parts and will resort to querying a backup copy of the database if I have to.
Solution management in Operations tab of Central Administration can show you which site collections a particular solution has been deployed to, good for one-off queries. Do you need something more "ad-hoc" callable, perhaps by a user without access to Central Admin?