Forum Discussion

MarkSteben's avatar
MarkSteben
Copper Contributor
Jun 15, 2020

azure portal logging - no results found

Hello - I am trying to access the azure logging facility for my servers for the first time.  Within the database I wish to post logs to and read logs from I have set up 'diagnostic settings'. Within ...
Azure Log Analytics
azure monitor
MarkSteben's avatar
MarkSteben
Copper Contributor

JK_UK When I run this query I do get records - 2,763 to be exact.

Here is the first row.  madevsql01 is the actual server name. adscheduler is the database name on this particular record. Many different categories, including DatabaseWaitStatistics, QueryStoreRuntimeStatistics to name two.

6/18/2020, 9:58:09.753 AM/SUBSCRIPTIONS/E1F843CE-5BAC-42BD-B3C2-A9EA02672DAB/RESOURCEGROUPS/OTTOBASE-CAMPAIGNS/PROVIDERS/MICROSOFT.SQL/SERVERS/MADEVSQL01/DATABASES/ADSCHEDULERDatabaseWaitStatisticsOTTOBASE-CAMPAIGNSe1f843ce-5bac-42bd-b3c2-a9ea02672dabMICROSOFT.SQLADSCHEDULERSERVERS/DATABASESDatabaseWaitStatistcsEventmadevsql01 AdScheduler
JK_UK's avatar
JK_UK
Brass Contributor
Jun 18, 2020

MarkSteben ok, so your resource(s) are sending logs to the AzureDiagnostics table on Log analytics.

What else are you expecting to see ?

  • MarkSteben's avatar
    MarkSteben
    Copper Contributor
    Jun 18, 2020

    JK_UK I was trying to access error data through the sample queries in the logs facility within the particular database I am querying. But with your help I now know I can get that error data directly by querying the log analytics workspace specifically the Errors Category.  Don't yet know why I can't get that through the database/logs facility but now at least I can get the data I was looking for.  Thank you for your help.  

Resources