Query to retrieve VIP name from Node IP input

Thanks Jason, how can I output them on one line i.e. [node_ip, node, pool, virtual].

I'm not strong on Python.

Give this version a try. It will print the same virtual server / pool multiple times - one for each member (node) with an IP in the list. Please make sure to spot check this before relying on its data as it was done quickly and I could have easily overlooked some detail.

!/usr/bin/env python3

from f5.bigip import ManagementRoot
from getpass import getpass
from pprint import pprint

hostname = 'my.f5.ltm.net'
username = 'foo'

node_ips = ['192.168.1.1', '192.168.1.2', '192.168.1.3']

mgmt = ManagmentRoot(hostname, username, getpass())

 Get node names that have IPs in the list

nodes = {}

for node in mgmt.tm.ltm.nodes.get_collection():
    if node.address in node_ips:
         fullPath is /PARTITION/NAME (or /PARTITION/SUB_PATH/NAME)
        nodes[node.fullPath] = node.address

 Get pool names which nodes in list belong

pools = {}

for pool in mgmt.tm.ltm.pools.get_collection():
    members = pool.members_s.get_collection()

    for member in members:
         Member fullpath is /PARTITION/NODENAME:SERVICE_PORT
         (or /PARTITION/SUB_PATH/NODENAME:SERVER_PORT)
        if member.fullPath.split(':')[0] in nodes:
            if pool.fullPath in pools:
                pools[pool.fullPath].append(member.fullPath.split(':')[0])
            else:
                pools[pool.fullPath] = [member.fullPath.split(':')[0]]

 Get virtual server names which pools in list belong

virtuals = {}

for virtual in mgmt.tm.ltm.virtuals.get_collection():
    if hasattr(virtual, 'pool') and virtual.pool in pools:
        virtuals[virtual.fullPath] = virtual.pool

 Print CSV

print('Node IP,Node,Pool,Virtual')

 Use iteritems() instead of items() with Python 2.x
for virtual, pool in virtuals.items():
    for node in pools[pool]:
        print('{},{},{},{}'.format(
            nodes[node],
            node,
            pool,
            virtual,
        ))

Thanks Jason this is extremely helpful and working. I just have one last question. As we are using route domains and there is a % in the node_ip, we have to put the route domain in for the script to find the associated Pools/VIPs etc. Is there any way to query the DB without having to include the partition in the node_ip?

Thanks again for your help.

Thanks Jason, how can I output them on one line i.e. [node_ip, node, pool, virtual].

I'm not strong on Python.

Give this version a try. It will print the same virtual server / pool multiple times - one for each member (node) with an IP in the list. Please make sure to spot check this before relying on its data as it was done quickly and I could have easily overlooked some detail.

!/usr/bin/env python3

from f5.bigip import ManagementRoot
from getpass import getpass
from pprint import pprint

hostname = 'my.f5.ltm.net'
username = 'foo'

node_ips = ['192.168.1.1', '192.168.1.2', '192.168.1.3']

mgmt = ManagmentRoot(hostname, username, getpass())

 Get node names that have IPs in the list

nodes = {}

for node in mgmt.tm.ltm.nodes.get_collection():
    if node.address in node_ips:
         fullPath is /PARTITION/NAME (or /PARTITION/SUB_PATH/NAME)
        nodes[node.fullPath] = node.address

 Get pool names which nodes in list belong

pools = {}

for pool in mgmt.tm.ltm.pools.get_collection():
    members = pool.members_s.get_collection()

    for member in members:
         Member fullpath is /PARTITION/NODENAME:SERVICE_PORT
         (or /PARTITION/SUB_PATH/NODENAME:SERVER_PORT)
        if member.fullPath.split(':')[0] in nodes:
            if pool.fullPath in pools:
                pools[pool.fullPath].append(member.fullPath.split(':')[0])
            else:
                pools[pool.fullPath] = [member.fullPath.split(':')[0]]

 Get virtual server names which pools in list belong

virtuals = {}

for virtual in mgmt.tm.ltm.virtuals.get_collection():
    if hasattr(virtual, 'pool') and virtual.pool in pools:
        virtuals[virtual.fullPath] = virtual.pool

 Print CSV

print('Node IP,Node,Pool,Virtual')

 Use iteritems() instead of items() with Python 2.x
for virtual, pool in virtuals.items():
    for node in pools[pool]:
        print('{},{},{},{}'.format(
            nodes[node],
            node,
            pool,
            virtual,
        ))

Thanks Jason this is extremely helpful and working. I just have one last question. As we are using route domains and there is a % in the node_ip, we have to put the route domain in for the script to find the associated Pools/VIPs etc. Is there any way to query the DB without having to include the partition in the node_ip?

Thanks again for your help.