Re: [Puppet Users] Historical reporting, BI from puppetdb?

2014-06-18 Thread Ryan Anderson
I mentioned Pentaho (albeit spelled incorrectly) as an example, as I saw it mentioned a number of times online due to its open source community variant and full feature set. Thanks for the links, it appears that slurping data into Pentaho via puppetdb's REST API or otherwise is quite possible

[Puppet Users] Historical reporting, BI from puppetdb?

2014-06-17 Thread Ryan Anderson
I use puppetdb + puppetboard, which are very useful to see the current state of my environment. Puppetboard also provides a very nice representation of each agent's most recent reports. However, I want to take it to the next level and create custom historical reports for business intelligence

Re: [Puppet Users] Historical reporting, BI from puppetdb?

2014-06-17 Thread Ken Barber
I use puppetdb + puppetboard, which are very useful to see the current state of my environment. Puppetboard also provides a very nice representation of each agent's most recent reports. However, I want to take it to the next level and create custom historical reports for business intelligence

Re: [Puppet Users] Historical reporting, BI from puppetdb?

2014-06-17 Thread Spencer Krum
You absolutely want to build that against the puppetdb rest interface and not by hitting postgres directly. I'd be interested in getting at this data as well, if you find a way or build a neat little application to do it. On Tue, Jun 17, 2014 at 3:35 PM, Ken Barber k...@puppetlabs.com wrote:

Re: [Puppet Users] Historical reporting, BI from puppetdb?

2014-06-17 Thread Ryan Anderson
Thanks, good to know. While the REST API would be the method to get at the data, my issue is that I'm not capable of writing a web app + data repository that can generate web-based reports, etc. I've actually gotten into the habit of running one-off queries using the API with curl to get

Re: [Puppet Users] Historical reporting, BI from puppetdb?

2014-06-17 Thread Ken Barber
Thanks, good to know. While the REST API would be the method to get at the data, my issue is that I'm not capable of writing a web app + data repository that can generate web-based reports, etc. I've actually gotten into the habit of running one-off queries using the API with curl to get

Re: [Puppet Users] Historical reporting, BI from puppetdb?

2014-06-17 Thread Ken Barber
Sorry, do you mean Pentaho? On Tue, Jun 17, 2014 at 9:53 PM, Ken Barber k...@puppetlabs.com wrote: Thanks, good to know. While the REST API would be the method to get at the data, my issue is that I'm not capable of writing a web app + data repository that can generate web-based reports, etc.

Re: [Puppet Users] Historical reporting, BI from puppetdb?

2014-06-17 Thread Ken Barber
Ryan, What about something like this? http://wiki.pentaho.com/display/EAI/Rest+Client This page seems to mix in general actions with integration steps, but there are more integration types available here: http://wiki.pentaho.com/display/EAI/Pentaho+Data+Integration+Steps ken. On Tue, Jun 17,

Re: [Puppet Users] Historical reporting, BI from puppetdb?

2014-06-17 Thread Ken Barber
And others: http://wiki.pentaho.com/display/EAI/JSON+Input http://wiki.pentaho.com/display/EAI/HTTP+Client Perhaps, you could combine the JSON input perhaps on the contents of a 'puppetdb export' tarball if you wanted to analyze the data from a previous backup :-). ken. On Tue, Jun 17, 2014 at