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 YAML-formatted reports, which in part got me wanting more.
On Tuesday, June 17, 2014 5:36:07 PM UTC-5, Ken Barber wrote: > > > 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 (eg > How > > many changes per day over the last month? How many RHEL5 virtual systems > as > > of $DATE?). I've looked online and not found many solutions on this. > Might > > Foreman provide this? Even if it does....I'm not sure I'm ready for that > > commitment. Since puppetdb uses PostgreSQL, I'd imagine most any BI tool > > that supports it (eg Pentah) could be configured to get what I want. > > However, is anyone successfully doing this? > > So something to note, while this is an interesting idea, you have to > be careful. We make zero commitments about the stability of the > database schema today ... so expect an upgrade to break things, > especially if we have a migration. In short, accessing the data > directly is not a supported stable API. Not saying it won't work, but > just letting you know the risks involved here. > > Not sure how useful it is, we do have a lot of complex query > capability just built into PDB via the REST interface which might be > able to provide what you need: > > http://docs.puppetlabs.com/puppetdb/2.0/api/query/v4/query.html > > ken. > -- 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 puppet-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/e56002b6-946f-4a30-957c-a45df13a751e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
