RE: Netview NT with SQL DB

[DE SCHUTTER EMMANUEL <Emmanuel.DESCHUTTER@fortisbank.com>]

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
>