[isalist] Re: ENC: Re: ENC: Re: Infor - Report Servers TMG

  • From: Jim Harrison <Jim@xxxxxxxxxxxx>
  • To: "isalist@xxxxxxxxxxxxx" <isalist@xxxxxxxxxxxxx>
  • Date: Thu, 4 Aug 2011 05:35:45 +0000

Stop playing in the DB; this is unsupported and is only likely to make things 
worse.
You need to verify that the reporting server configuration is configured 
properly.
http://isatools.org/tools/ClearTmgRptSvrs.wsf is a tool that will tell you if 
your reporting server configuration is bad and remove the bad configuration.
From there, you’ll need to redefine the reporting server.

From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx] On 
Behalf Of LEANDRO DOS S. FERREIRA - TI
Sent: Wednesday, August 03, 2011 5:39 AM
To: isalist@xxxxxxxxxxxxx
Subject: [isalist] ENC: Re: ENC: Re: Infor - Report Servers TMG

Jim, we have 1 in this array.

Actually, for this moment we are just trying to extract any information 
considering one TMG server, recording data in its inner SQL Express and inner 
Report Server Express.
We aren’t trying to extract directly from the DB, we are running the native 
reports and they are coming empty, so investigating the problem, we noticed the 
db used by the reports doesn’t has any data.
We didn’t understood why the reports are pointing to an empty database. Are we 
forgetting to configure any TMG parameter?

Leandro

De: LEANDRO DOS S. FERREIRA - TI
Enviada em: terça-feira, 2 de agosto de 2011 20:42
Para: ESIO DA SILVA NUNES - TI
Assunto: Enc: [isalist] Re: ENC: 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: Tuesday, August 02, 2011 08:05 PM
Para: isalist@xxxxxxxxxxxxx<mailto:isalist@xxxxxxxxxxxxx> 
<isalist@xxxxxxxxxxxxx<mailto:isalist@xxxxxxxxxxxxx>>
Assunto: [isalist] Re: ENC: Re: Infor - Report Servers TMG

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> 
[mailto:isalist-bounce@xxxxxxxxxxxxx]<mailto:[mailto:isalist-bounce@xxxxxxxxxxxxx]>
 On Behalf Of LEANDRO DOS S. FERREIRA - TI
Sent: Tuesday, August 02, 2011 4:37 AM
To: isalist@xxxxxxxxxxxxx<mailto: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!

Other related posts: