On Wednesday, May 8, 2013 5:31:16 AM UTC-7, Erik Dalén wrote: > On Tuesday 7 May 2013 at 01:44, Chris Price wrote: > > * Report queries > > > > The query endpoint `experimental/event` has been augmented to support a > > > much more interesting set of queries against report data. You can now > query > > for events by status (e.g. `success`, `failed`, `noop`), timestamp > ranges, > > resource types/titles/property name, etc. This should make the report > > storage feature of PuppetDB *much* more valuable! > > Very nice news. > > But is this planned to get some further extensions? Some queries I would > like to make still seem quite hard (at least to do in a single query). > > For example finding all nodes that failed their last puppet run seems like > it would need one node query and then a event query for each one. > > Will there be better support for subqueries across reports, events and the > other endpoints? That would make some types of queries easier. For example > you could make a single query to get the puppet version of all nodes that > failed any resource within the last 30 mins. > > This is definitely unfinished (it's under /experimental). We plan to at least add subqueries like you get with resources/facts, and possibly counting, grouping, and selecting a subset of columns. If you have any further use cases that those features still wouldn't address, let us know. We want to make this API as robust as we can; until we do, we thought it was best to get what we already had out for users to try.
> Any suggestions for nifty syntax for puppetdbquery to query stuff like > that? :) > > I'll.... get back to you on that. :) > -- > Erik Dalén > > > -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/puppet-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
