JumpCloud (PowerShell)
This integration is deprecated in favor of API integration.
This document provides instructions on how to use a PowerShell script that connects to JumpCloud and queries user accounts and saves them in a CSV file to import the data into your application instance in Zilla. The CSV file is saved locally and also gets uploaded to the SFTP server. This CSV file is used to sync the data to Zilla using CSV import. Once the CSV import is successful, SFTP can be configured and scheduled.
The link for the JumpCloud PowerShell script: https://drive.google.com/drive/folders/1Q8dXV6bcYq4OTpFMzfN9D_7WT_AX1McP. Follow the instructions below to run the script.
If you do not have PowerShell installed on your machine, please refer to https://learn.microsoft.com/en-us/powershell/scripting/install/installing-powershell?view=powershell-7.2.
Steps to run the Script
Copy files (
JCscript.ps1
andconfig.json
) to a directory.cd
into this directory.Open PowerShell with run as administration in Windows, or a terminal window on Mac and Linux which you have launched in PowerShell by running the command pwsh. Enter the command:
Install-Module JumpCloud
When prompted, Press Y to install the JumpCloud PowerShell module.
Execute the command below to install Posh SSH PowerShell module for SFTP.
Install-Module -Name Posh-SSH
When prompted, Press Y to install the Posh SSH PowerShell module.
Add config values to
config.json
file.Execute the command below to run the script.
./JCscript.ps1
The script will create an accounts.csv
file in the current directory and will upload it to the SFTP server if isSftpEnabled
option is set to true in the config file.
To get JumpCloud API key, login to your JumpCloud Administrator console. On top right corner of the page, you will find profile image. Click on it and select My API Key
.
Sync accounts.csv file in Zilla
Log into Zilla with your admin account and click
Add Application
in the upper right of the page.Click the Custom Applications tab, fill in the necessary information and click
Add to Applications
.Click
Sync now
in the top right of the page and in the dialog click the slider below Accounts & Permissions CSV File Upload to enable csv import. ClickNext
.Upload
the accounts.csv file from local.Open Advanced options and check the box To map your active account status from your CSV, specify what value(s) indicate an ACTIVE account. All other rows will be marked as INACTIVE. In the text box, enter False.
Select Universal Id column as
_id
, Display Name column asusername
, Title column asjobTitle
, Account Status column assuspended
from the dropdowns. ClickNext
.Review the information and click
Import
.
When you have finished with all the steps above, review the information imported into Zilla.
Having trouble? Please contact support@zillasecurity.com