3 ms·

select * from shell; Use SQL to exec commands across hosts

• nathanwallace 3y ago
  Use SQL to run shell commands against any host - local or remote, Linux or Windows, through proxies & bastions. Aggregates results from multiple hosts. Steampipe - https://steampipe.io https://steampipe.io exec plugin - https://hub.steampipe.io/plugins/turbot/exec https://hub.steampipe.io/plugins/turbot/exec It's a Postgres FDW - https://www.postgresql.org/docs/14/ddl-foreign-data.html https://www.postgresql.org/docs/14/ddl-foreign-data.html Uses Terraform provisioner code - https://developer.hashicorp.com/terraform/language/resources/provisioners/remote-exec https://developer.hashicorp.com/terraform/language/resources... See also osquery, which runs on the host & has more structure - https://www.osquery.io/ https://www.osquery.io/