RE: [nv-l] Inventory management through NetView

[usman.taokeer@s-iii.com]

Collins,

Hey thanks for the wonderful info on
reporting techniques, actually i 've been searching for a reporting tool
for a certain project and we were considering Magnum's CAP-Trend but the
price was redicullious, you've showed me a new way for that, can you kindly
share how do u generate reports on network performance (availability,downtimes,link
utilizations etc, u know what managment asks for). 

Actually its for a customer who has
outsourced their entire IT to us so we need to present them some reports
on the performance of the network for that we are using TEC+DatawareHouse
all i need is to find a way to extract info from the DataWarehouse in form
of NetWork Performance etc. 

Can you share your scripts and how you
transform that info into MSExcel? We are using NV 7.1.4FP3 on Windows BOX.

For Bandwidth utilization are you using
ifInOctets, i tried using that but it shows me the sum of bits coming in/out,
(the counter/value is always increasing) am i missing something, i was
trying to monitor our E1 links terminated on a Cisco 3745 Router!


Regards,
Usman Taokeer
Si3.

"Colin Mulkerrins" <Colin.Mulkerrins@anpost.ie>
Sent by: owner-nv-l@lists.us.ibm.com

14-07-05 04:29 PM

Please respond to
nv-l@lists.us.ibm.com

To	<nv-l@lists.us.ibm.com>
cc
Subject	RE: [nv-l] Inventory management through NetView

Usman,
 
You could try setting Definition
2 to isNode = TRUE (so the smartset true for sysObjectID AND isNode).
 If the isNode does not work I would compare the ovobjprint output
for the switch entry and the vlan entry and look for something unique to
either and filter on that.
 
As for prettifying the reports
for management - ah yes I know it well - I do not store NetView Data in
Datawarehouse so I do not know whether it would be useful or not.  I
briefly tried DB2 on the netview server but performance degradation made
me change back to flat files very quickly (anyway I think that there were
licencing issues with how you can use the data in DB2 for NetView).
 
What I normally do with any reporting
requirements is to write a script to extract what I need to a csv file
and use MS excel to generate the reports and graphs.  We run NetView
without discovery switched on so we manually manage what goes into the
map, hence I do not get many requests for reports on the hardware inventory.
 There is only an ongoing requierment for reporting on alerts (network
connectivity and performance). I manage all alerts through inhouse scripts
(fired from trap generated events) so I can format and log exactly what
I need and I use NetViews snmpCollection for ongoing bandwidth utilisation
reporting.
 
None of which is probably of much
use to you but, its good to share.
 
Regs
 
Colin M.
-----Original Message-----
From: owner-nv-l@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com]
On Behalf Of usman.taokeer@s-iii.com
Sent: 14 July 2005 11:50
To: nv-l@lists.us.ibm.com
Subject: RE: [nv-l] Inventory management through NetView


Collins, 

Thanks dude, i found all the description in the Manual for UNIX. But i
still am facing one problem. We have VLANs created and for each IP network
NetView considers is as separate object and hence i have multiple entries
for One Switch in the Smartset coz the OID is same for all (obviously),
is there a trick around any other way that it doesn't count it again if
it exists already in the database, any other Unique ID like MAC or something?

Regards, 
Usman Taokeer 
Si3.

"Colin Mulkerrins" <Colin.Mulkerrins@anpost.ie>
Sent by: owner-nv-l@lists.us.ibm.com

14-07-05 03:22 PM

Please respond to
nv-l@lists.us.ibm.com

To	<nv-l@lists.us.ibm.com>
cc
Subject	RE: [nv-l] Inventory management through NetView

Usman, 
  
You can create a smartset and set the SNMP sysObjectID = 1.3.6.1.4.1.9.324
(the ID for a 2950/24 switch) - You can get the ids for all cisco kit at
www.cisco.com
- (I found the 2950s at http://www.cisco.com/en/US/products/sw/cscowork/ps2406/products_device_support_table09186a00800b5e7f.html
) 
  
Smartsets 101 (UNIX) If you have not created a smartset before... From
the Tools menu Open Smartset Editor - Add -  (give your smartset a
name and discription) - click the modify button for definition 1 (ensure
Definition Type is set to Attribute) Find the SNMP sysObjectID attribute
and set the string attribute value to =  1.3.6.1.4.1.9.324 Then click
OK.  You can test the definition (click test) this will give you a
list of all matching objects.  Click OK and the new smartset gets
created. 
  
If you install the Cisco - NetView integration kit the smartset editor
has a cisco attribute - can be useful (you also get natty cisco icons for
the map - not alot else though, as far as I can see)
  
I am sure that other manufacturers also supply the sysObjectID mib values
for their kit too. 
  
Happy smartsetting... 
  
Regs 
  
Colin M. 
-----Original Message-----
From: owner-nv-l@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com]
On Behalf Of usman.taokeer@s-iii.com
Sent: 14 July 2005 07:19
To: nv-l@lists.us.ibm.com
Subject: [nv-l] Inventory management through NetView


Dear list, 

Can we keep a track of inventory (switches,routers models) in NetView.
I read it can be done using smartsets but don't know how exactly. Like
if i want to make a smartsets for all Cisco 2950 switches how do i do it?
or is there any other way to keep a track of that?

Regards, 
Usman Taokeer 
Si3. 
*********************************************************************************
This e-mail and its attachments, is confidential and is intended for the
addressee(s) only. If you are not the intended recipient, disclosure, distribution
or any action taken in reliance on it is prohibited and may be unlawful.
Please note that any information expressed in this message or its attachments
is not given or endorsed by An Post unless otherwise indicated by an authorised
representative independently of this message. An Post does not accept responsibility
for the contents of this message and although it has been scanned for viruses
An Post will not accept responsibility for any damage caused as a result
of a virus being passed on. 
*********************************************************************************