question

MoonHeonYoung avatar image
MoonHeonYoung asked

How to query log?

1.There is a custom event name as above. Is there a way to search only a specific part of the event name through the "Event Name" search?

(Ex: To search for the SlotOpen event, is it possible to search after entering only the "Slot"?)

Because, we are going to create events such as SlotOpen1, SlotOpen2, and SlotOpen3.

So When searching only by typing "Slot", it would be nice if results show with all "Slot"-started name.

Is it possible?

2. I want to search the Log property of player_executed_cloudscript.

The log is as follows: Log: ["message": xxx].

How do I search for a key like "message" in the screenshot?

custom.png (27.6 KiB)
howto.png (45.0 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Citrus Yan avatar image
Citrus Yan answered

For your scenario, it’s suggested that you use the Data Explorer advanced mode, where you can do more complex queries using the powerful Azure Data Explorer query language (Kusto), please navigate to the link to get more details.

For use case 1, the following statement queries all events starts with “Slot”:

['events.all']
|where FullName_Name startswith "Slot"

And, for use case 2, you can use the following statement to list all messages from the “Logs” property:

['events.all']
|where FullName_Name == "player_executed_cloudscript" 
|project Logs = EventData["CloudScriptExecutionResult"]["Logs"]
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.