[Puppet Users] View all the failed executions on Puppetdb

2019-02-14 Thread Aditya S
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: Eva

[Puppet Users] Re: View all the failed executions on Puppetdb

2019-02-14 Thread Aditya S
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_r

Re: [Puppet Users] Re: View all the failed executions on Puppetdb

2019-02-14 Thread Austin Blatt
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 ar

Re: [Puppet Users] Re: View all the failed executions on Puppetdb

2019-02-14 Thread Aditya S
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: