Is it possible to use SharePoint object model to enumerate all sites in an application to determine what the base site definition is? (and also to know if the site was provisioned from a template?) thx
You can iterate your site collections and examine every SPWeb to discover WebTemplate, WebTemplateId and Configuration.
These values match the template and configuration used to create the site (aka web in API). You can then compare that against the site definitions found in SharePoint root (14 hive if u wish) in the respective ONET.XML files and webtemp*.xml files.
In SP2007 there was no way to discover if your site was provisioned by a site definition template or a template file (STP). Since STP files are now retired (for site templates anyway) in favor of WSP files, I would assume that its still impossible to see this.