|
I use
the following query on sqlserver database to produce an outage
report.
It
could be modified to produce availability also.
Note
that the ipaddress is in Netview format.
SELECT
timeStart,
datepart(minute,(timeStop - timeStart))
FROM
NVuptimeTransition
WHERE ipAddress = '2047885322' AND
upOrDown = '-1'
and timeStart between
(convert(float,%Date1%)) and
(convert(float,%Date2%))
order by (convert(float,timeStart))
desc;
Regards,Bob Rumsey
Data Communications
Specialist,
Telecommunications
Services
ActewAGL
you can look at the Down and UP events in trapd.log and use the date of the
events to calculate the down time.
Salutations, /
Regards,
Francois Le Hir
Network Projects & Consulting
Services
IBM Global Technology Services
************************************************************************
*PLEASE NOTE* This email and any attachments may
be confidential. If received in error, please delete all
copies and advise the sender. The reproduction or
dissemination of this email or its attachments is
prohibited without the consent of the sender.
WARNING RE VIRUSES: Our computer systems sweep
outgoing email to guard against viruses, but no warranty
is given that this email or its attachments are virus free.
Before opening or using attachments, please check for
viruses. Our liability is limited to the re-supply of any
affected attachments.
Any views expressed in this message are those of the
individual sender, except where the sender expressly,
and with authority, states them to be the views of the
organisation.
************************************************************************
|
_______________________________________________
NV-L mailing list
NV-L AT lists.ca.ibm DOT com
Unsubscribe:NV-L-leave AT lists.ca.ibm DOT com
http://lists.ca.ibm.com/mailman/listinfo/nv-l (Browser access limited to
internal IBM'ers only)
|
