Monthly reports TMG
I'm having trouble with monthly report on my tmg array. Site and user activity reports show only one week information. I choose last 30 days in reports details but start date of this report is One week ago, End Date is now.
March 23rd, 2012 10:13am
Some pictures and UP!


March 27th, 2012 9:05am
Hi,
Thank you for the update.
Firstly, please install the latest rollup 1 for TMG SP2 and check if you have selected Enable Daily and Monthly Summaries.
Regards,
March 29th, 2012 12:17pm
I already have the latest rollup 1 for TMG SP2 and "Enable Daily and Monthly Summaries" is selected.
March 29th, 2012 12:31pm
I have exactly the same problem. It's weird that such basic functionality is apparently broken and no solution available...
April 3rd, 2012 1:12pm
I have this problem too. I guess, the issue must be find in date format. The manual "On-Time" report of the last month works properly, but the recurring monthly job gets empty data back.
I'm not sure if i should set the SYSTEM locale Region and Language to us english and if this work immediately by the report or if then the logs will be saved in other time format for the future reportings.
Until now i have not found a solution except to generate reports manually.
Best regards
May 1st, 2012 7:15pm
I have the same problem. Install the latest updates
TMG, did not help. Has anyone found a
solution to this problem?
March 27th, 2013 10:22am
I have the same problem. Install the latest updates
TMG, did not help. Has anyone found a
solution to this problem?
Didn't yet
March 27th, 2013 10:36am
Did MS fix this yet? Or is there a solution?
November 27th, 2013 9:02am
Didn't yet, again. I've not find a solution
November 27th, 2013 9:09am
I'll put in a call to Pro Support. This is ridiculous.
If I get a solution I'll post it here.
November 27th, 2013 9:11am
I am having this exact issue - did anyone ever get this resolved?
February 3rd, 2014 7:03am
I translated saving logs to the external
database. Now collect the reports manually.
Solving the above problems are not found
February 3rd, 2014 7:07am
So you are pulling the information straight out of SQL?
February 3rd, 2014 8:32am
Yes, i select the desired information using sql query.
February 3rd, 2014 8:41am
ok cool - i'll give that a go
February 3rd, 2014 8:44am
Any chance you can share some example scripts?
February 3rd, 2014 5:19pm
PashaZ, any possibility of sharing the queries you are using? I am not much of SQL guy and could use a steer in the right direction....Please?
February 4th, 2014 11:26am