view designer
11 TopicsGroup similar Process name in LogsAnalytics
Hi, I am looking for a query where I can get % Process CPU for specific Process. My main concern is that I would like to group some of them. For instance: "ZSAService", "ZSATunnel" and "ZSATray" sould all been group under ZScaler My current query : Perf | where Computer contains "sl2" | where ObjectName == "Process" and CounterName == "% Processor Time" | where (InstanceName contains "Sysmon" or InstanceName contains "CSFalconSer" or InstanceName contains "ZSA" ) | summarize avg(CounterValue) by InstanceName, bin(TimeGenerated, 1d) | render timechart title = "% CPU SECURITE" and the current result:Solved1.7KViews0likes2CommentsBarchart ignoring one data series
The following query Heartbeat | where TimeGenerated >= startofday(ago(2d)) | where Computer == "ADMIN-PC" or Computer == "SERVER-PC" | summarize dcount(Computer) by t = endofday(TimeGenerated) , Computer | sort by t, Computer | render barchart kind=default produces the following table of 6 record in two sets: I'd expect to see a barchart with two series, but the result only shows one: The behavour is consistent. When I chose three series only two will be displayed. Do I miss anything? Regards Jörg2.5KViews0likes7CommentsLog Analytic Dashboard Diagram(Lines) disk space
Hi all I got this query that shows me Used disk space in % for every disk in the vm. Now i want to collect all the information in a Dashboard design that will show me a Diagram(Lines) for a whole day what changes been made and when in a past day. This is the query i got for now working, but i got only a list in my dashboard. ******************************************************************************************************* Perf | where TimeGenerated > ago(1h) | where ObjectName == "Logical Disk" and CounterName == "% Used Space" | summarize (TimeGenerated, Used_Space_Percent)=arg_max(TimeGenerated, CounterValue) by Computer, InstanceName *******************************************************************************************************Solved6.3KViews0likes2CommentsComputers Bound to a Domain inside Log Analytics?
Hello everyone. Running into a bit of trouble here. Was hoping someone could help me out. Currently creating a cloud environment for my small cloud network. For compliance purposes, I need to run a Query against a VM to verify it is domain bound. I wish for any computers not domain bound will populate accordingly. I thought about using the event logs. However, that doesn't seem to be a liable way to view this. Anyone have any ideas on a direction where to go?Solved1.8KViews0likes2CommentsAzure monitoring
Hello! First and foremost, I'm new to Azure and Azure monitoring. That's why I'm starting this conversation. I'm currently trying to migrate our SolarWinds monitor into the Azure monitoring portal, but I'm unable to carry on because my knowledge about queries is absolutely minimum. I would like some assistance when it comes to queries, does anybody for instance know a query to monitor the CPU load on different computers and/or servers? And which tile in the designer should I use for this query? I hope some of you can help me out 🙂 Kind regards, Rik3.2KViews0likes7CommentsDashboard performance issues and Creating a dashboard with dynamic target source dropdown list
Hi, Two issues that I am dealing with application insights: 1. Dashboard performance - It takes a long time to load all the charts even when the queries are very simple. for example a simple query like: let ids = customMetrics | where name == 'my_metric_name' | project customDimensions.id; customMetrics | where name == 'another_metric_name' and customDimensions.id in (ids) without much data loaded, can take about 30 seconds. Maybe I am doing something wrong? is there maybe a way to index my customDimensions properties? 2. Dynamic target resource - I have many target resources with the same metrics data structures, and I want to create one dashboard with many charts, that will be updated automatically by the given target resource - that can be changed from something like a drop down list with all the target resources. Right now I have the same dashboard for each target resource. Thanks in advance, Elad.1.5KViews0likes1CommentLog Analytics Dashboard Options
I am interested in understanding OMS dashboarding options. My understanding is as follows... Within a single OMS workspace, I can only build and maintain one overview tile based dashboard (the overall dashboard you see when you first log in). "My dashboard" is deprecated, meaning there is no concept of a personal dashboard within OMS. Also, whomever has access to the OMS workspace sees everything that is on that overall dashboard (i.e., there is no way to hide certain tiles based on user or role). For more customized dashboarding needs, we would need to either integrate with other tools (i.e., Power BI) or pin OMS query results to an Azure Portal dashboard and share those with whomever else needed those. One main constraint of pinning to Azure portal is that tabular views are limited to only four columns of data, no more. Are these statements valid. If not, could someone point me to some documentation showing otherwise please? I am particular interested on the best options for creating customized dashboards that only specific teams/users have access to. Thanks in advance!Solved6.9KViews0likes6CommentsDashboard two columns
Hi, i'm trying to create a dashboard with a list that gets its data from a Join query, but I can't find any way to add a column to the List on the dashboard, since I need 3 columns; One for the computer name, one for CPU and one for RAM is there any way?2.4KViews0likes3Comments