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 <jayarama...@gmail.com > <javascript:>> 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 puppet-users...@googlegroups.com <javascript:>. >> 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 > austin...@puppet.com <javascript:> > -- 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/499c4c3e-5f15-4e73-aca5-faed2185e10e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
