Hi Ahsan,

NetView does not store a hostname with Interface entries. The best you can do is the hostname for the Node the interface is in. The short version of a .format file for that would look like this:

### example format file start ###
### File: interfacestatus.format
### Usage: /usr/OV/bin/nvdbformat -f interfacestatus.format
SELECTRULE:isInterface=TRUE
# Ignore Interfaces without an IP Address associated with them..
SELECTRULE:IP Address^Null
SELECTFIELD:1:TopM Node ID:IP Hostname
SELECTFIELD:2:IP Address
SELECTFIELD:3:IP Status

GROUPBY:1:TopM Node ID:IP Hostname
SORTBY:1:IP Address

OUTPUT: ${1}, ${2}, ${3}
### example format file end ###

If for some reason your site has different IP Hostnames for each interface defined in the DNS, then you would need to use something like this without the "TopM Node ID:IP Hostname" parts (so you just get the IP Address and Status of each interface), and then run the result through an outside script that does a DNS query for each IP address.

Hope this helps.

Regards,
Greg Keetch
IT Specialist (Advisor), Network Services
Network Management Tools Specialist
Information Technology Services Americas (ITSA), Global Services, IBM Canada

-- I didn't say it was your fault... I said I was going to blame you.

"Ahsan Ali" <ahsanali AT gmail DOT com>

"Ahsan Ali" <ahsanali AT gmail DOT com> Sent by: nv-l-bounces AT lists.ca.ibm DOT com 04/05/2007 04:14 AM Please respond to Tivoli NetView Discussions <nv-l AT lists.ca.ibm DOT com>

To "Tivoli NetView Discussions" <nv-l AT lists.ca.ibm DOT com> cc Subject Re: [NV-L] Node Status Report (Up/Down)

Hi Greg,

Is there a way to get a list of interface names (the hostname the reverse lookup of the IP resolves to) and their current status?

I've only been able to get Null and not the interface's reverse lookup name.

### example format file start ###
### File: nodestatus.format
### Usage: /usr/OV/bin/nvdbformat -f nodestatus.format
SELECTRULE:isInterface=TRUE
SELECTFIELD:1:IP Hostname
SELECTFIELD:2:IP Status

OUTPUT: ${1}, ${2}
### example format file end ###

Thanks!

-Ahsan

On 4/3/07, Greg Keetch < gkeetch AT ca.ibm DOT com> wrote:

Hi Usman,

There are a few simple ways this can be done. I'm using UNIX syntax, so you may need to slightly modify for Windows.

You could use the smartset utility:
/usr/OV/bin/nvUtil e '((isNode = true) && (("IP Status" = Normal) || ("IP Status" = Critical)))' '%Selection Name%,%IP Status%'

Or create a smartset with the rules you want (such as above) and run:
/usr/OV/bin/nvUtil l smartsetname

Alternatively, you could use a format file and the nvdbformat utility:
/usr/OV/bin/nvdbformat -f nodestatus.format

Here is an example of a format file that will list all nodes with there status, sorted into groups by status:
### example format file start ###
### File: nodestatus.format
### Usage: /usr/OV/bin/nvdbformat -f nodestatus.format
SELECTRULE:isNode=TRUE
SELECTFIELD:1:IP Hostname
SELECTFIELD:2:IP Status
#
GROUPBY:IP Status
SORTBY:1:IP Hostname
#
HEADER:Nodes Report:
HEADER:-------------
HEADER:
#
GROUPHEADER:Status: ${GROUPNAME} - ${NUMMATCH}
GROUPHEADER:IP Hostname, IP Status
GROUPHEADER:_____________________________________________
#
OUTPUT: ${1}, ${2}
#
### example format file end ###

Hope this helps.

Regards,
Greg Keetch
IT Specialist (Advisor), Network Services
Network Management Tools Specialist
Information Technology Services Americas (ITSA), Global Services, IBM Canada

-- I didn't say it was your fault... I said I was going to blame you.

"Usman Taokeer" < usman.taokeer AT gmail DOT com>



"Usman Taokeer" <usman.taokeer AT gmail DOT com> Sent by: nv-l-bounces AT lists.ca.ibm DOT com 04/03/2007 06:09 AM Please respond to Tivoli NetView Discussions <nv-l AT lists.ca.ibm DOT com>

To "Tivoli NetView Discussions" <nv-l AT lists.ca.ibm DOT com> cc Subject [NV-L] Node Status Report (Up/Down)


Hi,
NV v7.1.4 FP05
Windows 2003 Std Edt SP1


Is there any way to get the status(up/down only) of all/any node(s) currently in the NV database .


Regards,

Usman_______________________________________________
NV-L mailing list
NV-L AT lists.ca.ibm DOT com
Unsubscribe:NV-L-leave AT lists.ca.ibm DOT com
http://lists.ca.ibm.com/mailman/listinfo/nv-l (Browser access limited to internal IBM'ers only)


_______________________________________________
NV-L mailing list
NV-L AT lists.ca.ibm DOT com
Unsubscribe:NV-L-leave AT lists.ca.ibm DOT com
http://lists.ca.ibm.com/mailman/listinfo/nv-l (Browser access limited to internal IBM'ers only)

_______________________________________________
NV-L mailing list
NV-L AT lists.ca.ibm DOT com
Unsubscribe:NV-L-leave AT lists.ca.ibm DOT com
http://lists.ca.ibm.com/mailman/listinfo/nv-l (Browser access limited to 
internal IBM'ers only)