Given a path, e.g. http://sp2010/departments/, how can you get a list of site collections that are underneath it (which have been created through the central administration site)?
Basically want to build up a list of links on the 'departments' site, linking to all the sites underneath it (url wise, rather than as sub-sites created through the site), if possible, showing items from a list (named something like announcements, or news).
All the site collections involved are in the same same web application, so it should work getting the list via code (C#), which can then be put on the page as a web part (or editing the Master Page)?
Edit Expanding on this question a bit, since it is somewhat related, but can you do the same for listing site collections via PowerShell? This is to enable backups of all sites under that path as well.