Giter VIP home page Giter VIP logo

turbot / steampipe-plugin-crowdstrike Goto Github PK

View Code? Open in Web Editor NEW
7.0 9.0 1.0 470 KB

Use SQL to instantly query CrowdStrike resources. Open source CLI. No DB required.

Home Page: https://hub.steampipe.io/plugins/turbot/crowdstrike

License: Apache License 2.0

Makefile 0.27% PLSQL 0.91% Go 98.82%
crowdstrike crowdstrike-api crowdstrike-falcon-api postgres postgresql-fdw sql steampipe steampipe-plugin hacktoberfest postgresql

steampipe-plugin-crowdstrike's Introduction

image

CrowdStrike Plugin for Steampipe

Use SQL to query resources from CrowdStrike.

Quick start

Install the plugin with Steampipe:

steampipe plugin install crowdstrike

Run a query:

select
  created_timestamp,
  host_info -> 'hostname' AS hostname,
  status
from
  crowdstrike_spotlight_vulnerability
where
  created_timestamp > now() - interval '15 days';

Engines

This plugin is available for the following engines:

Engine Description
Steampipe The Steampipe CLI exposes APIs and services as a high-performance relational database, giving you the ability to write SQL-based queries to explore dynamic data. Mods extend Steampipe's capabilities with dashboards, reports, and controls built with simple HCL. The Steampipe CLI is a turnkey solution that includes its own Postgres database, plugin management, and mod support.
Postgres FDW Steampipe Postgres FDWs are native Postgres Foreign Data Wrappers that translate APIs to foreign tables. Unlike Steampipe CLI, which ships with its own Postgres server instance, the Steampipe Postgres FDWs can be installed in any supported Postgres database version.
SQLite Extension Steampipe SQLite Extensions provide SQLite virtual tables that translate your queries into API calls, transparently fetching information from your API or service as you request it.
Export Steampipe Plugin Exporters provide a flexible mechanism for exporting information from cloud services and APIs. Each exporter is a stand-alone binary that allows you to extract data using Steampipe plugins without a database.
Turbot Pipes Turbot Pipes is the only intelligence, automation & security platform built specifically for DevOps. Pipes provide hosted Steampipe database instances, shared dashboards, snapshots, and more.

Developing

Prerequisites:

Clone:

git clone https://github.com/turbot/steampipe-plugin-crowdstrike.git
cd steampipe-plugin-crowdstrike

Build, which automatically installs the new version to your ~/.steampipe/plugins directory:

make

Configure the plugin:

cp config/* ~/.steampipe/config
vi ~/.steampipe/config/crowdstrike.spc

Try it!

steampipe query
> .inspect crowdstrike

Further reading:

Open Source & Contributing

This repository is published under the Apache 2.0 (source code) and CC BY-NC-ND (docs) licenses. Please see our code of conduct. We look forward to collaborating with you!

Steampipe is a product produced from this open source software, exclusively by Turbot HQ, Inc. It is distributed under our commercial terms. Others are allowed to make their own distribution of the software, but cannot use any of the Turbot trademarks, cloud services, etc. You can learn more in our Open Source FAQ.

Get Involved

Join #steampipe on Slack →

Want to help but don't know where to start? Pick up one of the help wanted issues:

steampipe-plugin-crowdstrike's People

Contributors

binaek avatar cbruno10 avatar dependabot[bot] avatar madhushreeray30 avatar misraved avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Forkers

chefren

steampipe-plugin-crowdstrike's Issues

the 'crowdstrike_spotlight_vulnerability' table does not work

Describe the bug
Any query on the "crowdstrike_spotlight_vulnerability" table returns the following error:

Error: [GET /spotlight/queries/vulnerabilities/v1][403] queryVulnerabilitiesForbidden &{Errors:[{Code:403 Message:access denied, authorization failed}] Meta:PoweredBy:crowdstrike-api-gateway QueryTime:2.26e-07 TraceID:45a8f4e8-6dcb-43f0-91c5-b27a4b4d3423}} (SQLSTATE HV000)

Despite having all scopes/permissions checked off on the used credentials. The region is us-2.

Steampipe version
Example: v0.17.4

Plugin version
Example: v0.2.0

To reproduce
Steps to reproduce the behavior (please include relevant code and/or commands):
Run the following Crowstrike steampipe query, the same as the main one in the plugin's page:

select
  created_timestamp,
  host_info -> 'hostname' AS hostname,
  status
from
  crowdstrike_spotlight_vulnerability
where
  created_timestamp > now() - interval '15 days';

Expected behavior
The table should return the required information or be removed from the plugin.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.