Pull All Local Account Details from All Devices
Overview
This article explains how to pull all local user account details from every system connected to JumpCloud using PowerShell. The process involves connecting to your JumpCloud environment, running a simple command to retrieve system user details, and exporting the output for analysis or reporting.
Step 1 – Install the JumpCloud PowerShell Module
For Windows
- Open PowerShell as Administrator.
- Run the following commands one by one:
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned Install-Module JumpCloud
- Confirm the prompts that appear during installation.
- If you face issues, refer to the official guide linked in your JumpCloud documentation or contact our experts.
- .
For macOS
- Download PowerShell for macOS from the official source as per your device version.
- Once installed, open PowerShell and execute:
Install-Module JumpCloud
- If you face connection or setup issues, refer to the guide or reach out to support@netnxt.com
- for assistance.
Step 2 – Connect PowerShell to JumpCloud
- Launch PowerShell as Administrator.
- Run the command below to connect to JumpCloud:
Connect-JCOnline
- Enter your JumpCloud API Key when prompted.
Important:
If you generate a new API key, your previous one becomes invalid. Always store the key securely and reuse it when required instead of regenerating it frequently.
Step 3 – Pull Local Account Details
Once connected, run the following command to retrieve the local account information from all devices registered in JumpCloud:
Get-JCSystemInsights -Table User | Select-Object SystemID, Directory, Username
This command displays a list of local users along with their system IDs and directory type (local or JumpCloud-managed).
It’s especially useful for administrators who need a consolidated view of all user accounts across multiple systems.
Step 4 – Export Details to CSV
To generate a downloadable report of all user accounts across devices, run the following command:
Get-JCSystemInsights -Table User | Select-Object SystemID, Directory, Username | Export-Csv AllUserAccountOfAllDevices.csv
This will create a CSV file named AllUserAccountOfAllDevices.csv in your current PowerShell working directory.
You can open it with Excel or import it into a reporting system for further analysis.
Validation and Notes
- Verify that the CSV file has been generated successfully in your working directory.
- Ensure System Insights is enabled in JumpCloud for accurate data retrieval.
- If the result appears empty, check your API key validity or connectivity.
- For reporting automation, you can schedule this PowerShell command to run periodically using Windows Task Scheduler or cron jobs on macOS.
