I have a client with a relatively large SP2010 farm. In one web application there are currently just over 7500 site collections with 10-50 being added each month.
So, I have a need to display a comprehensive list of site collections in a particular web application. I need this to be displayed in a view on a single page of the top-level site in the web application. The form should resemble a link list as it needs to be clickable links to the various site collections.
I've tried to figure out if this information can be gathered through a SOAP web service connection but can't seem to find one that exposes the site collection URL and can be displayed as a multiple entry display.
So, do we have any ideas? suggestions?