Hello,
While you could get the information you're looking for using ovobjprint, I
think it would require some scripting, or serious output piping to get a
decent output since you would basically need to dump every object in the
database and parse out the information you want. I would suggest you look
at using a .format file with the nvdbformat command, which can be used to
produce some decent reports on various NetView objects.
Example .format files can be found in the /usr/OV/conf/nvdbtools directory.
The following .format file 'script' should give you what you're looking
for:
### Start of .format file ###
###########################################################
#
# NVDBFormat interface listing .format file
# Modified version of interfaces.format
#
# Usage: nvdbformat -f <filename>
#
# If this file were named 'interfaces.format' it would be processed by:
#
# nvdbformat -f interfaces.format
#
###########################################################
SELECTRULE:isInterface=TRUE
SELECTRULE:IP Address^Null
#SELECTRULE:OVW Maps Exists!0
SELECTFIELD:1:TopM Node ID:Selection Name
SELECTFIELD:2:IP Address
SELECTFIELD:3:IP Subnet Mask
SELECTFIELD:4:SNMP ifPhysAddr
SELECTFIELD:5:SNMP ifDescr
SELECTFIELD:6:IP Status
#
GROUPBY:1:TopM Node ID:Selection Name
SORTBY:1:IP Address
#
HEADER:Interface List by Selection Name
HEADER:Selection Name,IP Address,IP Subnet Mask,SNMP ifPhysAddr,SNMP
ifDescr,IP Status
#
#GROUPHEADER:${GROUPNAME}
#GROUPHEADER:IP Address,IP Subnet Mask,SNMP ifPhysAddr,SNMP ifDescr,IP
Status
#
OUTPUT:${1},${2},${3},${4},${5},${6}
#OUTPUT:${2},${3},${4},${5},${6}
###
### End of .format file ###
Some things to note:
- The data that is output from this will be in a csv format making it
easier to use in spreadsheets. Redirecting the output to a file is highly
recommended.
- To only list interfaces that are exist in maps, uncomment the
#SELECTRULE:OVW Maps Exists!0
- I have commented out most of the grouping information which makes it
easier to sort the csv data with external commands ore spreadsheet
applications.
Hope this helps.
Regards,
Greg Keetch
IT Specialist (Advisor), Network Services
Network Management Tools Specialist
Information Technology Services Americas (ITSA), Global Services, IBM
Canada
mikemillion2000@c
omcast.net
Sent by: To
nv-l-bounces@list Tivoli NetView Discussions
s.ca.ibm.com <nv-l@lists.ca.ibm.com>
cc
10/13/2006 05:38 Subject
AM [NV-L] list all objects on IP Map
with mac addresses
Please respond to
Tivoli NetView
Discussions
<nv-l@lists.ca.ib
m.com>
Morning-
A 2nd question, can I use ovobjprint to get this information?
Thanx.
Mikemillion
----- Message from mikemillion2000@comcast.net on Fri, 13 Oct 2006 12:34:04
+0000 -----
To: Tivoli NetView Discussions <nv-l@lists.ca.ibm.com>
Subject: [NV-L] Multiple objects on IP Map with Unknown status
----- Message from James Shanks <jshanks@us.ibm.com> on Wed, 27 Sep 2006
14:04:58 +0000 -----
To: Tivoli NetView Discussions <nv-l@lists.ca.ibm.com>
Subject: Re: [NV-L] Email Rule for Windows 7.1.4
(See attached file: pic31107.gif)(See attached file: pic30191.gif)(See
attached file: pic18007.gif)(See attached file: pic11337.gif)(See attached
file: pic15457.gif)(See attached file: pic12287.gif)(See attached file:
pic27753.gif)(See attached file: pic10383.gif)(See attached file:
pic14945.gif)(See attached file: pic08909.gif)
_______________________________________________
NV-L mailing list
NV-L@lists.ca.ibm.com
Unsubscribe:NV-L-leave@lists.ca.ibm.com
http://lists.ca.ibm.com/mailman/listinfo/nv-l (Browser access limited to
internal IBM'ers only)
_______________________________________________
NV-L mailing list
NV-L@lists.ca.ibm.com
Unsubscribe:NV-L-leave@lists.ca.ibm.com
http://lists.ca.ibm.com/mailman/listinfo/nv-l (Browser access limited to
internal IBM'ers only)
_______________________________________________
NV-L mailing list
NV-L@lists.ca.ibm.com
Unsubscribe:NV-L-leave@lists.ca.ibm.com
http://lists.ca.ibm.com/mailman/listinfo/nv-l (Browser access limited to
internal IBM'ers only)
pic31107.gif
Description: GIF image
pic30191.gif
Description: GIF image
pic18007.gif
Description: GIF image
pic11337.gif
Description: GIF image
pic15457.gif
Description: GIF image
pic12287.gif
Description: GIF image
pic27753.gif
Description: GIF image
pic10383.gif
Description: GIF image
pic14945.gif
Description: GIF image
pic08909.gif
Description: GIF image
_______________________________________________
NV-L mailing list
NV-L@lists.ca.ibm.com
Unsubscribe:NV-L-leave@lists.ca.ibm.com
http://lists.ca.ibm.com/mailman/listinfo/nv-l (Browser access limited to
internal IBM'ers only)
|
