Comment 4 for bug 1880997

Note that were are not currently getting any nova database data in 'collect', we are missing dumping mariadb.

To look at specific lab the pci_stats and other fields :
date; kubectl exec -it -n openstack mariadb-server-0 -- bash -c "mysql --password=\$MYSQL_DBADMIN_PASSWORD --user=root nova -e 'select host,numa_topology,pci_stats from compute_nodes;'"

Example :
date; kubectl exec -it -n openstack mariadb-server-0 -- bash -c "mysql --password=\$MYSQL_DBADMIN_PASSWORD --user=root nova -e 'select host,pci_stats from compute_nodes;'"
. .
| controller-0 | {"nova_object.version": "1.1", "nova_object.changes": ["objects"], "nova_object.name": "PciDevicePoolList", "nova_object.data": {"objects": [{"nova_object.version": "1.1", "nova_object.changes": ["count", "numa_node", "vendor_id", "product_id", "tags"], "nova_object.name": "PciDevicePool", "nova_object.data": {"count": 0, "numa_node": 0, "vendor_id": "102b", "product_id": "0522", "tags": {"dev_type": "type-PCI"}}, "nova_object.namespace": "nova"}, {"nova_object.version": "1.1", "nova_object.changes": ["count", "numa_node", "vendor_id", "product_id", "tags"], "nova_object.name": "PciDevicePool", "nova_object.data": {"count": 1, "numa_node": 1, "vendor_id": "8086", "product_id": "0435", "tags": {"dev_type": "type-PF"}}, "nova_object.namespace": "nova"}, {"nova_object.version": "1.1", "nova_object.changes": ["count", "numa_node", "vendor_id", "product_id", "tags"], "nova_object.name": "PciDevicePool", "nova_object.data": {"count": 32, "numa_node": 1, "vendor_id": "8086", "product_id": "0443", "tags": {"dev_type": "type-VF"}}, "nova_object.namespace": "nova"}]}, "nova_object.namespace": "nova"} |

The above is string json encoded nova object.

i.e., The Matrox g200e GPU
{"count": 0, "numa_node": 0, "vendor_id": "102b", "product_id": "0522", "tags": {"dev_type": "type-PCI"}}

i.e, the QAT vf
{"count": 32, "numa_node": 1, "vendor_id": "8086", "product_id": "0443", "tags": {"dev_type": "type-VF"}}

[sysadmin@controller-0 ~(keystone_admin)]$ system host-device-list controller-0
+------------------+--------------+----------+-----------+-----------+---------------------------+---------------------------------+----------------------------------------+-----------+---------+
| name | address | class id | vendor id | device id | class name | vendor name | device name | numa_node | enabled |
+------------------+--------------+----------+-----------+-----------+---------------------------+---------------------------------+----------------------------------------+-----------+---------+
| pci_0000_08_00_0 | 0000:08:00.0 | 030000 | 102b | 0522 | VGA compatible controller | Matrox Electronics Systems Ltd. | MGA G200e [Pilot] ServerEngines (SEP1) | 0 | True |
| pci_0000_83_00_0 | 0000:83:00.0 | 0b4000 | 8086 | 0435 | Co-processor | Intel Corporation | DH895XCC Series QAT | 1 | True |
+------------------+--------------+----------+-----------+-----------+---------------------------+---------------------------------+----------------------------------------+-----------+---------+