Collecting MAC and IP addresses from VMs

[dpearceFL]

I'm trying to create a script that will output the MAC and IP addresses from the VMs on this host.

"qm guest cmd 1017 network-get-interfaces | jq ." will generate a valid JSON file. But when I try to address the element "hardware-address" all I get is errors like this:

# qm guest cmd 1017 network-get-interfaces | jq . | jq .network-interfaces
jq: error: interfaces/0 is not defined at <top-level>, line 1:
.network-interfaces         
jq: 1 compile error

Yes I know this is more of a JSON or jq problem, but I am hoping someone has tried to gather this info before. If there a better way?

 

[bbgeek17]

First, there is no field called "network-interfaces", at least in my output.

Second you need to quote the dash:

qm guest cmd 3004 network-get-interfaces|jq '.[].hardware-address'
jq: error: address/0 is not defined at <top-level>, line 1:
.[].hardware-address             
jq: 1 compile error
Unable to flush stdout: Broken pipe

vs

qm guest cmd 3004 network-get-interfaces|jq '.[]."hardware-address"'
"00:00:00:00:00:00"
"bc:24:11:6a:61:1e"
"02:42:55:a6:c7:4b"
"aa:ce:4b:73:02:40"

---

Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox

 

[dpearceFL]

Yes, the element I am trying to look at is called "hardware-address".

I have so much to learn about JSON and addressing. Please tolerate on more question...

So given this:

# qm guest cmd 1017 network-get-interfaces | jq  '.[1] | ."ip-addresses"'
[
  {
    "ip-address": "10.1.0.76",
    "ip-address-type": "ipv4",
    "prefix": 23
  },
  {
    "ip-address": "fe80::be24:11ff:fe69:8d37",
    "ip-address-type": "ipv6",
    "prefix": 64
  }
]

How do I get at the value for "ip-address"?

 

[bbgeek17]

Is this what you were looking for?

qm guest cmd 3004 network-get-interfaces|jq -r '.[]|."hardware-address" +" " + (."ip-addresses"[]|select(."ip-address-type"=="ipv4")|."ip-address")'
00:00:00:00:00:00 127.0.0.1
bc:24:11:6a:61:1e 172.16.202.54
02:42:55:a6:c7:4b 172.17.0.1

---

Blockbridge : Ultra low latency all-NVME shared storage for Proxmox - https://www.blockbridge.com/proxmox

 

[dpearceFL]

Found it!

 qm guest cmd 1017 network-get-interfaces | jq  '.[1] | ."ip-addresses" | .[0] | ."ip-address"'
"10.1.0.76"