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
> _________________________________________________________________________
|