Re: Cloudmonkey question

2015-02-16 Thread Mike Tutkowski
We have such a weird way of storing storage tags in the DB.

They get stored as individual rows in the storage_pool_details table (which
is fine). If the value in the "value" column is "true", then we assume the
"key" column contains the name of a storage tag.

This makes it more difficult than it should be to store arbitrary details
that are booleans.

On Mon, Feb 16, 2015 at 7:25 AM, Andrei Mikhailovsky 
wrote:

> After digging a bit further and getting hints from Rohit, the correct
> syntax to achieve this without using any additional scripting would be:
>
> list volumes tags[0].key=remote_backup tags[0].value=yes
>
> This will only list the volumes with the tag remote_backup=yes
>
> Thanks for your help and ideas
>
> Andrei
>
> - Original Message -
>
> > From: "Mike Tutkowski" 
> > To: dev@cloudstack.apache.org
> > Sent: Monday, 16 February, 2015 5:34:26 AM
> > Subject: Re: Cloudmonkey question
>
> > Yeah, that's true - it does look like that should work.
>
> > On Sunday, February 15, 2015, Ian Duffy  wrote:
>
> > > Assuming I'm reading and understanding the API docs correctly at
> > >
> > >
> http://cloudstack.apache.org/docs/api/apidocs-4.1/root_admin/listVolumes.html
> > >
> > > list volumes tags=remote_backup
> > >
> > > should list everything with the tag remote_backup
> > >
> > > On 15 February 2015 at 23:50, Mike Tutkowski
> > > > wrote:
> > > > I believe you'd need to write a script to invoke CloudMonkey to
> > > > execute
> > > the
> > > > list command and then parse the results of the command (keeping
> > > > only what
> > > > you're interested in).
> > > >
> > > > On Sunday, February 15, 2015, Andrei Mikhailovsky
> > > >  > > > wrote:
> > > >
> > > >> Hello guys,
> > > >>
> > > >> I have a silly question; can't really find an answer by
> > > >> googling. How
> > > do I
> > > >> use tags when I want to query something. For instance, if I want
> > > >> to
> > > query
> > > >> volumes using "list volumes" command. If i would like to get
> > > >> only the
> > > >> results containing a certain tag, like a tag with key
> > > >> remote_backup and
> > > >> value of yes; how would the list volumes command should look
> > > >> like?
> > > >>
> > > >> Thanks
> > > >>
> > > >> Andrei
> > > >>
> > > >
> > > >
> > > > --
> > > > *Mike Tutkowski*
> > > > *Senior CloudStack Developer, SolidFire Inc.*
> > > > e: mike.tutkow...@solidfire.com 
> > > > o: 303.746.7302
> > > > Advancing the way the world uses the cloud
> > > > <http://solidfire.com/solution/overview/?video=play>*™*
> > >
>
> > --
> > *Mike Tutkowski*
> > *Senior CloudStack Developer, SolidFire Inc.*
> > e: mike.tutkow...@solidfire.com
> > o: 303.746.7302
> > Advancing the way the world uses the cloud
> > <http://solidfire.com/solution/overview/?video=play>*™*
>



-- 
*Mike Tutkowski*
*Senior CloudStack Developer, SolidFire Inc.*
e: mike.tutkow...@solidfire.com
o: 303.746.7302
Advancing the way the world uses the cloud
<http://solidfire.com/solution/overview/?video=play>*™*


Re: Cloudmonkey question

2015-02-16 Thread Andrei Mikhailovsky
After digging a bit further and getting hints from Rohit, the correct syntax to 
achieve this without using any additional scripting would be: 

list volumes tags[0].key=remote_backup tags[0].value=yes 

This will only list the volumes with the tag remote_backup=yes 

Thanks for your help and ideas 

Andrei 

- Original Message -

> From: "Mike Tutkowski" 
> To: dev@cloudstack.apache.org
> Sent: Monday, 16 February, 2015 5:34:26 AM
> Subject: Re: Cloudmonkey question

> Yeah, that's true - it does look like that should work.

> On Sunday, February 15, 2015, Ian Duffy  wrote:

> > Assuming I'm reading and understanding the API docs correctly at
> >
> > http://cloudstack.apache.org/docs/api/apidocs-4.1/root_admin/listVolumes.html
> >
> > list volumes tags=remote_backup
> >
> > should list everything with the tag remote_backup
> >
> > On 15 February 2015 at 23:50, Mike Tutkowski
> > > wrote:
> > > I believe you'd need to write a script to invoke CloudMonkey to
> > > execute
> > the
> > > list command and then parse the results of the command (keeping
> > > only what
> > > you're interested in).
> > >
> > > On Sunday, February 15, 2015, Andrei Mikhailovsky
> > >  > > wrote:
> > >
> > >> Hello guys,
> > >>
> > >> I have a silly question; can't really find an answer by
> > >> googling. How
> > do I
> > >> use tags when I want to query something. For instance, if I want
> > >> to
> > query
> > >> volumes using "list volumes" command. If i would like to get
> > >> only the
> > >> results containing a certain tag, like a tag with key
> > >> remote_backup and
> > >> value of yes; how would the list volumes command should look
> > >> like?
> > >>
> > >> Thanks
> > >>
> > >> Andrei
> > >>
> > >
> > >
> > > --
> > > *Mike Tutkowski*
> > > *Senior CloudStack Developer, SolidFire Inc.*
> > > e: mike.tutkow...@solidfire.com 
> > > o: 303.746.7302
> > > Advancing the way the world uses the cloud
> > > <http://solidfire.com/solution/overview/?video=play>*™*
> >

> --
> *Mike Tutkowski*
> *Senior CloudStack Developer, SolidFire Inc.*
> e: mike.tutkow...@solidfire.com
> o: 303.746.7302
> Advancing the way the world uses the cloud
> <http://solidfire.com/solution/overview/?video=play>*™*


Re: Cloudmonkey question

2015-02-15 Thread Mike Tutkowski
Yeah, that's true - it does look like that should work.

On Sunday, February 15, 2015, Ian Duffy  wrote:

> Assuming I'm reading and understanding the API docs correctly at
>
> http://cloudstack.apache.org/docs/api/apidocs-4.1/root_admin/listVolumes.html
>
> list volumes tags=remote_backup
>
> should list everything with the tag remote_backup
>
> On 15 February 2015 at 23:50, Mike Tutkowski
> > wrote:
> > I believe you'd need to write a script to invoke CloudMonkey to execute
> the
> > list command and then parse the results of the command (keeping only what
> > you're interested in).
> >
> > On Sunday, February 15, 2015, Andrei Mikhailovsky  > wrote:
> >
> >> Hello guys,
> >>
> >> I have a silly question; can't really find an answer by googling. How
> do I
> >> use tags when I want to query something. For instance, if I want to
> query
> >> volumes using "list volumes" command. If i would like to get only the
> >> results containing a certain tag, like a tag with key remote_backup and
> >> value of yes; how would the list volumes command should look like?
> >>
> >> Thanks
> >>
> >> Andrei
> >>
> >
> >
> > --
> > *Mike Tutkowski*
> > *Senior CloudStack Developer, SolidFire Inc.*
> > e: mike.tutkow...@solidfire.com 
> > o: 303.746.7302
> > Advancing the way the world uses the cloud
> > *™*
>


-- 
*Mike Tutkowski*
*Senior CloudStack Developer, SolidFire Inc.*
e: mike.tutkow...@solidfire.com
o: 303.746.7302
Advancing the way the world uses the cloud
*™*


Re: Cloudmonkey question

2015-02-15 Thread Ian Duffy
Assuming I'm reading and understanding the API docs correctly at
http://cloudstack.apache.org/docs/api/apidocs-4.1/root_admin/listVolumes.html

list volumes tags=remote_backup

should list everything with the tag remote_backup

On 15 February 2015 at 23:50, Mike Tutkowski
 wrote:
> I believe you'd need to write a script to invoke CloudMonkey to execute the
> list command and then parse the results of the command (keeping only what
> you're interested in).
>
> On Sunday, February 15, 2015, Andrei Mikhailovsky  wrote:
>
>> Hello guys,
>>
>> I have a silly question; can't really find an answer by googling. How do I
>> use tags when I want to query something. For instance, if I want to query
>> volumes using "list volumes" command. If i would like to get only the
>> results containing a certain tag, like a tag with key remote_backup and
>> value of yes; how would the list volumes command should look like?
>>
>> Thanks
>>
>> Andrei
>>
>
>
> --
> *Mike Tutkowski*
> *Senior CloudStack Developer, SolidFire Inc.*
> e: mike.tutkow...@solidfire.com
> o: 303.746.7302
> Advancing the way the world uses the cloud
> *™*


Re: Cloudmonkey question

2015-02-15 Thread Mike Tutkowski
I believe you'd need to write a script to invoke CloudMonkey to execute the
list command and then parse the results of the command (keeping only what
you're interested in).

On Sunday, February 15, 2015, Andrei Mikhailovsky  wrote:

> Hello guys,
>
> I have a silly question; can't really find an answer by googling. How do I
> use tags when I want to query something. For instance, if I want to query
> volumes using "list volumes" command. If i would like to get only the
> results containing a certain tag, like a tag with key remote_backup and
> value of yes; how would the list volumes command should look like?
>
> Thanks
>
> Andrei
>


-- 
*Mike Tutkowski*
*Senior CloudStack Developer, SolidFire Inc.*
e: mike.tutkow...@solidfire.com
o: 303.746.7302
Advancing the way the world uses the cloud
*™*


Cloudmonkey question

2015-02-15 Thread Andrei Mikhailovsky
Hello guys, 

I have a silly question; can't really find an answer by googling. How do I use 
tags when I want to query something. For instance, if I want to query volumes 
using "list volumes" command. If i would like to get only the results 
containing a certain tag, like a tag with key remote_backup and value of yes; 
how would the list volumes command should look like? 

Thanks 

Andrei