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.
Follow with the plugin for Jumpcloud via:
steampipe plugin install jumpcloud
Then configure your environment as documented:
You're all set and you can issue queries.
1. List all programs installed in last 24 hours
2. List unused user groups
Thanks for reading. Would be fun to see some example queries here in the responses. 😉