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 AT erac DOT 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.