Nov 30 2018
06:14 PM
- last edited on
Apr 07 2022
05:33 PM
by
TechCommunityAP
Nov 30 2018
06:14 PM
- last edited on
Apr 07 2022
05:33 PM
by
TechCommunityAP
Is there any list of reserved key words like 'computer' which we cannot use within our queries?
For instance, when i try to run a query like:
<TABLE> | where Name contains 'computer'
I get the following error.
'Detected multiple functions with the same name: 'computer'. Resolve the conflict to allow these functions to be used in a query.'
Nov 30 2018 07:43 PM
Without having the Table I can’t reproduce the issue. A couple things stand out on your query however, “Name” would be the name of the column or field and “computer” would be the value searched for in the column. I have not seen a column named “Name” before.
If I run a similar query below on https://portal.loganalytics.io/demo it will pull back all the rows with *data* in the Computer column
Heartbeat | where Computer contains "data"
I changed that from “data” to “computer” and I don’t get the same error you are seeing. No results are returned because the field doesn’t contain values *computer*, but no error
Heartbeat | where Computer contains "computer"
To answer your question, I don’t believe there are any keywords that can’t be used in queries. Possibly if there are Let Statements involved, but not for the value being searched.
Nov 30 2018 08:23 PM
Intersting.. I tried the same query on https://portal.loganalytics.io/demo and it worked the way you described. But when i try to run this against my Log Analytics workspace it yields this error.
(Attached the screenshot for the error)
May be this is related to the workspace and nothing to do with the query language.
Dec 02 2018 10:24 PM
SolutionThis is probably an error specific to your workspace. I would assume that you somehow have some functions created that have the same alias or something. Check what kind of functions you have created.
Dec 02 2018 10:24 PM
SolutionThis is probably an error specific to your workspace. I would assume that you somehow have some functions created that have the same alias or something. Check what kind of functions you have created.