ForeFront TMG: Valuable Mappings For Logging Into An External SQL Database

After you configure TMG to log into a SQL database, you may have noticed, that some logging fields like Malware Inspection Reason, IPS Scan result or URL Category, don't contain string that can see in live logging or in the integrated TMG Reports (see screenshot below), but just a number.TMG only logs those numbers, because […]

After you configure TMG to log into a SQL database, you may have noticed, that some logging fields like Malware Inspection Reason, IPS Scan result or URL Category, don't contain string that can see in live logging or in the integrated TMG Reports (see screenshot below), but just a number.

TMG only logs those numbers, because it's way more faster to query and index numbers, and numbers take significantly less space in the data base. The problem you run into, when you want to create any reports based on data TMG did log, is quite obvious… where do I get the information which number represents which value?

[Source]

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.