Blog

Threat Hunting on SQL Server with Azure Sentinel

For years Microsoft SQL Server has served as a backbone of critical applications for enterprises. Due to the nature of critical data stored on the SQL Server databases, it has always been a point of Interest for internal or external adversaries and one of the primary targets for exploitation.

 It is important to monitor all your SQL database instances and servers for any sign of threats.

Last week I posted a detailed blog post on Monitoring SQL Server with Azure Sentinel on Microsoft Azure Sentinel Official Blog. The blog talks about how to ingest logs from SQL Servers running on VMs, Parse the logs in readable format and then run various hunting queries and create alerts

You can read the detailed post here.

The Parser and hunting queries are also uploaded to Azure Sentinel Github repo.




Join me at Microsoft 360 Security Conclave

I’ll be speaking at Microsoft 360 Security Conclave on Integrated Cyber Threat Management last this week, we’ll talk about how modern cyber threats leveraging power of cloud to launch multi-staged attacks and how having an end to end visibility of the attack indicators across Identity, Endpoint, Apps and Infrastructure helps early detection and remediation.

If you are attending this event, please do stop by and say hi.

There are some other distinguished speakers lined up for you from Industry and Microsoft engineering.

See you there.

Iftekhar




Speaking at ET CIO virtual event.



My Session at Digital Governance Tech Summit 2019, New Delhi – Security Considerations for Moving to Cloud.

Digital tech

I’ll be speaking at Digital Governance Tech Summit 2019, New Delhi on

Security considerations while moving to the cloud” –  1615 Hrs, 27th August 2019


In this session, learn about various security considerations organizations to make while moving to cloud, shared responsibilities between cloud provider and end customers.

If you happen to be participating in this conference, please do stop by and say hi.

There are other great sessions in this conference presented by elite Microsoft speakers and other industry veterans like Keynote by Ananth Maheshwari, President Microsoft India and Amitabh Kant, CEO, Niti Aayog, Govt of India.

You can find the list of entire list of sessions and tracks here

I look forward to have some of you in the session and discuss more on your secure cloud journey.

Cheers

Iftekhar




Best Practices in configuring Office 365 Anti Phishing Policy

Office 365 Advanced Threat Protection enables additional layer of protection against malicious URLs, Malicious Attachments and Phishing campaigns.

In my previous posts we talked about these configurations, please click on the hyperlinks below to see those posts.

1. Best practices in configuring Office 365 Safe Attachments

2. Best Practices in configuring Office 365 Safe Links.

Today we’ll take a look at anti phishing policies which can be configured in Office 365 for protection against

  • 1. User Impersonation
  • 2. Domain Impersonation
  • 3. Domain Spoofing

User Impersonation : User Impersonation configuration allows organization to list down their top executives like CEO, CFO, Directors etc and any emails coming with the exact same display name and going to users will be quarantined/delivered to Junk as per the configuration.

Domain Impersonation : Domain Impersonation configuration protects against emails coming with similar typosquatted domains like yours. For eg. your organizations domain is Contoso.com and attackers may send emails after registering similar looking domains like Cont0so.com, Contoso-inc.com etc.

Domain Spoofing :  Domain spoofing configuration enables domain authentication like SPF, DKIM, DMARC to be enforced validating the origin of the emails as per the from address and block/quarantine/junk those emails which fails authentication.

I have created this video tutorial of Step by Step tutorial of the recommended configurations of Anti Phishing Policies in Office 365 Advanced Threat Protection.

Hope you like the videos, please do subscribe to the channel to be updated with future tutorials.

Cheers




Best Practices in configuring ATP Safe Link Policies in Office 365

One of the major attack vector used by threat actors are sending emails with malicious URLs. These emails without any malicious attachments usually has luring text which encourages users to click on a link to take any action and then take them to a Phishing URL or a webpage with malicious content.

For E.g. the email below, which looks like it has come from Microsoft to users and asking users to click on a URL which would lead to

Email

