User Profile
Rahul_Mahajan
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
WVD Integration with Log Analytics
Hi All, Can you please help with steps to configure WVD logs with log analytics. We have existing log analytics and monitoring enabled in WVD VMs but unable to get table WVDActivityV1_CL or any other table related to WVD query in log analytics. Thanks in Advance.Solved3.8KViews0likes6CommentsVM details query
Hi Team, Trying to query VM details using KQL but unable to include different thing in query. VMComputer | where _ResourceId != "" | summarize by TimeGenerated, HostName, AzureImageSku, AzureResourceGroup, AzureLocation, AzureSize, Cpus, DependencyAgentVersion, PhysicalMemoryMB, OperatingSystemFamily, OperatingSystemFullName, VirtualMachineType, VirtualizationState Unable to include IPaddress details in it which can be seen using : | project Computer, Ipv4Addresses, Ipv4DefaultGateways, Ipv4SubnetMasks, MacAddresses Also, it doesn't have a state of VM like Running or Stopped Can someone help to include them in one query? Thanks in advance.Solved12KViews0likes11CommentsVM with Public IP
Hi All, Can someone help me with query to get list of VM names and public IP address assigned to them. Also how to create view in dashboard for the same as I dont have permission to modify or share existing shared dashboards, hence need the output in my private dashboard. thanks in advanceSolved6KViews0likes8CommentsMonitor Azure Resource Only
Hi All, I am using Azure LA for VM performance monitoring but it include on-prem servers also. When we run CPU or memory or disk utilization alerts it include all the servers in Azure and on-prem. Here we want to monitor only Azure resources only not on-prem, how to achieve that? Queries : CPU Perf | where CounterName == "% Processor Time" and CounterValue > 95 and ObjectName == "Processor" and InstanceName == "_Total" | summarize arg_max(TimeGenerated, CounterValue) by Computer, CounterName Memory Perf | where ObjectName == "Memory" and CounterName == "% Committed Bytes In Use" | where CounterValue > 80 | summarize (TimeGenerated, Free_Memory_Percent)=arg_max(TimeGenerated, CounterValue) by Computer Disk Perf | where ObjectName == "LogicalDisk" and CounterName == "% Free Space" | where CounterValue < 10 | summarize (TimeGenerated, Free_Space_Percent)=arg_max(TimeGenerated, CounterValue) by Computer, InstanceName | where InstanceName contains ":" Thanks in advance.Solved2KViews0likes6CommentsHow to monitor windows services
Hi All, How to monitor services in Azure VMs like IIS, MSSQL or any other Windows service. Here we already have integration with service-now and want to achieve if Windows service is down we will get alert and then once service is online it will resolve the alert or it will not regenerate alert at frequency. Thanks in advance.Solved36KViews0likes14CommentsRe: VM details query
@Clive Watson Will try it 🙂 For now, I have changed the query like : VMComputer | where isnotempty(_ResourceId) | join kind= innerunique ( Perf | where TimeGenerated > now(-10min) and CounterName == "% Free Space" and InstanceName !contains "DPM" | where strlen(InstanceName) ==2 and InstanceName contains ":" | summarize FreeDiskSpace = (avg(CounterValue)) by bin(TimeGenerated, 1h), InstanceName,Computer ) on Computer | summarize by TimeGenerated, Computer, AzureImageSku, AzureResourceGroup, AzureLocation, AzureSize, Cpus, DependencyAgentVersion, PhysicalMemoryMB, OperatingSystemFamily, OperatingSystemFullName, VirtualMachineType, VirtualizationState, tostring(Ipv4Addresses), tostring(Ipv4DefaultGateways), tostring(Ipv4SubnetMasks), tostring(MacAddresses), InstanceName, FreeDiskSpace Here there are multiple records are showing as different drives for same server.12KViews0likes4CommentsRe: VM details query
CliveWatson regarding VM state its seems difficult to get the state of VMs with output what we are getting using VMComputer | where TimeGenerated > ago(1d) | where _ResourceId != "" | summarize by TimeGenerated, HostName, AzureImageSku, AzureResourceGroup, AzureLocation, AzureSize, Cpus, DependencyAgentVersion, PhysicalMemoryMB, OperatingSystemFamily, OperatingSystemFullName, VirtualMachineType, VirtualizationState, tostring(Ipv4Addresses), tostring(Ipv4DefaultGateways), tostring(Ipv4SubnetMasks), tostring(MacAddresses) Like I want to get VM status in front of the above query output as Running or Stopped (Deallocated) or Stopped. If not possible, can you help to integrate below query details for disk space with VMComputer output Perf | where TimeGenerated > now(-10min) and CounterName == "% Free Space" and InstanceName !contains "DPM" | where strlen(InstanceName) ==2 and InstanceName contains ":" | summarize FreeDiskSpace = (avg(CounterValue)) by bin(TimeGenerated, 1h), Computer, InstanceName | sort by TimeGenerated, Computer desc;12KViews0likes7CommentsRe: VM with Public IP
Stanislav_Zhelyazkov Yes, exactly that's what I am looking for. CliveWatson and Noa Kuperberg Also when I am trying to create visual using query all things pointing to Visual Designer but I am not able to find in Azure portal, seems to be depreciated. Do we have any alternative for it? I am trying to create something like : https://adinermie.com/using-azure-backup-logs-azure-log-analytics-aka-oms/5.8KViews0likes6CommentsRe: How to monitor windows services
When I am trying to change - change tracking frequency to 10 seconds its not working. it says task completed successfully but again it revert back to 30 seconds. Can someone confirm which level of access is required to do this task and also how to easily identify in future which level of access is required for other tasks in Azure monitoring and Update management.35KViews0likes1Comment
Recent Blog Articles
No content to show