query api for vmware information

[jason0]

Hello,

I want to answer the following question to automate taking snapshots for patching.

 "Given a vmware VM name, what is the name of the vcenter that controls it?"

I am looking at manageiq to answer this question about vmware because we also have aws and azure providers, thus it seems reasonable to query manageiq rather than customizing something for each provider.

I have making api queries to my manageiq instance ( najdorf-1.3.20220715135859_39a22e6 ).

If I use the manageiq UI, if I search for a virtual machine name via the uri https://manageiq/vm_infra/explorer#, the answer to my question is found in the "Infrastructure Provider" field. so how do I navigate the API to get this information?

--jason

[agrare]

Hey @jason0 sorry for the late response but yes you absolutely can do this with the ManageIQ API
https://www.manageiq.org/docs/reference/latest/api/examples/queries.html has some example queries, but specifically what you're looking for is:

GET /api/vms?expand=resources&attributes=name,ext_management_system.name

{
  "name": "vms",
  "count": 750,
  "subcount": 750,
  "pages": 1,
  "resources": [
    {
      "href": "http://localhost:3000/api/vms/15",
      "name": "DC0_H0_VM14",
      "id": "15",
      "ext_management_system": {
        "name": "vcsim"
      }
    },
    {
      "href": "http://localhost:3000/api/vms/16",
      "name": "DC0_H0_VM15",
      "id": "16",
      "ext_management_system": {
        "name": "vcsim"
      }
    }
    ...

[jason0]

Hello @agrare

Thank you for your reply! I will investigate this. As it happens, it has taken nearly six months for my brain to come back around to this topic, so a "late" reply is perfect!

--jason