Office 365 Advanced Threat Protection enables Safe Link policy which protects users at the time of click by verifying the URL against threat intelligence for any phishing page or malicious content.

Please watch this video on how to configure Office 365 Safe Links with recommended configurations.

if you want to see a quick demo on how Office 365 Safe works, checkout the following video.

Cheers.




Best Practices in Configuring Office 365 ATP Safe Attachments

Security and End User Experience don’t often go hand in hand, the art is to find the right balance.

I often get asked how should I configure my Office 365 Advanced Threat Protection Safe Attachments policy to achieve maximum protection against modern day threats such as Zero Day Exploits, Macro Based trojans and other specially crafted malicious attachment.

In this video, we’ll go through some of the recommendations on configuring ATP Safe Attachment policy in Office 365.




Getting Spoofed emails delivered ? Common Office 365 Configuration Mistakes

In my previous post, we discussed how to detect Spoofed emails and build defenses against them.

If you were able to relate to some of these emails and you find them getting delivered to your user’s inbox, you may want to check some common misconfigurations on your Office 365 Tenant.

I have create this video to illustrate how these mistakes often open doors for these kind of emails to come in,

Do watch it and share your comments,




Domain Spoofing – Making things difficult for an attacker

Phishing emails comes in many shapes and form. here are various forms of phishing, organizations are currently struggling with :

Types of Phishing

1. Domain Spoofing – In this type of phishing, the email’s from address indicates it has come from reputated domains like Microsoft, Google, Paypal etc and often organization’s own domain but it really has not originated from there servers. Attackers often spoof the domain to make it look like a legitimate emails from these company’s and asking recipients to do a task like verify their account to harvest credential, download and install a file which is malicious, or visit a malicious webpage.

2. Domain Impersonation – In this type of phishing, the attackers registers a similar looking domain as your organization’s or major brands Microsoft etc, For Eg If your Organization’s domain is Contoso.com, attackers would register domains like c0ntoso.com, Cont0so_.com etc and then sends out emails from these domains to your users asking them to carry out a transaction, click on URLs or open an attachment. If users are not paying attention they would never be able to differentiate between original domain name of the organization and “Typosquatted” domain attacker is sending these email from.

3. User Impersonation – In this type of phishing, attackers uses the name of top executive’s names like your CEO, Director, CFO etc and then send email to their subordinates or to the other group of employees and then ask them to carry out a high value activity. These executive’s name usually have high authority which are often not questioned and hence employees falls for it without verifying the identity or the intent of the email.

While this is not a exhaustive list, attackers also use combinations of above techniques to increase their chances of a successful exploitation.

In this post, we’ll talk about Domain Spoofing in details”:

Spoofing a domain and its reputation have been into existence for ages and with the advent of various tools and scripts it has got a lot easier to carry out this attack.

 

 

 

Protection against Spoofed Emails

Create a SPF record for your Organization : –

SPF or Sender Policy Framework is a authentication technique to validate if the email is actually originated from designated server of the domain or not and hence helps in detecting spoofed and forged emails.

If you are an Office 365 Email customers, you can follow these steps to create your SPF Record.

DMARC and DKIM are additional domain authentication techniques you should also look at.

This will ensure if any attackers tries to spoof your domain to send emails to your organization or to others external parties will have their domain authentication failed.

 

If you are an Office 365 Exchange Online Customer, Inbuilt Exchange Online Protection by default protects from domain spoofing by redirecting all the emails to Junk Mailbox folder if the SPF or domain authentication is failed by marking them as High Spam or Spam.

You should definitely check your Anti Spam settings to see how you want Spam and High Spam emails to be treated,

 

SPAM Settings

 

 

 

 

Detecting a Spoofed email

Detecting a spoofed email is never so easy as the from address will have the exact domain name as you’d like it to have. So if an attacker is trying to spoof your own organization’s domain, your users will actually see the correct domain name in the ‘From’ address.

