Table of contents
-
Log Parser
- What's New in Log Parser 2.2
- Conceptual Overview
- Writing a Query
- Advanced Features
- Log Parser COM API Overview
- Security Considerations
- Frequently Asked Questions
-
Reference
-
Query Syntax
- SELECT
- USING
- INTO
- FROM
- WHERE
- GROUP BY
- HAVING
- ORDER BY
- Expressions
- Field-Expressions
- Field Names and Aliases
- Aggregate Functions
-
Functions
- ADD
- BIT_AND
- BIT_NOT
- BIT_OR
- BIT_SHL
- BIT_SHR
- BIT_XOR
- CASE
- COALESCE
- COMPUTER_NAME
- DIV
- EXP
- EXP10
- EXTRACT_EXTENSION
- EXTRACT_FILENAME
- EXTRACT_PATH
- EXTRACT_PREFIX
- EXTRACT_SUFFIX
- EXTRACT_TOKEN
- EXTRACT_VALUE
- FLOOR
- HASHMD5_FILE
- HASHSEQ
- HEX_TO_ASC
- HEX_TO_HEX16
- HEX_TO_HEX32
- HEX_TO_HEX8
- HEX_TO_INT
- HEX_TO_PRINT
- INDEX_OF
- INT_TO_IPV4
- IN_ROW_NUMBER
- IPV4_TO_INT
- LAST_INDEX_OF
- LOG
- LOG10
- LTRIM
- MOD
- MUL
- OUT_ROW_NUMBER
- QNTFLOOR_TO_DIGIT
- QNTROUND_TO_DIGIT
- QUANTIZE
- REPLACE_CHR
- REPLACE_IF_NOT_NULL
- REPLACE_STR
- RESOLVE_SID
- REVERSEDNS
- ROT13
- ROUND
- RTRIM
- SEQUENCE
- SQR
- SQRROOT
- STRCAT
- STRCNT
- STRLEN
- STRREPEAT
- STRREV
- SUB
- SUBSTR
- SYSTEM_DATE
- SYSTEM_TIME
- SYSTEM_TIMESTAMP
- SYSTEM_UTCOFFSET
- TO_DATE
- TO_HEX
- TO_INT
- TO_LOCALTIME
- TO_LOWERCASE
- TO_REAL
- TO_STRING
- TO_TIME
- TO_TIMESTAMP
- TO_UPPERCASE
- TO_UTCTIME
- TRIM
- URLESCAPE
- URLUNESCAPE
- WIN32_ERROR_DESCRIPTION
- Constant Values
- Comments
- Data Types
- Input Formats
- Output Formats
- Command-Line Operation
- COM API
- COM Input Format Plugins
-
Query Syntax