usql is a command line SQL client for Uptycs with auto-complete and syntax highlighting features.

Pre-requisites for installation

Python 2.7 or higher

For complete details, refer to the article below

Usage / examples:

usql -k <api_key_file> global

global> <global_queries>

usql -k <api_key_file> realtime

realtime> set hostname = '<hostname>'

realtime> <realtime queries>

global> use realtime;

realtime> use global;

Related Articles

How to Obtain API key file

    • Related Articles

    • Export/Import Event,Alert Rules or Saved Queries

      The attached python3 code can be used to export one, several, or all event rules, alert rules, or saved queries.  1. Download the attached zip, unzip it 2. Install requirements: python3 -m pip install requirements.txt 3. Export desired objects to ...
    • AWS Tag Creation From Uptycs Saved Queries This script applies AWS tags to resources based on an Uptycs saved query. It uses the AWS Python SDK (boto3).  Usage:   python3 <uptycs_apikey_file> [-q <"query name"> | --all] -k <key> [-v <value>] -ec2 ...
    • Create Jira Tickets from Uptycs Alerts

      This python module allows you to create Jira tickets from Uptycs alerts.  Usage: ./ <uptycs_apikey_file> [--domainsuffix <uptycs_domain>] The --domainsuffix flag is only required for uptycs domains other than '' This python script ...
    • Uptycs alert integration with Rocket Chat

      Following is a step by step ReadMe for integration of Uptycs alert with Rocket Chat
    • OneLogin Integration

      Overview This document outlines all the information needed / provisioned  for Uptycs to configure OneLogin authentication Setup on the your side 1. ACS (Consumer) URL Validator* : https://<domain> 2. ACS (Consumer) URL* : ...