Admin: Corporate Admin
Page: Administration > Log Analytics
URL: [CLIENTID].corpadmin.directscale.com/Corporate/Admin/LogAnalytics
Permission: ViewAdministration()

Important: Only those familiar with Azure Data Explorer and the Kusto query language should use this tool.

The Log Analytics page gives you a glimpse into activities performed by the system and its users. The system logs all events and updates in Azure Data Explorer. Those familiar with Azure logging can write Kusto queries to view these logs.

For more information, see Microsoft’s documentation:

• Overview of Kusto Query Language
• Tabular Operators Reference
• Kusto Query Best Practices
• Tutorial: Using Kusto Queries

Adding a Query

1. Click the Enter Query button.

   

   The Enter Query pop-up window opens.

   

2. In the pop-up, complete the filters:

   • Log Type - Options are Disco or Public API.
   • Time Frame - From the last 30 minutes up to 7 days.
   • Result Limit - Select the allowed number of records from 10-1000.

3. In the Query box, enter your query using Kusto syntax. Click the icon to view an Overview of Kusto Query Language.

4. Click Run Query.

The page will fetch the results; this could take a bit of time, depending on the size of the query. Once retrieved, the results will display as a table on the page. Many of the results may appear off-screen; scroll your page horizontally to view all.

To show/hide columns:

1. Click the Select Columns button.
2. Select the checkboxes for the columns you want to see.

Columns List

| where <column_name> == 'value'

Common Columns

• Client_s
• Environment_s
• IPAddress
• LoggingLevel_s
  • 'Critical'
  • 'Error'
  • 'Information'
  • 'None'
  • 'Warning'
• MessageCategory_s
• MessageText_s
• MessageType_s
• Method_s
• ResponseBody_s
• StackTrace_s
• StatusCode_d
• StatusReason_s
• TimeGenerated
• Url_s

Additional Columns

• Computer
• ContainerType_s
• ContextObject_s
• ContextType_s
• Database_s
• Exception_Message_s
• Exception_StackTrace_s
• Exception_Type_s
• InnerException_s
• InnerExceptions_s
• IsClientConntected_b
• LogId_s
• LogName_s
• MG
• ManagmentGroupName
• MessageDateUtc_t
• Message
• MetricTime_d
• Metric_s
• RequestBody_s
• RequestContentLength_d
• RequestContentType_s
• RequestId_g
• RequrestId_s
• ResourceGroup
• ResponseContentLength_d
• ResponseContentType_s
• Revision_s
• Server_s
• ServiceTime_d
• SourceSystem
• StateObject_s
• StateType_s
• TenantId
• Type_s
• Type
• UnHandledException_s
• _ResourceId