JumpCloud (PowerShell)

Owned by Het Delwadiya (Unlicensed)
Last updated: Jan 06, 2023 by Nitin Sonawane
3 min read

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

  1. Copy files (JCscript.ps1 and config.json) to a directory. cd into this directory.

  2. 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

  3. When prompted, Press Y to install the JumpCloud PowerShell module.

  4. Execute the command below to install Posh SSH PowerShell module for SFTP.

    Install-Module -Name Posh-SSH

  5. When prompted, Press Y to install the Posh SSH PowerShell module.

  6. Add config values to config.json file.

  7. 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

  1. Log into Zilla with your admin account and click Add Application in the upper right of the page.

  2. Click the Custom Applications tab, fill in the necessary information and click Add to Applications.

  3. 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. Click Next.

  4. Upload the accounts.csv file from local.

     

  5. 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.

     

  6. Select Universal Id column as _id , Display Name column as username, Title column as jobTitle, Account Status column as suspended from the dropdowns. Click Next.

     

  7. 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