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