usql

usql

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


https://www.uptycs.com/blog/introducing-usql-an-interactive-command-line-tool-for-osquery-and-uptycs


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

      aws_tag_from_query.py This script applies AWS tags to resources based on an Uptycs saved query. It uses the AWS Python SDK (boto3).  Usage:   python3 aws_tag_from_query.py <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: ./uptjira.py <uptycs_apikey_file> [--domainsuffix <uptycs_domain>] The --domainsuffix flag is only required for uptycs domains other than '.uptycs.io' This python script ...
    • Uptycs alert integration with Rocket Chat

      Following is a step by step ReadMe for integration of Uptycs alert with Rocket Chat https://github.com/Uptycs/toolsreadme/blob/master/rocketchat.md
    • 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>.uptycs.io/saml/callback 2. ACS (Consumer) URL* : ...