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 [email protected]. 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.
