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

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

    • 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* : ...

    • Auth0 Integration

      Overview This document outlines steps / information needed  to configure Auth0 authentication Procedure Create Uptycs Application Provision "Allowed Callback URLs", "Allowed Web Origins" Note : Replace <domain> with the actual domain. Enable SAML2 ...

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

    • SAML Configuration

      Uptycs supports SAML 2.0 authentication and is configured on the back-end by Uptycs Customer Success Team. Before generating metadata file on your side, request Uptycs to provide the config xml with contains Uptycs public cert. Here are the other ...