I need to do some reporting across site collections. In order to do this I intend on writing a service layer that crawls SharePoint and puts information about document libraries and files into an SQL database. This would support SharePoint 2010 and SharePoint 2013.
What would be the best way to approach this? I've done it in a previous role using a Console Application on the server itself, but surely there's a better way?