I am creating a workbook in Azure where i am using KQL query and i have to dynamically pass resource groups values in the query from parameter. From Parameter, resourcegroups are coming like {ResourceGroups:label} ==> rg-abc-prod-westus, rg-xyz-ttt-westus . There is…
We have both Log Analytics Workspace and Application Insights to monitor our applications. I have created alert rules in Log Analytics to detect certain conditions with custom payload (e.g., failed requests). When these alerts are triggered, I want to dynamically…
I am required to search for a specific query, which is stored in a Sentinel workbook Initially, I opened each workbook manually, clicked on edit and expanded all graphs to view the associated query. However, this process is time-consuming, particularly…
I have a question regarding the AVD Insights. Does anyone else currently have issues with the "Host Performance" blade showing "the query returned no results" for all the insights? I have this issue currently in multiple of my tenants but…
I have table (data) SWFLogOSot_CL and I'm trying to see count of two columns: values_in_use_connections_d values_available_connection_d I've done this: union withsource="SWFLogOSot_CL" * | summarize AvaibleConn = count() by ColumnName="values_available_connection_d" This works, but shows count of just one column: Does please…
I am trying to create an Azure Monitor Workbook "step" to create a stacked100 graph. This is easily achieved in Azure App Insights, but the same query refuses to render as a 100% graph and just gives a standard column…
I am trying to put a dashboard together from Azure Monitor Workbooks and I am having issues with trying to use a Time Range and Time "binning". Here's the current query. Note, in the query below, there is a {time}…
I have this query to check the application version AppInventory_CL | extend AppVersion_s_Dyn = split(AppVersion_s, '.') | extend Versione = iif(toint(AppVersion_s_Dyn[0]) >= 5 and toint(AppVersion_s_Dyn[1]) >= 2 and toint(AppVersion_s_Dyn[2]) >= 7, 'OK', 'KO') But I need that also superior versions…
i am running a query on azure workbook that gives costs for on-demand and spot instances month to date within a number of resource groups. i want to have this data shown in bar chart as well where it could…
How can I have conditional parameter value in Azure Workbook? I want to have one parameter called environment. It has some text values. E.g. it has two values test and production. Also, I want to have two other parameters: subscription…