Ray,
Try this from the command line.
ovobjprint | awk '/Selection Name/{NAME=$4}/SNMP ifType.*Frame.*/{print
NAME}'
It is a single pass through the database with NO nvdbformat, nvdbimport or
nvUtil.
Don Davis
-----Original Message-----
From: Westphal, Raymond [mailto:RWestphal@erac.com]
Sent: Tuesday, December 11, 2001 4:20 PM
To: NV List (E-mail)
Subject: [NV-L] A better mousetrap?
Hello Everyone.
AIX 4.3.3.10 with NetView 6.0.2 and native NetView database.
I'm trying to create a simple http screen which contains a list of marginal
and critical frame relay routers.
I'm not worried about the http output creation as much as the NetView
database search. The job has to run quickly.
Eventually there will be 4,000+ routers. So far it takes 3 steps.
cron job runs several times a day to update a list of frame relay routers
1) run an nvdbformat command to find all objects with SNMP ifType~Frame
Relay
2) run nvdbimport command to set object attribute isFrameRelay=True
cron job runs every 5 minutes
3) nvUtil e "('isFrameRelay'=True) && ('IP Status'=Marginal)" "%IP
Hostname%" > marginal.file
nvUtil e "('isFrameRelay'=True) && ('IP Status'=Critical)" "%IP
Hostname%" > critical.file
Is there a better way to find the answer?
Ray Westphal
Enterprise Rent-A-Car
_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l
------------------------------------------------------------------------------
This electronic mail and any files transmitted with it are confidential and are
intended solely for the use of individual or entity to whom they are addressed.
If you are not the intended recipient or the person responsible for delivering
the electronic mail to the intended recipient, be advised that you have
received this electronic mail in error and that any use, dissemination,
forwarding, printing, or copying of this electronic mail is strictly
prohibited. If you have received this electronic mail in error, please
immediately notify the sender by return mail.
|