Skip to main content
Azure - Find hint about the IP address using KQL

#cloud #azure

Hi All!

As we are in cloud, we may have a thought / necessitate to find about the public IP details like country, city.

Consider a scenario that one of a storage account in your organization's azure subscription has the public network access as "Enabled from selected virtual networks and IP addresses"

i.e. It can be accessed from the VNet/Subnet associated with and also included Firewall address range (Individual IP when you're working from home).

Now, aforementioned storage account has some individual IP(s), you need to find the last/latest IP added details/Clue.

Azure KQL offers a feature called geo_info_from_ip_address() to get some hint about the public IP like country, city, langtitude etc..

Above mentioned scenrio is just for an example but you can have different scenarios.

Note: This feature is not giving you exact details about IP address

You can got to Logs menu of a azure and try as below

Comments

Post a Comment

Popular posts from this blog

View powershell history and invoke Hi All! When you do administration activities, you may need to work around with multiple commands in powershell. It is bit difficul to remember all the commands we tried because some of them may be fetched from internet. Consider you tried more than 100 commands in current powershell session and may require to try the same large command. One of the way is you can press up arrow many times to see the previously tried command. we have another easy way is to see the history and invoke it by using its order number instead of whole command typing. Please look into the below example
Post a Comment
Read more
Wow! Monitor web apps running in azure VM and VMSS via app insights Hi All! Application insights monitors the telemetry of web applications, function app, APIM and etc., Consider a scenario that your organization has some web applications hosted in IIS of an azure VM and they want to monitor performance of those applications. Azure VM was not the eligible candidate to map with Application insights then how can we monitor app(s) running inside azure VM? Now azure offers the feature of monitoring azure vm's web applications through application insights generally available. Please follow the below steps and have a look into the picture You need to have a connection string of an existing application insights. If have, copy it. Go to the VM which has web apps running in IIS Click "Extension+applications" and then click Add Find Application insights agent for .NET and click next Paste the copied connection string of app insights and click Review+Cre...
Post a Comment
Read more
While loop with head and tail in linux Hi All! In today's post we're going to see/refresh about while loop with head and tail in bash. head - Read the first top 'n' lines. Example: head -n 5 reads first 5 lines from a file or input. tail - Read the last 'n' lines. Example: tail -n 5 reads last 5 lines from a file or input. Please look into the below image we have a txt file called file1.txt which has 3 lines of text and we read using head and tail as above.
Post a Comment
Read more