Just do a select * and look at the data. I found mine by name. Everything else should be clear to you then. If not, learn basic SQL.
On Jun 27, 2013, at 8:02 PM, Maurice Lawler wrote: > Is ‘ID’ the UUID, the long string of letters/numbers. If not, how would I get > the correct ID? > > > > - Maurice > On Jun 27, 2013, at 3:16 AM, France <mailingli...@isg.si> wrote: > >> Your assumptions are correct. >> >> I've done it like this. Ofcourse you must select appropriate status: >> use cloud >> update vm_instance set state='Running' where id='293'; >> >> Regards, >> F. >> >> On 27/6/13 9:30 AM, Maurice Lawler wrote: >>> Hello, >>> >>> How can I manipulate the database to tell CS that the system VMS are >>> stopped and not 'Starting' along with that; once stopped I can then either >>> restart them and or destroy and let then system recreate, correct? >