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 <[email protected]> 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/CAE4bNTmU6MhRDXN2mQ0_4T%3DOTpz-ZboWfUeMZ7%3Dzd-V8nW%3DGvg%40mail.gmail.com > . > For more options, visit https://groups.google.com/d/optout. > -- Spencer Krum (619)-980-7820 -- 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/CADt6FWOZV6vF28M1CwWL6sjb_JJJ0x4WXEzojbySnEBMDX%2BeEQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
