CODEWITHSUNDEEP
databaseazureazure-data-explorerazure-log-analytics
user13277165
user13277165

Reputation: 3

Kusto query could not be parsed at 'sys'

While executing this query on the log analytics tool of the azure database

SELECT * FROM sys.event_log

Got the error as

Query could not be parsed at 'sys' on line [1,14]

Token: sys Line: 1 Position: 14

Upvotes: 0

Views: 567

Answers (1)

Avnera
Avnera

Reputation: 7608

Azure Data Explorer support SQL however you need to escape it like this:

select * from [sys.event_log]

Azure Log Analytics does not support the SQL language and you have to use the "Kusto Query Language". You first need to find the table that has the data you are looking for and then use the "Kusto Query Language" to find the relevant data. There are many sample queries when you begin to use Azure Log Analytics.

Upvotes: 1

Related Questions