Abfragen für die Tabelle "AgriFoodFarmManagementLogs"
Informationen zur Verwendung dieser Abfragen im Azure-Portal finden Sie im Log Analytics-Lernprogramm. Informationen zur REST-API finden Sie unter "Abfrage".
Status der Betriebsführungsvorgänge für einen Landwirt
Ruft Protokolle ab, die den Status (Erfolg oder Fehler) für Vorgänge angeben, die in der FarmManagement-Protokollkategorie für einen Landwirt ausgeführt werden.
AgriFoodFarmManagementLogs
| summarize Count = count() by OperationName, ResultSignature
Status aller Tätigkeiten für einen Landwirt
Aggregiert Fehler und Erfolge über Kategorien hinweg für einen Landwirt.
((AgriFoodFarmManagementLogs | where FarmerId != "" | summarize AgriFoodFarmManagementLogsCount=count() by FarmerId, ResultType))
| join kind=fullouter (( AgriFoodSatelliteLogs | where FarmerId != "" | summarize AgriFoodSatelliteLogsCount=count() by FarmerId, ResultType)) on FarmerId, ResultType
| join kind=fullouter (( AgriFoodWeatherLogs | where FarmerId != "" | summarize AgriFoodWeatherLogsCount=count() by FarmerId, ResultType)) on FarmerId, ResultType
| join kind=fullouter (( AgriFoodJobProcessedLogs | where FarmerId != "" | summarize AgriFoodJobProcessedLogsCount=count() by FarmerId, ResultType)) on FarmerId, ResultType
| join kind=fullouter (( AgriFoodFarmOperationLogs | where FarmerId != "" | summarize AgriFoodFarmOperationLogsCount=count() by FarmerId, ResultType)) on FarmerId, ResultType
| join kind=fullouter (( AgriFoodInsightLogs | where FarmerId != "" | summarize AgriFoodInsightLogsCount=count() by FarmerId, ResultType)) on FarmerId, ResultType
| join kind=fullouter (( AgriFoodProviderAuthLogs | where FarmerId != "" | summarize AgriFoodProviderAuthLogsCount=count() by FarmerId, ResultType)) on FarmerId, ResultType
| join kind=fullouter (( AgriFoodModelInferenceLogs | where FarmerId != "" | summarize AgriFoodModelInferenceLogsCount=count() by FarmerId, ResultType)) on FarmerId, ResultType
| project FarmerId = coalesce(FarmerId, FarmerId1, FarmerId2, FarmerId3, FarmerId4, FarmerId5, FarmerId6, FarmerId7), AgriFoodFarmManagementLogsCount, AgriFoodSatelliteLogsCount, AgriFoodWeatherLogsCount, AgriFoodJobProcessedLogsCount, AgriFoodFarmOperationLogsCount, AgriFoodInsightLogsCount, AgriFoodProviderAuthLogsCount, AgriFoodModelInferenceLogsCount, ResultType = coalesce(ResultType, ResultType1, ResultType2, ResultType3, ResultType4, ResultType5, ResultType6, ResultType7)
Nutzungstrend für top 100 Landwirte basierend auf den durchgeführten Vorgängen
Ruft eine Liste der top 100 Landwirte basierend auf der Anzahl der Treffer, die in kategorienübergreifend empfangen wurden.
((AgriFoodFarmManagementLogs | where FarmerId != "" | summarize AgriFoodFarmManagementLogsCount=count() by FarmerId))
| join kind=fullouter (( AgriFoodSatelliteLogs | where FarmerId != "" | summarize AgriFoodSatelliteLogsCount=count() by FarmerId)) on FarmerId
| join kind=fullouter (( AgriFoodWeatherLogs | where FarmerId != "" | summarize AgriFoodWeatherLogsCount=count() by FarmerId)) on FarmerId
| join kind=fullouter (( AgriFoodJobProcessedLogs | where FarmerId != "" | summarize AgriFoodJobProcessedLogsCount=count() by FarmerId)) on FarmerId
| join kind=fullouter (( AgriFoodFarmOperationLogs | where FarmerId != "" | summarize AgriFoodFarmOperationLogsCount=count() by FarmerId)) on FarmerId
| join kind=fullouter (( AgriFoodInsightLogs | where FarmerId != "" | summarize AgriFoodInsightLogsCount=count() by FarmerId)) on FarmerId
| join kind=fullouter (( AgriFoodProviderAuthLogs | where FarmerId != "" | summarize AgriFoodProviderAuthLogsCount=count() by FarmerId)) on FarmerId
| join kind=fullouter (( AgriFoodModelInferenceLogs | where FarmerId != "" | summarize AgriFoodModelInferenceLogsCount=count() by FarmerId)) on FarmerId
| project FarmerId = coalesce(FarmerId, FarmerId1, FarmerId2, FarmerId3, FarmerId4, FarmerId5, FarmerId6, FarmerId7), AgriFoodFarmManagementLogsCount, AgriFoodSatelliteLogsCount, AgriFoodWeatherLogsCount, AgriFoodJobProcessedLogsCount, AgriFoodFarmOperationLogsCount, AgriFoodInsightLogsCount, AgriFoodProviderAuthLogsCount, AgriFoodModelInferenceLogsCount
| take 100