if you take a look at following example of an Spoofed email, the ‘from’ domain is actually showing as Contoso.com which is the legitimate domain of this Organization. So its not that easy to differentiate unless you are ready to dive deep into Header Analysis

Spoofed Email

Yes, you may find additional clue in the email which might seem odd and can help figure it out, you can read my previous post on finding clues for Phishing.

So lets take a look at what are the things you should look at in the email header which can help identify that this is a spoofed email.

Follow this to pull out the message headers if you are using Outlook Client.

If you are using OWA, click on the drop down menu on the right hand side and click on message details.

Header

You may copy the message headers and then paste it to the Microsoft Message Header Analysis tool and hit analyze.

Now lets see what things you should look at:

You should find that domain Authentication like SPF = FAIL.  We’ll learn more about SPF later in this post.

Since the email is not originated from the server of the domain which it says its from, the SPF will be failed.

Also Auth AS value should be showing Anonymous. which means the email is not authenticated with a credentials.

if this email actually had been sent from your domain, the Auth As value should be “Authenticated”

Auth As


Create an Warning Message for all External Email – Mail Tips

Consider creating a caution message on the top of all the emails originating from external servers,  You can use Exchange Online mail flow rules to create these custom notifications, More info on creating disclaimers here

Mail tip

Legitimate Spoofing

Legitimate Spoofing” ? Is that even a thing? why would a spoofing be legitimate?

Well, Yes, there are emails which could be SPF failed but still be legitimate,

No SPF Records :  If you are getting an email from a organizations who have not configured and published their SPF records with their domain registrar, there is no way to authenticate them.

Cloud Hosted Email Service Provider :  If your sender’s email service is hosted on a shared tenant with a cloud service provider, there are chances that the provider cannot provide individual server details for SPF configuration for each and every email tenant.

Marketing and Newsletters : Some organizations outsources their marketing email campaign to third party companies who sends emails on behalf of their clients and hence those emails would look like as Spoof however genuine.

Spoof Intelligence to rescue :

Office 365 Customers can now take a look at the Spoof Intelligence report to see the domain pairs who are sending emails to your organizations and their domain authentication is getting failed. You also have the option to configure if you are okay to have their emails coming in while their domain authentication has failed.

Spoof
Spoof Intelligence

So if you do see a domain here which is sending legitimate emails but getting failed authentication, you can come here and mark them as “Allowed to Spoof” which will ensure optimized mail flow from them.

I hope this post helps un understanding domain Spoofing and how can we make it harder for attackers to bypass the protection.

In my next post, we’ll look at a common configuration mistake which lets these Spoofed emails coming in and getting delivered, specially if the attacker is spoofing your own domain.

Cheers

Iftekhar





My Book Project : Windows 10 for Enterprise Administrators

[Post Migrated from TechNet]

With more and more customers adopting Windows 10 as preferred Operating System as their preferred platform for their Endpoint Devices, the need of upgrading skills for our IT administrators with the know how of new tools, upgrade strategies, deployment of new features/capabilities and ongoing management of Windows 10 devices is definitely catching up.

Windows 10 brings a whole lot of new capabilities both from Manageability and Security perspective for IT administrators.  If you haven’t read some of my previous posts around Security with Windows 10, following articles will give you some insight.

  1. Threat Mitigation in Windows 10
  2. Windows Device Guard against Malware Intrusion

I have been working as Tech Reviewer of this Book on Windows 10 for Enterprise administrators for few months now and its finally got published.
As a Tech Reviewer my responsibility was to ensure that the Technical topics are explained accurately and has consistent information, with working set of scripts and codes.  The sole objective of the book is to help IT administrators with the knowledge of new capabilities, Deployment tools, tips and tricks to manage a Windows 10 environment better.

The Authors did a great job in bringing the right content and concepts to ensure our Windows 10 administrators are successful in their day to day job.

Here are some screenshots of the book preface

Book is available for Sale here :
https://www.packtpub.com/networking-and-servers/windows-10-enterprise-administrators

Hope you all will like it.

Cheers