Thanks for the insight James,
I'm trying in Crystal now, but have not been to any training classes on it so it's hard to figure out the best way to do it. Also, I see an issue with creating an ODBC connection to the EV-yyyymmdd.Tab files, in that it changes every week. I guess I could write a batch file that will copy the file to a common name every week and then be able to run my report.
Why is it that the little things what we want products to do always seem to be the biggest "challenges" we face?
---------------------------------------------
Jeff Benedict
Tech Services
Lan/Wan Support
228-214-5465
-----Original Message-----
From: James Amann [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 29, 2003 12:47 PM
To: [EMAIL PROTECTED]
Subject: Re: [WhatsUp Forum] Report Question
I had to write a perl script for this purpose, it is not as easy as it looks and there is no report in wug to do it. I have been told it can be doen with crystal reports although as of yet I have been unable to purchase due to lack of funds.
James Amann - GSU
>>> [EMAIL PROTECTED] 08/29/03 11:47AM >>>
I've been tasked with generating a daily report that shows which devices (in this case routers) were down for a 24 hour period (3p-3p) and for how long. I have 122 maps (one for each branch w/ a router). It just needs to be a simple table type report like the example below: Any Ideas?
Branch 1
Date Device Time Status Duration
08/28/03 Router 11:55 Down
08/28/03 Router 12:00 Up 00:05
08/29/03 Router 08:00 Down
08/29/03 Router 08:01 Up 00:01
Branch 2
Date Device Time Status Duration
08/28/03 Router 12:55 Down
08/28/03 Router 14:00 Up 01:05
---------------------------------------------
Jeff Benedict
Hancock Bank
Tech Services
Lan/Wan Support
228-214-5465
It's not a matter of Having what you want,
It's a matter of Wanting what you have!
This e-mail and any files transmitted with it are the property of Hancock Holding Company and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.
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/
This e-mail and any files transmitted with it are the property of Hancock Holding Company and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.
