Overview

This topic describes the query and analysis syntax used during security analysis. SecMaster supports SQL and SecMaster SQL retrieval syntax. Query and analysis statements are used in the area shown in the following screenshot on the SecMaster console.

Figure 1 Entering a query and analysis statement

Select the query and analysis syntax as required.

• Retrieval SQL syntax reference: An SQL statement consists of a query statement and an analysis statement. They are separated by a vertical bar (|). Query statements can be used independently, but analysis statements must be used together with query statements.
• SecMaster SQL syntax reference: The SecMaster SQL syntax supports the following data types: STRING, BOOLEAN, BYTES, DECIMAL, TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DATE, TIME, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL, ARRAY, MULTISET, MAP and ROW.