Skip to main content

puppetdb tools and shared libraries

Project description


This package provides tools to interact with a puppetdb via a CLI. These scripts use a (configurable-via-environment-variable) json config to determine how to talk to the server.

These tools were written to be less general than any existing tools I've seen out there. Specifically, I don't want to write the necessary JSON input at the command-line every time I'm trying to do a basic query.

These scripts should support both the v3 and v4 PuppetDB APIs.

What is puppetdb?


This is not an exhaustive list.


Queries for a given fact, and lists the hosts that have that fact (along with the value of the fact). A specific value can be specified as well. Example: puppetdb-fact puppetversion


puppetdb-failed queries the puppetdb to find out which hosts failed on their last puppet check-in.


Queries the puppetdb for hosts that had failures in their last run, and prints out all of the things failed. This is a useful report to send out via email to your team.


Queries the puppetdb for host names, based on zone/role/subrole (our local three-level way of looking up hostnames).


List all hosts in the puppetdb.


For each host that failed its last puppet run, find out when it last had a successful puppet run. This can be useful for determining whether a machine is really "supported" any more, especially in conjunction with puppetdb-tooquiet.


List the classes deployed on a given system. Should match the per-host classes.txt file.


Lists events that have affected a given node over the last 48 hours (configurable) in much the same format as you would have seen running the puppet agent -t manually.


Lists facts on a node or set of nodes; this should be grep-able enough to let you find, say, uptime across a large swath of hosts, or similar.


Lists resources deployed on a node or set of nodes. This is very powerful, and the CLI is probably not good enough for what you'd actually want to do with the package.


Lists kernel versions and facts.


Search for a given resource type across all hosts, e.g. puppetdb-resources Class --match Mysql::Server


puppetdb-tangled queries the puppetdb to find hosts which are "tangled", and reports on the associated hosts/events on STDOUT. A "tangled" host is defined as one where an event is occurring on that host and over and over again over the last several runs, which probably indicates that a change is not successful. For instance, Package['foo'] removes Package['bar'] and then Package['bar'] is installed afterwards.


Lists nodes that have not checked into the server for the last 48 hours (configurable). Suitable for sending as an email to your team.


Simple bash script to wrap curl with the values of 'key' and 'cert' that come out of the central configuration file.

Local Scripts

These scripts may not be helpful to others, but are templates for our own use and show how we interact with facts. These may be useful to others as templates.

  • puppetdb-host-csv
  • puppetdb-manager
  • puppetdb-monitor
  • puppetdb-report-usage
  • puppetdb-uuid-by-host

Config Files


This should work for talking to an https port, where auth requires your own puppet cert (which will only work as root):

    "server": "https://{puppetdb_fqdn}:8081",
    "ca": "/etc/puppetlabs/puppet/ssl/certs/ca.pem",
    "cert": "/etc/puppetlabs/puppet/ssl/certs/{fqdn}",
    "key": "/etc/puppetlabs/puppet/ssl/private_keys/{fqdn}",
    "api_version": 4

If you can make queries via http (e.g. without auth):

    "server": "http://{puppetdb_fqdn}:8080",
    "api_version": 3

Environment Variables

You can select alternate configuration files by setting PUPPETDB_CONFIG, e.g.:

export PUPPETDB_CONFIG=~/rpm/puppetdb-tools/etc/puppetdb/puppetdb3.json

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for puppetdb-tools, version 2.2.2
Filename, size File type Python version Upload date Hashes
Filename, size puppetdb_tools-2.2.2-py3-none-any.whl (7.6 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size puppetdb-tools-2.2.2.tar.gz (7.4 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page