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]