Microsoft Forefront TMG logs to an internal SQL Express database by default. There are two ‘easy’ options for getting your data into WebSpy Vantage.
1. Change the logging configuration to W3C Text Log (recommended) and import the text logs into WebSpy Vantage.
2. Install Vantage on the TMG server and import from the default database. When choosing this option, just make sure you run reports at off peak times as Vantage can be memory intensive and you don’t want the reports impacting on the performance of the server. If you go with this option then this is what you need to enter in the import wizard:
- Input Type: Database connection
- Loader Selection: Microsoft FTMG
- Input Selection: Click Add and enter the server name .\MSFW. Enter a database filter of *WEB* to only import the web proxy databases.
The other option is leaving the TMG server logging to the default SQL Express database, and installing Vantage on a separate machine. But if you do this, you need to open up the database so that it can be accessed over the network. This article explains how to do this: http://www.webspy.com.au/blogs/index.php/accessing-microsoft-forefront-tmgs-log-files-sql-express/
We also have specific Aliases and Templates for TMG, as well as more general how-to information available on our Forefront TMG page: http://www.webspy.com.au/vendors/microsoft-ftmg/howto.aspx