Forum Discussion

pikkuhanuristi's avatar
pikkuhanuristi
Copper Contributor
Feb 28, 2020

APIM ApiManagementGatewayLogs

Hi!

 

I have published couple of APIs through APIM. Now I try to read some diagnostic logs. While I choose APIM -> Logs -> API Management services -> ApiManagementGatewayLogs -> preview data 

 

or fire query:

 

ApiManagementGatewayLogs
| where TimeGenerated > ago(24h)
| limit 10
 
I got
 
'where' operator: Failed to resolve table or column expression named 'ApiManagementGatewayLogs' If issue persists, please open a support ticket.
 
What I'm doing wrong?
 
Thanks, Jani
 
Azure Log Analytics
azure monitor
  • CliveWatson's avatar
    CliveWatson
    Icon for Microsoft rankMicrosoft
    Feb 28, 2020

    pikkuhanuristi

     

    That error indicates the table hasn't been created, yet.

     

    1. You need to wait a few hours and APIM has to send some data for it to create a Table 

    2. Are you using the same workspace as you configured in the Diagnostic logging?

  • ameersuhail999's avatar
    ameersuhail999
    Copper Contributor
    Jul 04, 2024
    I have the same issue - its been weeks but still i am getting error ""'where' operator: Failed to resolve table or column expression named 'ApiManagementGatewayLogs'""
  • shailesh14's avatar
    shailesh14
    Icon for Microsoft rankMicrosoft
    Nov 12, 2024

    I can relate if under APIM which mode of resource log you selected. If logs are not written to ApiManagementGatewayLogs then check if you have selected Azure diagnostics. Possible the data written to AzureDignostics table.

    You can integrate App Insights where logs will be there under request table. In case of APIM is using VNET mode make sure that no network dependency error under your APIM networking blade.

Resources