cancel
Showing results for 
Search instead for 
Did you mean: 

How to run queries using SQL against JumpCloud API's by using Steampipe

JuergenKlaassen
Rising Star III
Rising Star III

Hello

Have you heard of Steampipe before? 
Steampipe allows you to run queries in SQL against various (more than 200) cloud services including AWS, Github, Azure, Slack, and JumpCloud as well - along with many others. 

All you need (on macOS) is to install the CLI of Steampipe via brew and then install the respective plugin, set your API- and ORG-Key and you're good to go. 

The documentation is excellent and makes the process super straightforward. In a couple of minutes you can run your first queries. 

Installation:

Screenshot 2023-03-30 at 13.36.30.png

 Follow with the plugin for Jumpcloud via: 

 

steampipe plugin install jumpcloud

 

 Then configure your environment as documented:

Screenshot 2023-03-30 at 10.57.25.png

 You're all set and you can issue queries.

Screenshot 2023-03-30 at 13.42.07.png

 

Examples:

1. List all programs installed in last 24 hours

Screenshot 2023-03-30 at 13.43.58.png

 2. List unused user groups

Screenshot 2023-03-30 at 13.45.31.png

Thanks for reading. 
Would be fun to see some example queries here in the responses. 😉

Cheers
Juergen

0 REPLIES 0