You can get it out of the data model.  This is a Export version I wrote of this query because I was adding it to a much larger report.  However, you can see that it uses the data model to get the information.

/**
 * @intent Extract all NATs and VIPs.
 * @description
 * 1) NAT information from all the FWs rulres we see in the tool: Source ip, original destination ip, translated ip address, FW name, FW IP and MAC addresses used for the connection.
 * 2) VIP information from all Load Balancers we see in the tool: Original VIP, All Destination IPs, LB name, LB IP and MAC address used for the connection.
 */

getIntVrf(device, ifaceList) =
  foreach networkInstance in device.networkInstances
  foreach interface in networkInstance.interfaces
  let name = if isPresent(interface.subIfaceName)
             then interface.subIfaceName
             else interface.ifaceName
  where name in ifaceList
  select distinct networkInstance.name;

export vipIps(device: Device) =
  foreach x in [1]
  where device.platform.vendor not in [Vendor.VERSA]
  foreach natEntry in device.natEntries
  where natEntry.natType == NatType.LB
  let metadataMatches = natEntry.metadataMatches
  let vrf = getIntVrf(device, metadataMatches.egressInterfaces)
  foreach subnet in natEntry.headerMatches.ipv4Dst
  where subnet != ipSubnet("0.0.0.0/0")
  let address = address(subnet)
  foreach rewrite in natEntry.rewrites
  select {address: address, dstPool: rewrite.ipv4Dst, vrf};

// Begin Test NQE query
foreach device in network.devices
let output = vipIps(device)
foreach entry in output
select {
  Device: device.name,
  address: entry.address,
  dstPool: (foreach x in entry.dstPool select x),
  vrf: entry.vrf
}

Hi @Tyson Henrie , 

unfortunately the Query i am not able to run , can you please check its working for you.

Thanks

Rohit 

@Rohit_809 Kumar I apologize. That query runs for me.  I tried changing it to a parameterized NQE.  Maybe this one will work for you.

The parameter is a device name.  you can enter the parameter using the parameter button that will be next to the executer button.

getIntVrf(device, ifaceList) =
  foreach networkInstance in device.networkInstances
  foreach interface in networkInstance.interfaces
  let name = if isPresent(interface.subIfaceName)
             then interface.subIfaceName
             else interface.ifaceName
  where name in ifaceList
  select distinct networkInstance.name;

@query
vipIps(device: Device) =
  foreach x in [1]
  where device.platform.vendor not in [Vendor.VERSA]
  foreach natEntry in device.natEntries
  where natEntry.natType == NatType.LB
  let metadataMatches = natEntry.metadataMatches
  let vrf = getIntVrf(device, metadataMatches.egressInterfaces)
  foreach subnet in natEntry.headerMatches.ipv4Dst
  where subnet != ipSubnet("0.0.0.0/0")
  let address = address(subnet)
  foreach rewrite in natEntry.rewrites
  select {address: address, dstPool: rewrite.ipv4Dst, vrf};

is it possible to get the details without put parameter, in just single table form ?

@Rohit_809 Kumar Give this a try.

/**
 * @intent Extract all NATs and VIPs.
 * @description
 * 1) NAT information from all the FWs rulres we see in the tool: Source ip, original destination ip, translated ip address, FW name, FW IP and MAC addresses used for the connection.
 * 2) VIP information from all Load Balancers we see in the tool: Original VIP, All Destination IPs, LB name, LB IP and MAC address used for the connection.
 */

getIntVrf(device, ifaceList) =
  foreach networkInstance in device.networkInstances
  foreach interface in networkInstance.interfaces
  let name = if isPresent(interface.subIfaceName)
             then interface.subIfaceName
             else interface.ifaceName
  where name in ifaceList
  select distinct networkInstance.name;

// NQE query starts here
foreach device in network.devices
where device.platform.vendor not in [Vendor.VERSA]
foreach natEntry in device.natEntries
where natEntry.natType == NatType.LB
let metadataMatches = natEntry.metadataMatches
let vrf = getIntVrf(device, metadataMatches.egressInterfaces)
foreach subnet in natEntry.headerMatches.ipv4Dst
where subnet != ipSubnet("0.0.0.0/0")
let address = address(subnet)
foreach rewrite in natEntry.rewrites
select { device: device.name, address: address, dstPool: rewrite.ipv4Dst, vrf }

Getting below error.

Oops! The query doesn’t work.

Address the following issues:

• Line 6, character 4: token recognition error at: '\r'
• Line 7, character 31: token recognition error at: '\r'
• Line 8, character 53: token recognition error at: '\r'
• Line 9, character 50: token recognition error at: '\r'
• Line 10, character 50: token recognition error at: '\r'
• Line 11, character 41: token recognition error at: '\r'
• Line 12, character 38: token recognition error at: '\r'
• Line 13, character 26: token recognition error at: '\r'
• Line 14, character 40: token recognition error at: '\r'
• Line 15, character 1: token recognition error at: '\r'
• Line 16, character 25: token recognition error at: '\r'
• Line 17, character 34: token recognition error at: '\r'
• Line 18, character 51: token recognition error at: '\r'
• Line 19, character 38: token recognition error at: '\r'
• Line 20, character 37: token recognition error at: '\r'
• Line 21, character 47: token recognition error at: '\r'
• Line 22, character 62: token recognition error at: '\r'
• Line 23, character 49: token recognition error at: '\r'
• Line 24, character 38: token recognition error at: '\r'
• Line 25, character 30: token recognition error at: '\r'
• Line 26, character 37: token recognition error at: '\r'