MS Forefront TMG Integration
I see this post has been going on for nearly two years. I'll throw in my experience and question.
By following the most recent device configuration guide to the letter, it seemed to work just fine except we weren't getting any data, and a couple of SQL errors were showing up in the collector logs, NIC-3-605102: SQLFetch failed, and NIC-3-605128: Invalid cursor state. Then I learned our implementation was using a remote MS SQL Enterprise database instead of the default local MS SQL Express database, which is what the RSA script is written for.
The stored procedure is looking for daily log files in the formats: ISALOG_yyyymmdd_FWS_% and ISALOG_yyyymmdd_Web_%, or something very similar. The enterprise version apparently only has one ISALOG file, hence at least one of the reasons it doesn't work.
My question is has anyone collected TMG logs from remote MS SQL Enterprise or Standard databases, modified RSA script, via MS SQL collection, or some other means?