[CLI] Missing functionality to lookup system ID from machines power-parameters query

[Sandor Zeestraten]

# MAAS 2.1.4

# Issue
I'm trying to identify the system ID of a new machine in MAAS by its power address so we can setup it up further from the CLI (such as hostname, zone, network and etc).

Right now, we have to lookup the power parameters of all machines and grep or use jq to identify which system ID is linked to which power address.

# Feature request
It would really be helpful to be able to query for machines by its power address and easily get back the system ID.

# Current command
maas $PROFILE machines power-parameters | do some further processing with grep or jq

# Desired command
maas $PROFILE machines power-parameters power_address="$IP_POWER_ADRESS"
which should return only machines matching with the power address

[Mike Pontillo (mpontillo)]

This is a good idea. As a workaround, you can do this today by querying the database directly, such as the following:

https://gist.github.com/mpontillo/4be4217274c12a5e33543aff745390f8

(But this can't be supported long-term, since we don't guarantee a stable schema across different versions of MAAS.)

[Adam Collard (adam-collard)]

This bug has not seen any activity in the last 6 months, so it is being automatically closed.

If you are still experiencing this issue, please feel free to re-open.

MAAS Team

[Sandor Zeestraten (szeestraten)]

@adam-collard, this is a feature request, not an issue that is should expire after 6 months. If you do not want to implement this feature than that is fine, but please say so.

[Blake Rouse (blake-rouse)]

Being a feature request, please could you start a thread over on our Discourse (https://discourse.maas.io/c/features) to discuss the feature?

[Sandor Zeestraten (szeestraten)]

https://discourse.maas.io/t/query-system-id-from-machines-power-address/1016