Skip to main content
USM Anywhere supports queries written in Structured Query Language (SQL). For syntax guidance, refer to the following:

Supported SQL clauses

The following SQL clauses are supported in custom queries:
  • SELECT (required)
  • FROM (required)
  • WHERE
  • GROUP BY
  • ORDER BY
  • LIMIT
  • Wildcard (*)

Unsupported SQL clauses

The following SQL features are not supported:
  • JOINS statements
  • Nested SELECTS statements

SQL query example