How many TMG do you have in this array? If more than one , you only have one reporting server – are you looking at that one? You don’t want to query the reporting DB directly (it’s transient). If you want to build custom reports, do it using your own SSRS instance; not the TMG instance. Jim From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx] On Behalf Of LEANDRO DOS S. FERREIRA - TI Sent: Tuesday, August 02, 2011 4:37 AM To: isalist@xxxxxxxxxxxxx Subject: [isalist] ENC: Re: Infor - Report Servers TMG Jim, Spying the TMG structure we can find these details: There is a SQL instance->database MSFW->ISALOG_date_FWS and ISALOG_date_WEB where TMG is recording the activities. These databases have the tables FirewallLog and WebProxyLog. (These tables I can move to my enterprise SQL Server and change TMG to record there). It works fine. And we notice the reports for the local Reporting Services are consuming tables/procs from a SQL Instance->database ISARS-> ISA_RS_Db. This database have a lot of tables that appear to be the summary . Even if I point my TMG to record everything to the local sql intances, I can’t get values on my reports because the ISA_RS_Db is empty. So our question is: what I have to configure to fill this database? De: LEANDRO DOS S. FERREIRA - TI Enviada em: segunda-feira, 1 de agosto de 2011 22:34 Para: ESIO DA SILVA NUNES - TI Assunto: Enc: [isalist] Re: Infor - Report Servers TMG Fyi Regards Leandro dos Santos Ferreira Enviado do meu disposito Blackberry Sent from my Blackberry Device De: Jim Harrison [mailto:Jim@xxxxxxxxxxxx]<mailto:[mailto:Jim@xxxxxxxxxxxx]> Enviada em: Monday, August 01, 2011 09:33 PM Para: isalist@xxxxxxxxxxxxx<mailto:isalist@xxxxxxxxxxxxx> <isalist@xxxxxxxxxxxxx<mailto:isalist@xxxxxxxxxxxxx>> Assunto: [isalist] Re: Infor - Report Servers TMG Leandro, You can build your own custom reports ion in your external SSRS instance all day long – you just won’t get them to display in the TMG manglment console. In fact, if you want to make a package of these custom reports, I’d be happy to host them on isatools.org. Jim From: isalist-bounce@xxxxxxxxxxxxx<mailto:isalist-bounce@xxxxxxxxxxxxx> [mailto:isalist-bounce@xxxxxxxxxxxxx]<mailto:[mailto:isalist-bounce@xxxxxxxxxxxxx]> On Behalf Of LEANDRO DOS S. FERREIRA - TI Sent: Monday, August 01, 2011 2:57 PM To: isalist@xxxxxxxxxxxxx<mailto:isalist@xxxxxxxxxxxxx> Subject: [isalist] RES: Infor - Report Servers TMG Hi Jim, tks for your reply. Is there any chance to salve the log into sql server and report server get it ? is the TMG enterprise is different ? Leandro De: isalist-bounce@xxxxxxxxxxxxx<mailto:isalist-bounce@xxxxxxxxxxxxx> [mailto:isalist-bounce@xxxxxxxxxxxxx]<mailto:[mailto:isalist-bounce@xxxxxxxxxxxxx]> Em nome de Jim Harrison Enviada em: segunda-feira, 1 de agosto de 2011 18:48 Para: isalist@xxxxxxxxxxxxx<mailto:isalist@xxxxxxxxxxxxx> Assunto: [isalist] Re: Infor - Report Servers TMG Leandro, TMG can generate reports only from the TMG-local SSRS instance. Jim From: isalist-bounce@xxxxxxxxxxxxx<mailto:isalist-bounce@xxxxxxxxxxxxx> [mailto:isalist-bounce@xxxxxxxxxxxxx]<mailto:[mailto:isalist-bounce@xxxxxxxxxxxxx]> On Behalf Of LEANDRO DOS S. FERREIRA - TI Sent: Monday, August 01, 2011 2:19 PM To: isalist@xxxxxxxxxxxxx<mailto:isalist@xxxxxxxxxxxxx> Subject: [isalist] Infor - Report Servers TMG Hi, I have this scenario. One server running a TMG and one server + sql server 2008 and another server with report server sql 2008. I adjusted the TMG log to save in the sql server 2008 (reporting log) and report server sql 2008 to get information about this log, or be, the TMG is salving data into mssql server and generating the reports from another sql server report server. When I try get some reports from inside report server I cannot get any value. How can I setup the TMG get this information from report server ? Regards Leandro Se for indispensável, imprima no método econômico e pense na utilização do verso da folha. Preserve o meio ambiente!