I like the idea and would like to see a demo if you get one ready. I agree with the previous suggestions about using and ameliorating the APIs instead of querying directly to the databases.

In my previous organization, we also struggled with the management of numerous big clusters and we developed a home-made Django web portal to satisfies queries and automation that Horizon could not do. I would be curious to see which functions have been developed for 'openstack-admin' and how similar the needs are.

Cheers,

Camille Rodriguez

On Mon, Aug 26, 2019 at 7:26 AM Graham Hayes <gr@ham.ie> wrote:

On 20/08/2019 19:05, Matt Riedemann wrote:
> On 8/20/2019 7:02 AM, Mohammed Naser wrote:
>>> Flexible: openstack-admin supports the fuzzy search for any important
>>> field(e.g. display_name/uuid/ip_address/project_name of an instance),
>>> which enables users to locate a particular object in no time.
>> This is really useful to be honest, but we probably can work around it
>> by using the filtering that APIs provide.
>>
>
> Isn't this what searchlight integration into horizon was for?
>

Yes - AFAIK, there was even an idea of integrating searchlight into
the OSC / nova CLI for list / search operations.

I really liked the idea of searchlight for fuzzy search, being able
to search for an IP and finding the floating IP, server, and DNS Record
seemed like a great tool.