This post has some KQL to report usage of Internet Explorer. Internet Explorer is end of life Defender for Endpoint is a terrific source of data for IT Operations. Within M365 Defender for Endpoint Advanced Hunting you can build KQL queries to drill down into your data. KQL to find usage of Internet Explorer in your organisation Example KQL find which intranet sites are still frequented by people using Internet Explorer.
This post has some KQL to report CISA Known Exploited Vulns within your environment. First of all, if you have Ukrainian or Russian staff working with you, check-in with them and do what you can to support them and their families at this time. The US Cybersecurity and Infrastructure Security Agency (CISA) leads a national effort to understand, manage, and reduce risk to our cyber and physical infrastructure. They’re maintaining a list of Common Vulnerabilities and Exposures (CVEs) as Known Exploited Vulnerabilities catalog.
This post has some KQL to report “who read the sensitive email and who opened the sensitive attachment”. There are a few audit logs available to build a timeline of what happened with this email (send,recieve,forward) and who interacted with it: Office365 unified audit log (Activity Explorer/CloudAppEvents table) Defender for Office365/Exchange Online Protection mail flow events Defender for Endpoint (DeviceFileEvents) Mailbox audit logs (mail item accessed events) M365 has a Activity Explorer GUI for exploring activity around files.
This post has some KQL to report on files uploaded to cloud via Microsoft or Google browsers. It requires Office365 sensitivity labels, Defender for EndPoint and (for Google Chrome) the Microsoft Compliance extention. M365 has a Activity Explorer GUI for exploring activity around files. If the files have been classified using Office365 sensitivity labels you can focus on your most sensitive documents. This interface is fine for a demo but you’re unable to save the searches and filters for reuse and you’ll want to filter out ‘normal’ approved activity.
Securing Windows PCs starts with managing local administator access. Microsoft Defender for Endpoint logs every login and records if it was a local admin. Use the following KQL query in the Advanced Hunting portal to create a report. Use Active Directory Group Policy to manage the local admins that need to be there for support or management tools. Take care with this policy, one setting removes all admins EXCEPT the ones in the GPO.
Are all your machines encrypted? If a laptop was lost is the data protected or you’ll need to declare. Microsoft Defender for EndPoint (aka ATP) stores Bitlocker status information. Use the following KQL query in the Advanced Hunting portal. The following KQL was inspired by SecGuru_OTX’s twitter post (below) M365 Advanced Hunting: Detect Bitlocker non-compliant Windows 10 devices with "Encrypt all Bitlocker supported drives" setting. pic.twitter.com/YpcNf6NKxe — CISOwithHoodie (@SecGuru_OTX) June 9, 2021 Find more IT Infrastructure tips at blog.