This was announced at Ignite last week, see here https://azure.microsoft.com/en-us/blog/query-across-resources/ which I missed at the time. Adding the ‘withsource=SourceTable’ I have found to be really useful to see where the data was found. If the returned SourceTable is just “SecurityEvent” as per this example its from your local workspace, if its workspace(”). SecurityEvent // show…Read more
In my first post on parsing we looked for Eventlog data and parsed the info to get User names from with data in the Event log. Sometimes we want to work with a list of values such as User or Computer names and look for these in the data. Jon once again asked for a…Read more
Jon (who also works at Microsoft) was asking me how to use an ‘or’ to filter EventIDs, I thought I’d add some syntax examples. We have seen in the last post that you can get Event or SecurityEvent details. I’ll use SecurityEvents as the example but you can use Events if you prefer. All examples…Read more
Updated: As last night the Settings moved to the Azure portal Today I was looking at Perfmon data for a particular process. In this case it happened to be lsass.exe but only on Domain Controllers. I needed to add this Perfmon Counter to OMS, in Settings – Data – Windows Performance Counters (via the OMS…Read more
Updated: to include some screenshots (as thus wasn’t working the other day) Today I had to look at getting some data from SecurityEvent. This is using the new Log Analytics query language and the Advanced Analytics portal. I was looking at EventID: 5061, but you can use any EventID you like, e.g. SecurityEvent | where…Read more
…then this group is for you https://www.facebook.com/groups/AzureManagementCommunity…Read more
This new language and features was announced here https://docs.microsoft.com/en-us/azure/log-analytics/log-analytics-log-search-upgrade The new documents and samples can be found at https://docs.microsoft.com/en-gb/azure/log-analytics/log-analytics-log-search-new and https://docs.loganalytics.io/…Read more
One of the most interesting set of syntax has been the use of WireData, I’m not really a networking person but they way you can visualise and assess the data is very useful. For all of these replace aDomainName.co.uk with your own FQDN I started to look at traffic from a Subnet and the Remote…Read more
Part 3 I wanted to look at a range of EventIDs (I cant remember why now) but this is how: Type=Event EventID=* | measure count () by EventID | Where (EventID>6000 AND EventID<6500) If you want to look for some specific EventIDs, I was also filtering on the last 24hrs (Note: for the 24hrs scope…Read more
Just a list of distinct computers in the OMS workspace (just returns the count and name rather than all the other details) Computer=* | Distinct Computer A similar list to the above but shows the computers sorted by aggregated value (i.e. sorted by computers that have the most data) Computer=* | measure count () by…Read more
This is a series of posts, which I will update and add to often (I hope), basically I’ve ended up with a OneNote of syntax that I know works in certain key areas of OMS. Looking for % used space (this example and all the rest, require you to add the correct Perf counter in…Read more
https://azure.microsoft.com/en-gb/blog/announcing-new-set-of-azure-services-in-the-uk/ Log Analytics Azure Log Analytics is a service in the Operations Management Suite (OMS) offering that monitors your cloud and on-premises environments to maintain their availability and performance. It collects data generated by resources in your hybrid cloud environments and from other monitoring tools to provide insights and analysis and help you detect and…Read more
