Log Analytics
58 TopicsCan I use regex in a DCR custom text logfile filepath?
Hi, I have about 50 servers attached to a DCR to collect a custom text log into a log analytics workspace custom table. Is it possible or if anyone has experience with using a regex filepath in the DCR situation? The logs are in the same format but paths differs slightly on each servers. There are two structures, but includes the servernames so we have 50 different filepaths: App Server c:\appserver\logs\<server Fully Qualified Name>\server\*.log App Portal c:\appportal\logs\<server Fully Qualified Name>\portal\*.log When I use static paths it works (there's a limit of 20 by the way). I have tried using the following regex filepath nothing comes in: c:\app(server|portal)\logs\SYS[a-zA-Z0-9]{4}wm[0-9]{2}.domain.net\(server|portal)\*.log Can someone confirm with me whether I can use regex in the filepath pattern in the DCR Data Source Tex log setup? If so, how do I get it to work please? Am I missing some escapes somewhere please? Many thanks in advance.28Views0likes1CommentSNMP Polling of Network Devices Using Azure Platform
Hi All, I am looking for SNMP polling capability in Azure platform so that will do network device fault monitoring. Currently using third party application for fault monitoring. Any suggestions would be highly appreciable. Alerts which we monitor currently using third party application are like threshold utilization, high error rate, device down/unresponsive, BGP session etc. There is no option i found in azure monitor for SNMP polling. Thanks, Neeraj Mohan2.6KViews0likes3CommentsHo w to correctly measure Bytes Received/sec &&&&& Bytes Sent/sec
I would like to correctly measure through log analytic and then in Grafana network traffic generated for one or more VMs. For test VMs I have enable Data collection rule and enabled collecting data every 60s for network Interface "Bytes Received/sec" and "Bytes Sent/sec". Inside metric is also enabled. Query that I use in log analytic is : Perf | where TimeGenerated between (datetime(2024-03-19) .. datetime(2024-03-20)) | where Computer == "***********" | where ObjectName == "Network Interface" and CounterName == "Bytes Received/sec" and InstanceName == "Microsoft Hyper-V Network Adapter _2" | summarize BytsSent = sum(CounterValue)/1073741824 by bin(TimeGenerated, 24h),CounterName InsightsMetrics | where TimeGenerated between (datetime(2024-03-19) .. datetime(2024-03-20)) | where Origin == "vm.azm.ms" | where Namespace == "Network" and Name == "ReadBytesPerSecond" | where Computer == "******" | extend NetworkInterface=tostring(todynamic(Tags)["vm.azm.ms/networkDeviceId"]) | summarize AggregatedValue = sum(Val) by bin(TimeGenerated, 1d), Computer, _ResourceId, NetworkInterface Results for Perf is 0,32339 GB/day and for InsightsMetrics is 14.7931 GB/day. If I go to network interface and select metric data for network interface is data that I get return from query in log analytic for Metric same/correct . I have now shorten sample period of data collection rule to 15s, I hope that this will ,give more accurate results. I’m I doing something wrong or I collect data the wrong way. I don’t want to activate inside metric for every VM, I want to activate any data that I’m interesting.305Views0likes0CommentsIngested GB per month Query
Hi all. I am trying to create a kql query to get the AVG of the ingested GBs per month (only billable data). This is the query im building up: let currentmonth=monthofyear(now()); let month1=union * | where TimeGenerated > ago(124d) | where _IsBillable == "True" | where monthofyear(_TimeReceived)==currentmonth | summarize TotalGBytes =round(sum(_BilledSize/(1024*1024*1024)),2) by bin (TimeGenerated, 1d) | summarize avg(TotalGBytes) by month; let month2=union * | where TimeGenerated > ago(124d) | where _IsBillable == "True" | where monthofyear(_TimeReceived)==currentmonth-1 | summarize TotalGBytes =round(sum(_BilledSize/(1024*1024*1024)),2) by bin (TimeGenerated, 1d) | summarize avg(TotalGBytes) by month; let month3=union * | where TimeGenerated > ago(124d) | where _IsBillable == "True" | where monthofyear(_TimeReceived)==currentmonth-2 | summarize TotalGBytes =round(sum(_BilledSize/(1024*1024*1024)),2) by bin (TimeGenerated, 1d) | summarize avg(TotalGBytes) by month; month1 | union month2, month3 but getting "'summarize' operator: Failed to resolve scalar expression named 'month'" every time i run the query. Any idea how to solve this situation or any suggestion about how can i get the date i need? thanks in advanceSolved3.8KViews0likes4CommentsHow to redirect performance logs to another Azure log analytic workspace
Dear members, I am new to Azure monitor/log analytic workspace and I'm in the process of configuring it. Initially, we believed that having two LAWs would suffice for our business requirements, and we put significant effort into adjusting Azure Policies exclusions to make it work. However, we didn't succeed in that approach. After gaining a deeper understanding of LAW, we decided to using a single LAW and have most of our resources report to it. To achieve this, we cleaned up Azure policies and direct DCRs to point to this unified LAW. The issue we currently face is that the specific group of VMs continues to send performance data to the outdated LAW, and we can't identify where to make the necessary changes. We have triple checked all levels of management groups of Azure policies or the remaining active DCRs yet still no luck. All of these VMs have the AMA installed. Is there a need to update the AMA, which we may be unaware of? We are running out of ideas on where to adjust the settings so that we can consolidate all the logs into this single LAW. We would greatly appreciate any suggestions or recommendations from forum members! Thank you in advance for any help! Sally901Views0likes2CommentsAzure resource Graph integration
Are there any plans to integrate Azure Resource Graph with Log Analytics? Once the integration is available it will be super easy to setup alerts based on resource meta data and monitor data. Since both using Kusto language, it should be easy to cross workspace kind of query I guess.Solved12KViews4likes12CommentsBest practice for monitoring Azure VMs using Monitor
Hey members, I am curious to know what approach are you guys following related to setting up alerts on Azure Monitor for Compute in particular. Like once the VMs are connected via DCR to LAW, is it advisable to create alert targeting LA workspace or should we choose individual VM to setup alarms? In other words, if the hearbeat/Perf/SysLogs all are ingesting to LAW, then alerts should also be created targeting LAW not individual resource, am I right? What is the best practice to setup alarms? Thank you606Views0likes1CommentQuery for App Service and outbound IP Query
Right now I need help writing a Query that shows this: AzureDiagnostics | where ResourceProvider == "MICROSOFT.CDN" and Category == "FrontDoorAccessLog" clientIp, backendHostname This query isn't working. I have a server that is using SSH and the logs there show stuff but I have a Front Door Globally and I need to see the logs there also. What is the best method.865Views0likes2Comments