User Profile
PatrikHansson
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Get span of TimeGenerated to use in Summarize
Hi I'm trying to figure out at way to make the round to value used in bin() dynamic. so if the Query is for a day I want to have something like: bin(Timegenerated, 1m) but if the query is for 30 days I want to have something like bin(Timegenerated, 1h) Was thinking that I somehow could get the max and min from Timegenerated and then use "case" to set a variable to use in the last | summarize xxxxxx by bin(Timegenerated, "variable") Anyone have some idea on how to do this ?598Views0likes0CommentsAzure Monitor "Upgrade available" doesn't go away
Hi All my VM:s have status "Upgrade Available" and though I select a VM and click upgrade and upgrade is reported as successful the status doesn't go away. Waited a couple of days but status is still "Upgrade available" Anyone else seen this issue ? This upgrade appeared sometime last week I believe.2.4KViews0likes3CommentsFind new metrics
According to this post there should be new metrics available to see if VM:s are hitting iops limit. https://azure.microsoft.com/en-us/updates/new-disk-performance-metrics-in-azure-monitor-to-identify-performance-bottlenecks/ I can't find them anywhere, have anybody seen them ?2.1KViews0likes6CommentsPolicy sets resource to non-compliand but no Events are created
Hi Trying to get a grip on creating policies and initiatives. Have made a simple initiative with one policy that checks for log analytics agent installation: The Log Analytics agent should be installed on virtual machines" It finds 3 test server that I've left without log analytics agent and marks them as non-compliant. Of course I want to monitor this so I started looking in the logs for this. Can't find it anyware. And the events tab under Policy is empty as well. Have I missed something ?Solved951Views1like2CommentsKQL to only get values during office hours
Hi, im trying to get insightdata for office hours only. all examples i find is for one day only but I want to have a graph for a week but only 6am to 16pm. Can't figure it out. Anyone that can help. InsightsMetrics | where Computer contains "servername" | where Name == "WriteBytesPerSecond" | where parse_json(Tags).["vm.azm.ms/mountId"] == "F:" | summarize sum(Val) by Computer, bin(TimeGenerated, 24h)Solved5.9KViews0likes2CommentsDebian from Marketplace not supported for Insights
Hi Have two different Debian VM's. One is deployed from Disk and one from Marketplace. I'm having problems enabling Insights on the one from marketplace. It says it's unsupported "While we encourage you to enable insights for Maps, you are using an OS version (Publisher: credativ, Offer: Debian, Sku: 9-backports) that is not supported" Anyone now it there is a workaround to get it supported. It's the same version 9.13 as the one that works.Solved1.6KViews0likes4CommentsLog Analytics visualizations update removes chart
Hi Just got the "Log Analytics visualizations will be updated soon" message on my dashboards diagrams. When updating the charts don't show and instead only a table with the data. Doesn't matter if it is a timechart, piechart or a stacked column. Luckily the change wasn't permanent and could be discarded.Solved1.2KViews3likes2CommentsHealthservice Error 4502
Getting this error on our servers. Can't pinpoint what is wrong. Reason for posting here is that it is healthservice that are reporting the error. A module of type "Microsoft.EnterpriseManagement.Advisor.InventoryChangeTracking.FileChangeTrackingDataSource" reported an exception Newtonsoft.Json.JsonReaderException: JsonToken EndArray is not valid for closing JsonType None. Path '', line 1, position 1. at Microsoft.EnterpriseManagement.Advisor.InventoryChangeTracking.JsonParser.ExtractMetaPropertiesCheckSum(String JsonFile) at Microsoft.EnterpriseManagement.Advisor.InventoryChangeTracking.FileChangeTrackingDataSource.RunASMHostForMetaPropertiesScan(String MofFile, String outputFile) which was running as part of rule "Microsoft.IntelligencePacks.DynamicFileChangeTracking.Upload" running for instance "" with id:"{xxxxxxxxxx-xxxx-xxxxxE-xxxx-xxxxxxxx}" in management group "AOI-xxxxxx-xxxx-xxxxx-xxxxx-xxxxxxxxxxx".Solved17KViews1like7CommentsGetting SQL query performance into log analytics
Hi Is it possible to get query performance from SQL Server (On an Azure VM) into Log analytics ? Would like to be able to see top 10 longest running, most logical reads etc. Can't find a hint on how to be able to do that. Any ideas ?5.6KViews0likes10CommentsMonitoring agent in limbo
Hi I'm having trouble connecting an Azure VM to a new Log Analytics Workspace. It's in error state and i if i try and disconnect it just starts disconnecting but never ends. Extension status for MicrosoftMonitoringAgent is "Unavailable" Tried to uninstall the extension but that fails with "Error" Tried to manually install the agent and but the connection status was still "Error" after giving it the night to get the right status" Anyone got an idea of what to do next?1.4KViews0likes2CommentsWindows Server 2019 not supported for Windows Defender ATP ?
Seeing this on 2019 servers...and found another post about deployment from Azure Security Center to 2019 not working. Is this confirmed as true ? https://social.technet.microsoft.com/Forums/sqlserver/en-US/ef491aef-30d0-4259-be6f-17c38bf1c66d/windows-defender-atp-and-server-2019?forum=WindowsDefenderATPPreview The constructor for the managed module type "Microsoft.EnterpriseManagement.Mom.Modules.WindowsDefenderATPModule.WindowsDefenderATPModule" threw an exception. This module was running in rule "Microsoft.Windows.WindowsDefenderATP.CollectEtwEvent" running for instance "" with id:"{F00EB567-BFDE-5A3D-CB1E-25426C032A51}" in management group "AOI-f39f1576-b645-4693-b6e9-fe8048bb5636". The exception text is: System.NotSupportedException: Environment is not supported: OS Name: 'Windows Server 2019 Datacenter', OS version: '10.0', OS productType: 'Server', isWorkstation=False at Microsoft.EnterpriseManagement.Mom.Modules.WindowsDefenderATPModule.WindowsDefenderATPModule.VerifySupportedEnvironment(IOperatingSystemInfoHelper osHelper, List`1 supportedEnvironments) at Microsoft.EnterpriseManagement.Mom.Modules.WindowsDefenderATPModule.WindowsDefenderATPModule..ctor(ModuleHost`1 moduleHost, XmlReader configuration, Byte[] previousState)Solved9.5KViews0likes4CommentsRe: Azure Monitor "Upgrade available" doesn't go away
Seshadrr Can't see that the dependency agent gets upgraded. Folder says version 9.10.8.14350 wich is same on servers I haven't tried to upgrade. Can see that the Microsoft.Azure.Diagnostics.IaaSDiagnostics is getting installed when triggering upgrade though: Beginning a Windows Installer transaction: C:\Packages\Plugins\Microsoft.Azure.Diagnostics.IaaSDiagnostics\1.18.0.5\InstrumentationEngine\InstrumentationEngine.Installer.msi If I check with Get-AzOperationalInsightsIntelligencePack I can see that the VMInsights already is enabled. Ran the Set command anyway, nothing happened.2.3KViews0likes1Comment
Recent Blog Articles
No content to show