WebSpy is a Fastvue Product

Support Center

Importing Microsoft Forefront TMG

Last Updated: Oct 07, 2014 08:46PM PDT
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

Contact Us

seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found