Create a join to uptimeSummaryTable.ipAddress to get the "NodeName". Note
that this NodeName will be the name of the node that the device was
initially discovered by. This means that if the nodename changes (say by
changing the hosts file), then external queries to this database must still
be based on the initially discovered node name, or you can rediscover the
device so uptimeSummaryTable.ipAddress will change accordingly.
Also note that the last character of every uptimeSummaryTable.NodeName is
Chr(0), so you must take this into account when defining queries. I cannot
understand why Tivoli has done this, but can only assume that it is due to
some Unix porting issue.
FYI - the ipAddress value is actually a 32 bit decimal ip address.
Regards,
Matt Moore
-----Original Message-----
From: M Robert Prakash [mailto:robertprakash@CHENNAI.TCS.CO.IN]
Sent: Tuesday, 22 February 2000 01:08
To: NV-L@UCSBVM.ucsb.edu
Subject: Re: Reg Bandwidthutilhdx Mib - Netview NT
Hi
Thanks Matt Moore for the reply.I created a blank database and created link
table to snmpcollect_db.mdb,but it is not showing IP address in the correct
form.This is what I get.But when I right click on any router ,it is showing
the
IP address correctly in the Collected data column.Any clues..
|-----------+----------+------------+----------------+---------------->
| | | | | |
| mibObject | instance | ipAddress | startTime | endTime |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| theValue | stationID | theKey | compressionFactor |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 6 | 4 | 156936384 | 2/17/00 | 2/17/00 |
| | | | 12:26:42 PM | 1:26:43 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 0.09 | 2 | 49655 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 6 | 4 | 1095767212 | 2/17/00 | 2/17/00 |
| | | | 12:26:42 PM | 1:26:42 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 0.00 | 2 | 49656 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 6 | 5 | 156936384 | 2/17/00 | 2/17/00 |
| | | | 12:26:42 PM | 1:26:42 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 83.14 | 2 | 49657 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 6 | 5 | 1095767212 | 2/17/00 | 2/17/00 |
| | | | 12:26:42 PM | 1:26:42 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 0.00 | 2 | 49658 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 37 | 2 | 1040296128 | 2/17/00 | 2/17/00 |
| | | | 12:26:42 PM | 1:26:42 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 3,994.87 | 2 | 49659 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 37 | 3 | 1040296128 | 2/17/00 | 2/17/00 |
| | | | 12:26:40 PM | 1:26:40 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 1,517.30 | 2 | 49660 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 6 | 1 | 1364240576 | 2/17/00 | 2/17/00 |
| | | | 12:26:44 PM | 1:26:44 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 1.89 | 2 | 49661 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 6 | 2 | 1364240576 | 2/17/00 | 2/17/00 |
| | | | 12:26:44 PM | 1:26:44 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 274.21 | 2 | 49662 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 6 | 3 | 1364240576 | 2/17/00 | 2/17/00 |
| | | | 12:26:44 PM | 1:26:44 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 2.69 | 2 | 49663 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
|-----------+----------+------------+----------------+---------------->
| | | | | |
| 9 | 0 | 1330713772 | 2/17/00 | 2/17/00 |
| | | | 12:56:48 PM | 1:26:48 PM |
| | | | | |
|-----------+----------+------------+----------------+---------------->
>------------+-----------+----------+-------------------|
| | | | |
| 1.00 | 2 | 49664 | 0 |
| | | | |
>------------+-----------+----------+-------------------|
Thanks again
With Regards
Robert
"Matthew Moore (DSL AK)" <MattM@DATACOM.CO.NZ> on 02/09/2000 01:18:24 AM
Please respond to Discussion of IBM NetView and POLYCENTER Manager on
NetView
<NV-L@UCSBVM.ucsb.edu>
To: NV-L@UCSBVM.ucsb.edu
cc: (bcc: M Robert Prakash/Hardware/TCSCHENNAI)
Subject: Re: Reg Bandwidthutilhdx Mib - Netview NT
Create a new blank access database, and create new link tables to
snmpcollect_db.mdb (or tess_db.mdb for the events database). You'll have to
develop your own reports though.
Regards,
Matt Moore
-----Original Message-----
From: M Robert Prakash [mailto:robertprakash@CHENNAI.TCS.CO.IN]
Sent: Wednesday, 9 February 2000 01:00
To: NV-L@UCSBVM.ucsb.edu
Subject: Re: Reg Bandwidthutilhdx Mib - Netview NT
Hi
Thanks again for your response.I tried the "at" command,it did not list
snmpodump, but it had two entries for nvsniffer.We are not ready for Tivoli
Decision support yet.My responsibility now is to monitor the serial ports of
about 8 routers we have and then produce reports on Bandwidth
utilization.May be
I can collect data in longer time intervals,say every four hours and produce
monthly or weekly reports.I have found that I can compress the collected
data
using snmpodump command.Last time I tried that,but it produced erroneous
data.I
have purged my database and started again and since yesterday it has been
collecting hourly data.May be I will try snmpodump again.Its a bit
embarassing
for me for not being able to produce proper reports as we have also got an
evaluation copy of Spectrum with us and it seems to be very good at
producing
reports.
Is there a way of integrating the data collect with an RDBMS.The database
guide
I possess has details only of Netview for Unix where RIM comes in to play.I
already have Access installed but I am not able to open the
Snmpcollect_db.mdb
file present in the usr/ov/databases/odbc directory.I even copied it
somewhere
else with a different name,it was still not opening.The error was the I did
not
have proper database rights to access that.Any clues...
With Best Regards
Robert
Leslie Clark <lclark@US.IBM.COM> on 02/08/2000 03:14:11 AM
Please respond to Discussion of IBM NetView and POLYCENTER Manager on
NetView
<NV-L@UCSBVM.ucsb.edu>
To: NV-L@UCSBVM.ucsb.edu
cc: (bcc: M Robert Prakash/Hardware/TCSCHENNAI)
Subject: Re: Reg Bandwidthutilhdx Mib - Netview NT
It is my understanding that the grapher on NT does not show all collected
data as the grapher on Unix does. It only shows the last cycle since you
stop/started snmpCollect. The last time I asked support about this I was
advised that the best route to go was to implement the Tivoli Decision
Support product, and use the Netview Guides to view and analyse the
data collected with Netview. If the data is actually in the database, you
may
be looking at a Feature.
Cordially,
Leslie A. Clark
IBM Global Services - Systems Mgmt & Networking
Detroit
==========================================================================
When you select 'Schedule snmpcollect data to delete' Netview creates a
snmpodump scheduled command. Selecting 'do no schedule database purging'
should remove the scheduled entry. Run "at" from the command line to see if
there is still a snmpodump entry. If it is still there, you can safely
delete it by running "at x /delete" where x is the ID of the snmpodump
entry.
Regards,
Matt Moore
-----Original Message-----
From: M Robert Prakash [mailto:robertprakash@CHENNAI.TCS.CO.IN]
Sent: Tuesday, 8 February 2000 00:51
To: NV-L@UCSBVM.ucsb.edu
Subject: Reg Bandwidthutilhdx Mib
Hi
I am pretty new to Netview,first of all I want to thank James shanks for
his
reply to my first mail,it was informative.But I din't put further questions
because I had not read the Netview manuals then and I was just getting
started.I
am using Netview for NT ver 5.1.1.
I have a question reg the Bandwidthutilhdx mib.By default the routers
smartset
starts collecting Bandwidthutilhdx Mib data for all routers.This data can
be
later saved or viewed as a graph.But I find that the collected data does
not
last more than 1 or 2 days .So everytime I view the data,I see only the
data
for
the last two days.So if I have been collecting for a week,the previous 5
days
data I am not able to see.Under the options->server setup, files tab,there
is an
option-'Schedule snmpcollect data to delete',which was configured to purge
the
data everyday at 11.00pm, which I have changed to 'do no schedule database
purging' and I have restarted the Netview server.It doesnt seem to be
working.
I installed netview on a server with no database software like MS-Access or
Sql
server.So it created its own Access database to store data.Later I
installed
MSOffice,so MSAccess also got installed.Do I have to do any
reconfiguration.Could this be the problem.
Thanks in advance
Robert
|