Joe,
I'll see what I can scrape together and send to you in private e-mail next
week... along with how the specific reports were generated so there won't be
any confusion on the setings for the various options within the report
generator.
Thanks!
------------------------------------------------------------
Bryan Harrell, SPII
Network Infrastructure - Tallahassee
Fla. Dept of Revenue
(850)-921-0700 SunCom 291-0700
------------------------------------------------------------
>>> [EMAIL PROTECTED] 11/10/2005 11:33 AM >>>
Bryan,
In this case a picture is worth a thousand words. Could you give me
examples off-list?
PDF or Doc exports would be fine along with either the report jobs used
(cstatrpt.ini) or a detailed description.
If I see the issue I may need a copy of the raw log data as well.
Joe
On Wed, 09 Nov 2005 15:57:24 -0500, Bryan Harrell
<[EMAIL PROTECTED]> wrote:
> Joe,
>
> Thanks for the info. I considered the loss of this setting a nuisance
> since I figured out how to go about making it work again. I saw the
> reply from Bruce who said he set it up with a System DSN instead of the
> User DSN and I'll test it later when I have more time, but your comments
> about it being set up in the User DSN made total sense and would
> definitely explain the oddity since I log in with the WUG Domain Service
> account most of the time that we created to let it access the NT servers
> in the domain as needed without a lot of hassles and to let me keep the
> system as consistent as we can to avoid any surprises.
>
> One other nuisance that I haven't had time to dive into yet, but
> something we noticed when running the various reports (including the
> Outage Report) and comparing the various performance reports for
> different servers where the number of outages is reported, we noticed
> that they rarely equal for the same period of time with the
> Pre-Configured Outage report... Why is this, isn't an outage an outage
> regardless of how long it is?
>
> Because of this anomaly, our management has shied away from using the
> WUG reports so I haven't spent too much time trying to figure it out as
> I mainly use WUG for an outage detector and T-shooting tool to quickly
> isolate where a problem is based on what I can and can't see?
>
> Thanks again!
>
> ------------------------------------------------------------
> Bryan Harrell, SPII
> Network Infrastructure - Tallahassee
> Fla. Dept of Revenue
> (850)-921-0700 SunCom 291-0700
> ------------------------------------------------------------
>
>
>>>> [EMAIL PROTECTED] 11/08/2005 1:11:06 PM >>>
> Bryan you are correct you don't need to restart WhatsUp Gold when you
> make
> ODBC DSN changes.
> Note that we are using a user DSN and not a system DSN. So if you
> installed as one user id and then login with another user id you will
> not
> have the wugstatdata and WUGSNMP DSN's.
>
> Here is how the system works:
> WUG writes performance stats data to the ST-yyy-mm-dd.tab files on a
> hourly basis (by default).
>
> Each time you run a report the data gets written to the
> wugstatsdata.tab
> file.
>
> Cstatrpt.exe uses the Crystal Reports API to access data in
> wugstatsdata.tab via the ODBC DSN.
>
> Regards,
>
> Joe
>
> On Tue, 08 Nov 2005 08:30:54 -0500, Bryan Harrell
> <[EMAIL PROTECTED]> wrote:
>
>> Yea, this happens to me occasionally and I haven't figured out what
> it
>> is that causes WUGSTATDATA to disappear, but searching on your error
>> message ("Cannot Open SQL server.") in the knowledge base will give
> you
>> this link to check out and has always solved this issue for me (in
> fact
>> I keep it book marked with the rest of my WUG book marks so I can
> avoid
>> having to search for it every time). The final thing it asks you to
> do
>> is to restart WUG after it's been configured, but I've never had to
> do
>> that to get a report out of it, so give the instructions a try as far
> as
>> getting the data source configured and then run your report:
>>
>> http://support.ipswitch.com/kb/WG-20000306-DM01.htm
>>
>>
>> ------------------------------------------------------------
>> Bryan Harrell, SPII
>> Network Infrastructure - Tallahassee
>> Fla. Dept of Revenue
>> (850)-921-0700 SunCom 291-0700
>> ------------------------------------------------------------
>>
>>
>>>>> [EMAIL PROTECTED] 11/07/2005 4:54:34 PM >>>
>> I also created it as a System DSN which I would think is appropriate
>> for
>> access by an NT Service. Same thing. The book also says that the
> data
>> is
>> stored in wugstats.log which doesn't exist on my server.
>> If someone could take the time, please post your ODBC settings for
>> this. I
>> am running Wug 8.04
>> Thanks,
>> bruce meyer
>>
>> _____
>>
>> From: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] On Behalf Of Meyer,
>> Bruce
>> Sent: Monday, November 07, 2005 4:39 PM
>> To: '[email protected]'
>> Subject: [WhatsUp Forum] Problems with reports
>>
>>
>> I am trying to generate some of the canned reports.
>> When I click on 'Do Report' of Avail_Month I get;
>> Cannot Open SQL server.
>> In the focus bar it says:
>> Report Job Failed. Error: 599:2 Avail_Month
>> Doing some research It seems it is trying to use a Data Source
> named;
>> wugstatdata.tab
>> I see in my ODBC configuration no such, file, system or user DSN
>> exists.
>> I look at page 10 of the book and it seems that if it doesn't exist,
> I
>> can
>> create it.
>> So I select user DSN, and Microsoft txt driver, then select the path
> to
>> the
>> file named
>> wugstatdata.tab which is:
>> c:\program files\whatsup
>> gave it the DSN name of WUGSTATDATA.TAB
>> and description of Whats Up gold user DSN.
>> Restarted WUG, and it still doesn't seem to be able to create the
>> report. I
>> found no reference to this on their web site.
>> ODBC was installed prior to installing WUG over a year ago. I don't
>> know if
>> the reports ever worked or not.
>> Any help will be appreciated.
>> Bruce D. Meyer, CCNA, MCSE
>> Network Analyst
>> City of Columbia, SC
>>
>> Please visit http://www.ipswitch.com/support/mailing-lists.html
>> to be removed from this list.
>>
>> An Archive of this list is available at:
>> http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
>>
>
>
>
>
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
> An Archive of this list is available at:
> http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
>
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
> An Archive of this list is available at:
> http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
>
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
