nv-l
[Top] [All Lists]

RE: Netview NT with SQL DB

To: nv-l@lists.tivoli.com
Subject: RE: Netview NT with SQL DB
From: "S. Varathu, IBM" <Varathu@bom4.siemens.co.in>
Date: Wed, 8 Nov 2000 15:26:17 +0530
De Schutter,

Thanks a lot. It's working good as per your tips.

varadhu

> ----------
> From:         DE SCHUTTER
> EMMANUEL[SMTP:Emmanuel.DESCHUTTER@fortisbank.com]
> Sent:         Tuesday, November 07, 2000 5:45 PM
> To:   'IBM NetView Discussion'
> Subject:      RE: [NV-L] Netview NT with SQL DB
> 
> As you probably saw, the IP addresses in the snmpcollectdata table have
> been
> converted from text to integer. To see the ip addresses that correspond to
> the integer values, you can execute the following SQL statement :
> 
> SELECT IP= convert( varchar(3), convert( int, convert(binary(1),
> ipAddress)
> )) + '.' +
>            convert( varchar(3), convert( int, convert(binary(1),
> (ipAddress
> & 0xFF00) / 0x100 ))) + '.' +
>            convert( varchar(3), convert( int, convert(binary(1),
> (ipAddress
> & 0xFF0000) / 0x10000 ))) + '.'+
>            convert( varchar(3), convert( int, convert(binary(1),
> (ipAddress
> & 0xFF000000) / 0x1000000 )))
> 
> FROM snmpCollectData
> 
> If you want to export the snmpcollectdata table to another database ( like
> MS Access ), I propose you to create a SQL view instead of executing
> everytime the above statement.
> 
> CREATE VIEW vSnmpCollectData AS
> SELECT m.MibName,
>        s.Instance,
>        IP=    convert( varchar(3), convert( int, convert(binary(1),
> s.ipAddress) )) + '.' +
>               convert( varchar(3), convert( int, convert(binary(1),
> (s.ipAddress & 0xFF00) / 0x100 ))) + '.' +
>               convert( varchar(3), convert( int, convert(binary(1),
> (s.ipAddress & 0xFF0000) / 0x10000 ))) + '.'+
>               convert( varchar(3), convert( int, convert(binary(1),
> (s.ipAddress & 0xFF000000) / 0x1000000 ))),
>       s.StartTime,
>       s.EndTime,
>       s.TheValue,
>       s.StationID
>       
> FROM SnmpCollectData s, MibLookup m
> WHERE s.MibOBJEct = m.MibID
> 
> 
> Regards
> 
> E. De Schutter
> Compaq
> 
> -----Original Message-----
> From: S. Varathu, IBM [mailto:Varathu@bom4.siemens.co.in]
> Sent: Tuesday, November 07, 2000 12:09 PM
> To: 'IBM NetView Discussion'
> Subject: RE: [NV-L] Netview NT with SQL DB
> 
> 
> Thanks Leslie..
> 
> I have installed nv 6.01 and sql 7.0 . It's storing the data on sql db.
> but
> unfortunately IPadress format is different. I cann't convert proper way. 
> 
> Even if i open the Snmpcollect.mdb file in access, IP address format is
> not
> proper. like if IP address is 132.186.76.3, it is showing some numbers. 
> 
> is there any way i can collect data and store any format whch can be used
> for long time historical trend analysis.? This problem only on NT.
> 
> Thanks,
> varadhu
> > ----------
> > From:       Leslie Clark/Southfield/IBM[SMTP:lclark@us.ibm.com]
> > Sent:       Friday, November 03, 2000 7:22 PM
> > To:         IBM NetView Discussion
> > Subject:    Re: [NV-L] Netview NT with SQL DB
> > 
> > You really need to get to 6.01  before expecting snmpCollect to work
> > on Netview for NT. A lot of improvements were made since 5.1
> > 
> > Cordially,
> > 
> > Leslie A. Clark
> > IBM Global Services - Systems Mgmt & Networking
> > Detroit
> > 
> > 
> > "S. Varathu, IBM" <Varathu@bom4.siemens.co.in>@tkg.com on 11/03/2000
> > 07:41:54 AM
> > 
> > Please respond to IBM NetView Discussion <nv-l@tkg.com>
> > 
> > Sent by:  owner-nv-l@tkg.com
> > 
> > 
> > To:   "'nv-l@tkg.com'" <nv-l@tkg.com>
> > cc:
> > Subject:  [NV-L] Netview NT with SQL DB
> > 
> > 
> > 
> > 
> > Setup - Netview 5.1, SQL server 6.0.
> > 
> > NetView unable to store the data in SQL database. In SNMPcollect daemon,
> > it
> > is configured for both internal files and SQL db. I could view the data
> > from
> > flat files. But unable to view the data from SQL db. I have run the
> > create_sqldb.bat from \usr\ov\databases\odbc dir which in turn created
> the
> > "NetvieDb' and all necessary tables. But snmpcollect data's are not
> > stored.
> > 
> > Where i am doing mistake?
> > 
> > Varadhu
> > 
> > 
> >
> _________________________________________________________________________
> > NV-L List information and Archives: http://www.tkg.com/nv-l
> > 
> > 
> >
> _________________________________________________________________________
> > NV-L List information and Archives: http://www.tkg.com/nv-l
> > 
> _________________________________________________________________________
> NV-L List information and Archives: http://www.tkg.com/nv-l
> _________________________________________________________________________


<Prev in Thread] Current Thread [Next in Thread>

Archive operated by Skills 1st Ltd

See also: The NetView Web