> 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/CAE4bNTmU6MhRDXN2mQ0_4T%3DOTpz-ZboWfUeMZ7%3Dzd-V8nW%3DGvg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
