Table: panos_address_object - Query Panorama Address Objects using SQL

A Panorama Address Object in is a resource that represents an IP address, IP address range, or FQDN that you can use anywhere in a policy for source or destination address. It provides a way to group multiple IP addresses or FQDNs under a single name to streamline policy creation and management. These objects can be used to configure security policies and NAT rules in Panorama.

Table Usage Guide

The panos_address_object table provides insights into address objects within Panorama. As a network engineer, explore object-specific details through this table, including IP addresses, FQDNs, and associated descriptions. Utilize it to uncover information about objects, such as those with specific IP ranges, the association of multiple IPs under a single name, and the verification of policy configurations.

Examples

List all address objects

This query helps you explore all address objects in your network, allowing you to gain insights into the various network entities and their configurations. This is particularly useful in network management and security, where understanding the structure and organization of your network can aid in troubleshooting and threat mitigation.

select
  *
from
  panos_address_object;

select
  *
from
  panos_address_object;

List all address objects ordered by object name

Explore all address objects in an organized manner, sorted by their respective names. This helps in efficient management and easy identification of individual address objects.

select
  name,
  value,
  description
from
  panos_address_object;
order by
  name;

select
  name,
  value,
  description
from
  panos_address_object
order by
  name;

Schema for panos_address_object

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
description	text		Description of this object.
device_group	text	=	The device group location (default: shared).
name	text	=	The address object's name.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A list of administrative tags associated with the address object.
type	text		Specifies the type of address. Possible values are: ip-netmask (default), ip-range, ip-wildcard, or fqdn.
value	text		IP address or other value of the object.
vsys	text	=	The vsys the address object belongs to (default: vsys1).

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- panos

You can pass the configuration to the command with the --config argument:

steampipe_export_panos --config '<your_config>' panos_address_object