Browse Articles

Welcome
- Welcome to Monitoring
- Getting Started
- Overview and Features
- System Requirements
Account Management
- Companies
- Users & Permissions
- Contacts & Contact Methods
- Account Settings
Web Account
- Introduction to your Monitoring Web Account
- Multiple Companies
- Multiple Users
- Charts and Graphs
- About the Search Index
- About Dashboards
- Setting Up Dashboards
- Notifications
Applications
- About Monitoring Applications
- Inventory Application
- Alerting Application
- Remote Support Application
- Data Collection Application
- Reports Application
- Server Health Application
- Logs Application
- Automation Application
- Netflow Application
- WSUS Patch Reporting Application
- VMware Application
- Zendesk Application
- XenServer Application
Data Collection
- GoToAssist Setup Assistant
- About Data Collection
- LAN Data Collection (Crawler)
- Off-LAN Data Collection
- Internet Services Testing
- About the Crawler
- Configuring Crawler Credentials
- About Crawler Plugins
Community
- Community
- About Forums and Discussions
- About Share-Its
- User Profiles
Search
- Introduction to Search
- Basic Search
- Search Shortcuts
- Advanced Search
- Using Search Templates
- Nested Search
For Developers
- For Developers
- GoToAssist Developer Tools
- Developing Applications
- GoToAssist API
- Ontology
- About Databases
- Database Concepts
- Straddling Dual Databases
- Tree-Structured Database
- Application Tutorial
- Writing Crawler Plugins
About PQL
- About GoToAssist Query Language (PQL)
- GoToAssist Query Language (PQL) Overview
- PQL Index
- PQL Keywords
- Data Types
Using PQL
- Alternatives
- Subqueries
- Expressions
- Regular Expressions (REGEX)
- Boolean Expressions
- Ephemeral Nodes
- Floating Points
- Identifiers
PQL Functions
- PQL Functions
- Join Function
- History Function
- PQL nvl and coalesce Functions
- Abbreviate Function
- Zip Function
- ID Function
- Available_history Function
- Cast Functions
- Child Function
- Created_at Function
- PQL downcase, lower, upcase and upper functions
- First Function
- Raw_history Function
- Format Function
- Regex Function
- Substring Function
- Has_history Function
- Aggregate Functions
- Num_children Function
- Observed_at Function
- Parent Function
PQL Statements
- Statements
- SELECT
- MERGE
- INSERT
- UPDATE
- DELETE
PQL Clauses and Values
- FROM clause
- WHERE clause
- NULL value
- True and False
PQL Operators
- Operators
- AND operator
- NOT operator
- OR operator
PQL Paths
- Paths
- Path Scoped Predicate
- Path Scoped Projection
- Qualified and Unqualified Paths
PQL Tutorials
- Writing simple queries using SELECT and FROM
- Writing queries using the WHERE clause
- Writing queries that extract historical values
- Writing basic queries
Examples
- Examples
- Examples for Sample Databases
- Examples Historical Data
- Examples IT scenarios
- Creating a dashboard NOC
- Query Examples
- Query Sandbox
- Sample Data and Fictitious Database
Corner Examples
- Corner Examples
- Audit software
- Track Traffic
- Find users
- Inventory management
- Monitor Servers
- More things you can do with GoToAssist
FAQs
- GoToAssist Monitoring FAQs
- WMI Errors and Solutions
Glossary
- Glossary

GoToAssist Query Language (PQL) Overview

The GoToAssist Query Language (PQL) is a powerful new programming language that was developed especially for requesting information from GoToAssist's dual-database Search Index. PQL is very similar to SQL, and is as human-readable. If you know SQL, PQL will be intuitive to you. You only need a few special characters and symbols to create a PQL query. Unlike SQL, however, PQL was developed especially for requesting information from GoToAssist's tree-structured database.

Structure
Paths
Data types
Case
Comments
Basic statements

Structure

To make it easy to dissect and discuss parts of a query, examples in GoToAssist documentation include capitalized reserved words, and a multiple-line structure. But neither are required. PQL supports queries using equivalent structures, such as /FROM[WHERE](SELECT), and both formats shown here:

SELECT *
FROM /network/device/interface
WHERE mac_address = '01:01:02:03:04:05'

select * from /network/device/interface where mac_address = '01:01:02:03:04:05'

Paths

PQL recognizes a path as a location of a node in the tree-structured database. Paths list the root node first, if applicable, then additional nodes from the top down, and separate each node with a slash. See Paths for more details about how paths function in PQL. See Ontology for more details about how paths are structured in the GoToAssist database.

Data types

PQL recognizes the following expressions and data types:

Case-Insensitive

GoToAssist and PQL are not case-sensitive, with the following exception: Strings are case-sensitive, and will not work if written with the wrong case. Use the upper workaround if you are not sure which case a string should be, such as:

WHERE upper (mac_address) = upper ('00:0a:0b:0c:0d')

Note: Reserved words are not case-sensitive and can be written in both upper and lower case, but not mixed case. You must write the entire reserved word in the same case. So Select or sELEct will fail, but both SELECT and select will succeed.

Comments

PQL recognizes the following ways to insert comments in code:

--		Use double-dashes to comment out a single line.
//		Use double-slashes to comment out a single line.
/*		Use slash-star to comment out multiple lines, and end with */ notation.

Basic Statements

PQL supports the following basic action statements: