clude anything you want in the order
you wantbut as said "thinking of"
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Thu Nov 06 9:12 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question.
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Thu Nov 06 9:12 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question JOIN new
interchange field or change the meaning ofthe current one
I hadn't noticed that.
Is this something that c
I hadn't noticed that.
Is this something that could be added to the interchange output? I could use this just
as easily as the number of current state cycles.
Mike
>>> [EMAIL PROTECTED] 11/06/03 02:58PM >>>
In the HTML template based output we can show how long something is
within it's current
12:30PM >>>
Again that's not the question
What exactly should be kept of the stats over a shutdown of SA
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Fri Oct 24 4:39 PM
To: [EMAIL PROTECTED]
Subje
Sent: Thu Nov 06 8:52 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Thanks, but that still doesn't get around the issue of checks that never
change status, or how long they have been in their current status.
Mike
>>> [EMAIL PROTECTED] 11/06/03
#x27;s not the question
What exactly should be kept of the stats over a shutdown of SA
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Fri Oct 24 4:39 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database que
>>> [EMAIL PROTECTED] 10/24/03 12:30PM >>>
Again that's not the question
What exactly should be kept of the stats over a shutdown of SA
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Fri Oc
: [SA-list] Statistical database question
Yes it's the correct one
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 7:36 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
-list] Statistical database question
Yes it's the correct one
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 7:36 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Apologies to al
ROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 7:36 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Apologies to all for that bone-headed move
Is this the right registry entry?
[HKEY_LOCAL_MACHINE\SOFTWARE\DBU Consulting\Servers Alive\StartUp]
"
;>>
Yes it's the correct one
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 7:36 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Apologies to all for that bone-hea
ROTECTED] 10/27/03 12:27PM >>>
That's not what I'm seeing
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 6:15 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question...
Yes it's the correct one
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 7:36 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Apologies to all for that bone-headed move!!!
7;m seeing
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 6:15 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
That's correct. However, stopping and restarting SA with the
PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
That's correct. However, stopping and restarting SA with the device down
resets those to the time and date of the first cycle of new instance and
NRD = 1 again.
Mike
>>> [EMAIL PROTECTED] 10/27/03 11:
That's not what I'm seeing
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 6:15 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
That's correct. Howeve
last status change
If you have a host that is down check the NRD parameter...that one
should change
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 4:50 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Stat
Shook
Sent: Mon Oct 27 5:12 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Sorry, I meant to type TLSC and DLSC in my previous post. NRD does
infact change from a 0 to a 1 when down.
Mike
>>> [EMAIL PROTECTED] 10/27/03 10:55AM >>>
TLC/DLC are the
that is down check the NRD parameter...that one
should change
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 4:50 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
I took a qui
hecking
> And tell me if that does what it should do.
>
> (should already work with the current beta'sit was
> something very old that is still in the code...)
>
>
>
>
> dirk.
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
Shook
Sent: Mon Oct 27 4:50 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
I took a quick spin through my Hosts file and if in fact #TLC and #DLC
are the time and date of the last status change, then they are wrong.
That is, they seem to be the time and date that the
de...)
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Fri Oct 24 4:33 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
I agree with the concept of slowing down the cycles during off peak
ho
ollar resort prison. No, no, no!"
Michael Bolton, Office Space
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Friday, October 24, 2003 7:32 AM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question..
Define "doesn't seem to be working"
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Mon Oct 27 4:39 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
That doesn't see
is still in the code...)
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Fri Oct 24 4:33 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
I agree with the concept of slowing down the cycles during o
D] 10/24/03 12:30PM >>>
Again that's not the question
What exactly should be kept of the stats over a shutdown of SA
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Fri Oct 24 4:39 PM
To: [EMAIL PROTEC
Don't even understand the layout :-)
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Fri Oct 24 7:53 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Well, what if you saved and reloade
resort prison. No, no, no!"
Michael Bolton, Office Space
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Friday, October 24, 2003 7:32 AM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Well, the
The statslog will generate an record for an entry when that entry
changes status
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jack Lyons
Sent: Fri Oct 24 6:46 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [SA-list] Statistical databas
I would like the just the hosted (for uniquesness) and the pretty name.
> -Original Message-
> From: Dirk Bulinckx [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 24, 2003 10:29 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [SA-list] Statistical database question
>
e-
> From: Michael Shook [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 24, 2003 10:39 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [SA-list] Statistical database question
>
> Maybe a new database table with output set on it's own semi-daily schedule
&
Again that's not the question
What exactly should be kept of the stats over a shutdown of SA
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Fri Oct 24 4:39 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statis
l Bolton, Office Space
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Friday, October 24, 2003 7:32 AM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Well, the columns you currently write are fine, BUT
I ha
consider adding a feature that would append the list
of hosts in the SAlive host file to the monthly stat log when he rotates the
logs monthly?
Dirk?
> -Original Message-
> From: Michael Shook [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 24, 2003 8:32 AM
> To: [EMAIL PR
I think he is talking about the state of being up in the stats log.
> -Original Message-
> From: Dirk Bulinckx [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 24, 2003 10:20 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [SA-list] Statistical database question
>
>
tes the logs monthly?
Dirk?
> -Original Message-
> From: Michael Shook [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 24, 2003 8:32 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [SA-list] Statistical database question
>
> Well, the columns you currently write are
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Well, the columns you currently write are fine, BUT
I have been tasked to create monthly / annual UP/DOWN stats for the
major devices. What I do now is sum all of the minutes where the
previousstatus is X. The
hly?
Dirk?
> -Original Message-
> From: Michael Shook [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 24, 2003 8:32 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [SA-list] Statistical database question
>
> Well, the columns you currently write are fine, BUT
&g
Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Friday, October 24, 2003 7:32 AM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] Statistical database question
Well, the columns you currently write are fine, BUT
I have been tasked to c
Well, the columns you currently write are fine, BUT
I have been tasked to create monthly / annual UP/DOWN stats for the major devices.
What I do now is sum all of the minutes where the previousstatus is X. The problem
comes in that SA doesn't regularly output state stats to this table. I onl
What exact info should be kept?
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Michael Shook
Sent: Thu Oct 23 10:40 PM
To: [EMAIL PROTECTED]
Subject: [SA-list] Statistical database question
If I understand the process correctly, when the
Darn SQL people, finding the odd cases... take a look at the attached doc...
Roland Gaspar
Tel.: (514) 398-7880 xt 8603
ICQ # 1355591
www.roland-gaspar.com
>>> [EMAIL PROTECTED] 04/03/03 09:46AM >>>
Changing it from minutes to seconds will only influence newly create
Changing it from minutes to seconds will only influence newly created
records, SA will not modify any records that are already in the DB. Also
the structure of the DB/table will not change if you change from minutes to
seconds.
dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:
43 matches
Mail list logo
