How to query status of Dollar Universe node from the management server in CLI

[Yves Degauquier]

Hi all,

I'm looking for to get from the Management server the list of Dollar Universe nodes and their details (version, operating system, status).

With 'unilst NODE' either 'unilst NODE -full' I have the list but not all information.

Is it possible to get those information in CLI?

Thanks in advance for your help,

Yves

[Domenico Cotugno]

Hi @Yves Degauquier

I didn't see this question come in, but I might be able to help.

There is an undocumented function on the UVMS called 'uniderby' that will give you the answers you are looking for. 

Try this command from the UVMS CLI:

uniderby -q "select * from  UNI_UV_NODES_INFO;"

You can pipe this to a text file, if necessary:

uniderby -q "select * from  UNI_UV_NODES_INFO;" > nodes_info.txt

If you want to see what tables you can get information from in the UVMS DB, you can run this command to list all tables:

uniderby -q "show tables;"

I hope this helps!

Regards,