Query
42 TopicsAzure Sentinel correlation rules: the join KQL operator
In the SIEM world, rules are often called correlation rules to stress the role of a SIEM to correlate signals from different sources. In this blog post, I will explain how to implement correlation rules in Sentinel using the join KQL operator.39KViews4likes4CommentsAzure Sentinel correlation rules: Active Lists out; make_list() in, the AAD/AWS correlation example
Writing alert rules using KQL is powerful but does not have to be complicated. A good example would be rules that in traditional SIEM use Active Lists. In this blog post, I will describe how to avoid Active Lists entirely using Sentinel query-based rules.37KViews10likes8CommentsUsing KQL functions to speed up analysis in Azure Sentinel
Security Operations can often be a very repetitive role. As a security analyst, you will often find yourself conducting the same actions and tasks as you work through an investigation. KQL functions in Azure Sentinel provide a way in which analysts can build up a collection of investigation tools to call upon quickly and simply.36KViews3likes4CommentsQuerying multiple Log analytics workspace at once.
Hello folks, We’ve been in Orlando all week at Microsoft Ignite Orlando, and it has been a busy week. Today, I meet with a sysadmin who wanted to know the best option to query multiple Azure Log Analytics workspace. Let's explore the options22KViews4likes5CommentsPower Query freezes in Excel
Hello, I'm having issues editing queries in Excel. Whenever I enter a Power Query window, the window opens but shows no data and all excel sheets freezes. I can highlight the tools but they do not react when I try to click them. Nor can I close the Power Query window. The only way I manage to close excel is by forcing it through task manager in windows. I believe the problem started when I updated excel from verision 1902 to 1907. I have reinstalled office and I am now running version 1908, but the problem is still present. I have tried to access power query in multiple workbooks, but with no success. Has anyone experienced a similar problem? Any suggestions on how to fix this would be very welcome. Thank you for your time!18KViews0likes5CommentsExcel web query DataFormat.Error "not a valid path"
Hi, I have a workbook that grabs data from a few online Excel workbooks. This was working fine from when I set it up about six months ago until recently, when it started producing a DataFormat.Error. One of the data sources that my workbook queries is the Reserve Bank of Australia exchange rates in this file: http://www.rba.gov.au/statistics/tables/xls-hist/2014-current.xls This is the error that I get: DataFormat.Error: 'C:\statistics\tables\xls-hist\2014-current.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Details: 2014-current.xls This used to work just fine with no errors. I've tried on multiple computers with the same issue, and I've tried three other links to publicly available online excel workbooks with the same issue. I've tried adding a new query (by selecting query from workbook or query from web) in a fresh workbook and pasting that link as the source, but I still get the same error. It's weird that the error is referring to a file at C:\ and not the URL that I entered. I'm using MS Office Professional Plus 2016, Excel version 16.0.4266.1001 64 bit. Does anyone know how to get around this issue? Thanks in advance, SimonSolved16KViews0likes10Comments401 (Unauthorized) When calling Sharepoint Query
Hello everyone, I am currently getting this error 401 when I try to call my Sharepoint Endpoint. It occurred after I added the following below into the header. What is the issue here? GET http://www.test.com/Shared%20Documents/query%20result%20BEFORE.xml 401 (Unauthorized) Previously, I was facing this error: Access to XMLHttpRequest at **** from origin 'http://127.0.0.1:1234' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. I added the Access-Control-Allow-Origin with a value of "*" in the HTTP Response Headers and now I am getting the 401 error. Please do help! Thank you!12KViews0likes3Comments