The TopM  item in the following nvdbformat requests will show the 
interfaces with IP addresses known to NetView.  Itr won't identify the 
ports on hubs and switches since they don't have addresses but you can 
find that info by browsing the MIB for the switch or writing SNMPWALK 
CLI commands with the right OID information. 

    ###########################################################
    #        nvdbformat -f   if-routers.format
    ###########################################################
    SELECTRULE:isRouter=TRUE
    SELECTFIELD:1:Selection Name
    SELECTFIELD:2:routerSysName
    SELECTFIELD:3:vendor
    SELECTFIELD:4:SNMP sysLocation
    SELECTFIELD:5:TopM Interface List
    #
    HEADER:# Interfaces for routers
    OUTPUT:#
    OUTPUT:Name: ${1}
    OUTPUT:SysName: ${2}
    OUTPUT:Vendor:  ${3}       
    OUTPUT:Location: ${4}        
    OUTPUT:${5}        
    #
    FOOTER:#  Objects/MatchingObjects: ${TOTAL_OBJECTS}/${NUMMATCH}
    
    ###########################################################
    #        nvdbformat -f    if-switches.format
    ###########################################################
    SELECTRULE:SmartSet=Switches
    SELECTFIELD:1:TopM Interface List
    SELECTFIELD:2:IP Hostname
    #
    HEADER:# Switches
    OUTPUT:${2}         
    OUTPUT:${1}        
    #
    FOOTER:# Objects/Matching Objects : ${TOTAL_OBJECTS}/${NUMMATCH}



Scott Bursik wrote:

> AIX 4.3.3 NetView 6.0.2
> 
> With the recent pricing change in NetView (point system) I was 
> wondering if anyone had a method to pull the routers by interface 
> count out of the db so we can check our numbers against what we are 
> licensed for? We have about 1200 routers, and I haven't even started 
> looking at switches yet! Thanks.
> 
> Scott Bursik
> Pepsico Business Solutions Group
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> _________________________________________________________________________
> NV-L List information and Archives: http://www.tkg.com/nv-l
> 

-- 
Bill Evans  --  Consultant in Enterprise Systems Management
reply-to: wvevans AT prodigy DOT net  
Phone: 919-696-7513