RE: [SA-list] Reporting in SA

Wed, 01 Feb 2006 05:15:06 -0800

Title: Message
True, but I asked our DBA how to set up a on-demand calculated up-times SQL statement against the entire interchange db, he nearly choked with laughter. I got the impression that reviewing 2million records and perfuming a calc would not be the way to go. Hence the SARunningTimes table. Also, we only keep 14 days of interchange data, but we want to see RunningTimes over a 30 day period.
 
Michael D. Shook
Technical Analyst
[EMAIL PROTECTED]
863 668 4477 (work)
863 860 4070 (cell)
863 665 1261 (fax)
www.saddlecrk.com
 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Bulinckx
Sent: Wednesday, February 01, 2006 7:57 AM
To: [email protected]
Subject: RE: [SA-list] Reporting in SA

The interchange logging comes already close...
 

Dirk.

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Shook
Sent: Wednesday, February 01, 2006 1:53 PM
To: [email protected]
Subject: RE: [SA-list] Reporting in SA

This of course could easily be a new feature of v6.
 
(hint-hint)
 
:-)
 
Michael D. Shook
Technical Analyst
[EMAIL PROTECTED]
863 668 4477 (work)
863 860 4070 (cell)
863 665 1261 (fax)
www.saddlecrk.com
 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibson, Richard (IHG)
Sent: Wednesday, February 01, 2006 5:03 AM
To: '[email protected]'
Subject: RE: [SA-list] Reporting in SA

Ah - I'd never used that feature. I've just been playing around with it and I think it would do the job nicely.
 
Thanks for the help guys.

Richard.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Shook
Sent: 31 January 2006 16:56
To: [email protected]
Subject: RE: [SA-list] Reporting in SA

What I do is have the interchange DB trigger a data insert into a custom running times table. I use this table to calculate the running time and uptimes for my servers.
 
This id using MS SQL as the DBMS.
 
Michael D. Shook
Technical Analyst
[EMAIL PROTECTED]
863 668 4477 (work)
863 860 4070 (cell)
863 665 1261 (fax)
www.saddlecrk.com
 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Bulinckx
Sent: Tuesday, January 31, 2006 10:56 AM
To: [email protected]
Subject: RE: [SA-list] Reporting in SA

you could use the html template to create a textfile and then use whatever tool to import that in a db.
 

Dirk.

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibson, Richard (IHG)
Sent: Tuesday, January 31, 2006 4:55 PM
To: '[email protected]'
Subject: RE: [SA-list] Reporting in SA

Hi Dirk,
 
We already use the template based HTML output, but unfortunately, each time the SA service is restarted, these stats are all lost and reset to the beginning. Is there anyway of capturing this data on the HTML page, but also out to a text file or database?

Thanks,

Richard.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Bulinckx
Sent: 31 January 2006 13:55
To: [email protected]
Subject: RE: [SA-list] Reporting in SA

The template based HTML output can be used for this too.
 

Dirk.

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibson, Richard (IHG)
Sent: Tuesday, January 31, 2006 11:17 AM
To: Servers Alive Support List ([email protected])
Subject: [SA-list] Reporting in SA

Is there any way of reporting on the results of the checks in SA, just like the results which are shown on the HTML page using the various fields. Is there any way of getting this same data in to a spreadsheet? Surely this data must all be kept somewhere and then it is purged when the SA service is restarted, which can be a pain. If I can gain access to the data which populates the output fields on the webpage then I can report on it. If not, then is there an easy way (maybe a third party tool) which I can use to manipulate the data in the statistics logging files?

Does that make sense?

Cheers,

Richard.

--------------------------------------
The information contained in this message is intended only for the use of the addressee. If the reader of this message is not the intended recipient or agent of the intended recipient, you are hereby notified that any dissemination, distribution, or copying of the message is strictly prohibited.

--------------------------------------
The information contained in this message is intended only for the use of the addressee. If the reader of this message is not the intended recipient or agent of the intended recipient, you are hereby notified that any dissemination, distribution, or copying of the message is strictly prohibited.

--------------------------------------
The information contained in this message is intended only for the use of the addressee. If the reader of this message is not the intended recipient or agent of the intended recipient, you are hereby notified that any dissemination, distribution, or copying of the message is strictly prohibited.

Reply via email to