Troubleshoot: Confirm System Insights on Local Device

Symptoms

Sometimes you can not view System Insights data in the Admin Portal. This is another way to check to see if System Insights (jcosqueryi.exe) is working properly on the local device.

Resolution

• To verify if jcosqueryi.exe exists, go to C:/Program Files/JumpCloud/jcosqueryi.exe
• Run Powershell as an Admin.
• Change directory to the location of jcosqueryi.exe by running this command: cd 'C:\Program Files\JumpCloud'
• Run jcosqueryi.exe by running this command: .\jcosqueryi.exe
• Afterwards, you can run any query within osquery
  • For example, to pull system information you can run: SELECT * FROM system_info;
  • For a full list of tables that can be queried use the command: .tables