I figured this out. I missed a step while setting up the PuppetDB. I did not add "reports = store,puppetdb" in the puppet.conf so it never really added the reports in the database.
Adding the following and restarting it fixed the issues for me: # vi /etc/puppetlabs/puppet/puppet.conf [master] storeconfigs = true storeconfigs_backend = puppetdb reports = store,puppetdb On Thursday, February 14, 2019 at 5:15:15 PM UTC-8, Aditya S wrote: > > Thanks Austin, > > The output didn't give me any information so I tried to look in the > database. Is it coming from *public.report_statuses *or > *public.resource_events* because they are both blank for me. Is that the > right tabel? > > Please let me know. > > Thanks! > > On Thursday, February 14, 2019 at 1:52:21 PM UTC-8, Austin Blatt wrote: >> >> If you want all information about all failed reports you can query for >> reports that have a status of failed. An example using curl would look >> like, >> >> curl -X POST http://localhost:8080/pdb/query/v4 \ >> -H 'Content-Type:application/json' \ >> -d '{"query": "reports { status = \"failed\" }"}' >> >> There are a few other options that might be of interest to you as well, >> for example you can query for just the certname of all agents whose most >> recent Puppet run failed with something like, >> >> curl -X POST http://localhost:8080/pdb/query/v4 \ >> -H 'Content-Type:application/json' \ >> -d '{"query": "reports[certname] { status = \"failed\" and >> latest_report? = true}"}' >> >> You can find more docs on querying the reports endpoint for PuppetDB >> 5.2.7 here >> <https://puppet.com/docs/puppetdb/5.2/api/query/v4/reports.html>. I hope >> this helps! >> >> On Thu, Feb 14, 2019 at 8:46 AM Aditya S <[email protected]> wrote: >> >>> Sorry I forgot to add: >>> puppetserver version: 5.3.7 >>> puppetdb version: 5.2.7 >>> puppet agent version: 5.5.8 >>> >>> >>> On Thursday, February 14, 2019 at 8:42:35 AM UTC-8, Aditya S wrote: >>>> >>>> Hi, >>>> >>>> Is there a way to see failed executions in PuppetDB? I can see all the >>>> successful classes in "public.catalog_resources" but is there a way to >>>> see >>>> all failed executions. For example something like: >>>> "Error: Could not retrieve catalog from remote server: Error 500 on >>>> SERVER: Server Error: Evaluation Error: Error while evaluating a Function >>>> Call, Could not find class" >>>> >>>> If I were not using psql but trying the REST API like >>>> "/pdb/query/v4/reports"? >>>> >>>> Thanks! >>>> >>>> -- >>> 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/14aa3fc7-1e85-4f2c-bfb3-aa2e1ed1b074%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/puppet-users/14aa3fc7-1e85-4f2c-bfb3-aa2e1ed1b074%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> -- >> *Austin Blatt* >> Associate Software Engineer >> [email protected] >> > -- 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/74c88b78-8271-4891-b49b-fa2c5887b766%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
