[nv-l] SQL Query of SNMP Collected Data (ifInOctets/ifOutOctets) from a
NV 7.1.3 FP3 SOLARIS
I have setup SNMP Data collections
(ifInOctets/ifOutOctets) for some switches in order to
determine inactive ports during a specific period.
The Data collected are stored in the Database (colData
Table) by running the /usr/OV/bin/nvColToSQL command.
Looking at colData table schema in the RDBMS, there is
a column called instance; ans when performing an SQL
(Select * from colData) query, I get the column
"instance" with values over 300 (I do not have a Node
with more than 300 interface, therefore that should
not be the ifIndex value ...)
When I run the Command /usr/OV/bin/nvHostSumCol -O
/snmpColData.log, I get another column called instance
wich is more representative of the ifIndex value for
each Interface for a given Node.
Q1: How do I get the IfIndex Values for snmpCollect
data stored in a RDBMS using an SQL Select statement
for a specific Node?
Q2: Anybody knows what is the SQL query performed by
the binary /usr/OV/bin/nvHostSumCol?
Q3: Any Other Suggestion?
"ALLEZ LES LIONS INDOMPTABLES"
Post your free ad now! http://personals.yahoo.ca
Archive operated by Skills 1st Ltd
See also: The NetView Web